MySQL GRANT 


grant all privileges on TABLE_NAME.* to 'username'@'xxx.xxx.xxx.xxx' identified by 'password';

flush privileges;

모든 아이피에서 접근 허용하기


grant all privileges on TABLE_NAME.* to 'username'@'%' identified by 'password';

flush privileges;

댓글

댓글 쓰기

이 블로그의 인기 게시물

Using the MinIO API via curl

Using the MinIO API via curl is straightforward, as MinIO is compatible with Amazon S3 API, so most commands follow a similar syntax. Here’s a guide on how to use curl with the MinIO API for some common operations like uploading, downloading, and managing objects. Prerequisites Access Key and Secret Key : Obtain your MinIO Access Key and Secret Key. MinIO Endpoint : Know your MinIO server endpoint, e.g., http://localhost:9000 . Bucket : You may need an existing bucket name, or create a new one using the commands below. Authentication Header For requests to work with MinIO, you need to include authentication in the headers. MinIO uses AWS Signature Version 4 for signing requests. Common Examples 1. List Buckets To list all buckets in your MinIO account, use: curl -X GET \ - -url "http://localhost:9000/" \ - H "Authorization: AWS <AccessKey>:<Signature>" 2. Create a Bucket To create a new bucket, use: curl -X PUT \ - -url "htt...
자세한 내용 보기

Tomcat(톰캣) SSL 포트 설정

https룰 사용하기 위해 톰캣의 server.xml 에 아래의 설정 추가 <Connector port="8443" protocol="org.apache.coyote.http11.Http11Protocol" maxThreads="150" SSLEnabled="true" scheme="https" secure="true" clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8" /> .keystore 생성 [/user@hostname]$ $JAVA_HOME/bin/keytool -genkey -alias tomcat -keypass changeit -storepass changeit -keyalg RSA -keystore ${HOME}/.keystore -dname "CN=localhost, OU=OrgUnit, O=MyCompany, C=KR"
자세한 내용 보기

[Ubuntu] update-alternatives(Symbolic Link 관리)

자바를 새로 설치시에   /home/tech/jdk7 에 설치했다면 java 실행 파일은 /home/tech/jdk7/bin/java 이다. 기존에 리눅스의 기본 자바인 openJDK 를 새로 설치한 자바로 심볼릭링크 변경을 하려면 아래와 같다 # update-alternatives --list java /usr/lib/jvm/java-6-openjdk-i386/jre/bin/java # update-alternatives --install "/usr/bin/java" "java" "/home/tech/jdk7/bin/java" 1 # update-alternatives --config java 대체 항목 java에 대해 (/usr/bin/java 제공) 2개 선택이 있습니다.   선택       경로                                                                 우선순     상태 ---------------------------------------------------------------------------------------------    0            /usr/lib/jvm/java-6-openjdk-i386/jre/bin/java   1061      자동 모드 * 1            /home/tech...
자세한 내용 보기

"Do you happen to"

The phrase "Do you happen to" is a polite and casual way of asking if someone knows or has something, or if they might be able to do something. It softens the tone of the question, making it sound less direct and more friendly or tentative. Examples: "Do you happen to have a pen I could borrow?" This means: "Do you have a pen I could borrow?" but in a more polite and casual way. "Do you happen to know where the nearest coffee shop is?" This means: "Do you know where the nearest coffee shop is?" "Do you happen to be free this weekend?" This means: "Are you free this weekend?" It adds an element of chance or uncertainty, implying that it's okay if the answer is "no."
자세한 내용 보기

About InfluxDB

InfluxDB is an open-source time-series database designed to handle high-write and high-query workloads. It is part of the InfluxData platform, which includes other components like Telegraf (data collector), Chronograf (visualization and monitoring tool), and Kapacitor (real-time streaming and alerting engine). Key features of InfluxDB include: Time-series data storage: InfluxDB is optimized for storing and querying time-stamped data, making it suitable for applications that generate a large volume of time-series data, such as monitoring systems, IoT devices, and financial data. High performance: InfluxDB is built to handle high write and query loads efficiently. It uses a log-structured storage engine, which enables fast writes and allows for efficient data compression and retrieval. SQL-like query language: InfluxDB uses a query language called InfluxQL, which is similar to SQL but tailored for time-series data. It provides functions and operators specific to time-series analys...
자세한 내용 보기

Create reusable templates for page routes in Next.js

Ah, got it! If you're looking to create reusable templates for page routes in Next.js (essentially for different types of pages or dynamic routes), you can use dynamic routing combined with layout components to create a flexible templating system. Here’s how you can structure it: 1. Dynamic Routes in Next.js In Next.js, you can create dynamic routes by using file-based routing . You can define dynamic route segments using square brackets ( [ ] ). For example, to create a dynamic route for a blog post: Example Directory Structure: /pages /posts [id] .js The [id].js file will capture any id passed in the URL as a route parameter. For example, /posts/1 will render the id as 1 , and /posts/2 will render id as 2 . Here’s how you might use dynamic routing to create a page template for different routes: // /pages/posts/[id].js import { useRouter } from 'next/router' ; export default function Post ( ) { const router = useRouter(); const { id } = rou...
자세한 내용 보기

KNN(K-Nearest Neighbors) 활용한 이미지 분류

이미지 분류를 KNN(K-Nearest Neighbors) 알고리즘을 사용하여 구현할 수 있습니다. KNN은 레이블이 있는 데이터를 기반으로 새로운 데이터 포인트의 범주를 예측하는 비지도 학습 알고리즘으로, 이미지 분류에도 사용할 수 있습니다. 하지만 KNN은 이미지와 같이 고차원 데이터를 다룰 때 성능이 떨어질 수 있으며, 비교적 간단한 특징 벡터를 추출한 후 사용해야 효율적입니다. KNN을 사용한 이미지 분류 구현 방법 데이터 준비 및 전처리 이미지 데이터를 수집하고, 각 이미지를 벡터화합니다. 이미지 크기를 조정하고, 그레이스케일 또는 RGB 픽셀 값을 특징 벡터로 변환합니다. KNN 알고리즘을 사용한 분류 Python의 scikit-learn 라이브러리를 활용하여 KNN을 쉽게 구현할 수 있습니다. 1. 데이터 준비 CIFAR-10, MNIST 등의 이미지 데이터셋을 사용하여 예시를 보여줄 수 있습니다. 예를 들어, MNIST 데이터셋을 사용할 경우, 이미지는 28x28 크기의 손글씨 숫자 이미지입니다. from sklearn.datasets import fetch_openml from sklearn.model_selection import train_test_split from sklearn.neighbors import KNeighborsClassifier from sklearn.metrics import accuracy_score import numpy as np # MNIST 데이터셋 로드 mnist = fetch_openml('mnist_784') # 특징 벡터와 레이블 준비 X = mnist. data y = mnist.target # 데이터를 훈련 및 테스트 세트로 분리 (80% 훈련, 20% 테스트) X_train , X_test , y_train, y_test = train_test_split( X , y, test_size= 0.2 , random_st...
자세한 내용 보기

Reactjs datetime range picker

To create a datetime range picker in React, you can use a library such as react-datetime-range-picker . This library provides a customizable date and time range picker component that you can easily integrate into your React application. Here's an example of how you can use it: Install the library using npm or yarn: npm install react-datetime- range -picker Import the necessary components into your React component: import React, { useState } from 'react' ; import DateTimeRangePicker from 'react-datetime-range-picker' ; Create a state to hold the selected date and time range: const [selectedRange, setSelectedRange] = useState({ startDate: null , endDate: null }); Render the DateTimeRangePicker component and handle the selection changes: ```jsx const handleRangeChange = (range) => { setSelectedRange(range); }; return ( ); ``` In the example above, the DateTimeRangePicker component is rendered with the onChange event handler and th...
자세한 내용 보기

Nginx Openssl 설정

인증서 만들기 #openssl req -new -newkey rsa:2048 -nodes -keyout open_ssl.key -out open_ssl.csr Generating a 2048 bit RSA private key ... ... Please enter the following 'extra' attributes to be sent with your certificate request A challenge password []: 테스트를 위한 SSL 인증서 생성 #openssl x509 -req -days 365 -in open_ssl.csr -signkey open_ssl.key -out open_ssl.crt #ls -al -rw-r--r-- 1 root root 1306 Jun 18 11:27 open_ssl.crt -rw-r--r-- 1 root root 1110 Jun 18 11:21 open_ssl.csr -rw-r--r-- 1 root root 1704 Jun 18 11:21 open_ssl.key Nginx 의 SSL 모듈 탑재 확인 #/usr/local/nginx/sbin/nginx -V nginx version: nginx/1.5.8 built by gcc 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) TLS SNI support enabled configure arguments: --prefix=/daum/program/nginx --with-http_ssl_module "--with-http_ssl_module" 부분 없다면 아래 방식으로 Nginx 재설치 # ./configure --prefix=/usr/local/nginx --with-http_ssl_module ... # make && make install Nginx 서버 config 설정 # HTTPS server # serve...
자세한 내용 보기

오늘의 문장2

  I subscribed to a weekly newsletter about upcoming events, which often include concerts and exhibitions that I don't want to miss. 나는 놓치고 싶지 않은 콘서트와 전시회를 자주 포함하는 다가오는 행사에 관한 주간 뉴스레터를 구독했다. We'll update the flight information as soon as the airline confirms the schedule, so that passengers can adjust their plans accordingly. 항공사가 일정을 확인하는 대로 우리는 항공편 정보를 업데이트할 것이며, 승객들은 그에 맞춰 계획을 조정할 수 있다. Police uphold the rule of law, even when facing public criticism, because they believe justice must be maintained at all times. 경찰은 항상 정의가 유지되어야 한다고 믿기 때문에, 대중의 비판에 직면하더라도 법치를 지킨다. He stood upright on the deck, which was swaying with the waves, refusing to give in to fear. 그는 파도로 흔들리는 갑판 위에 똑바로 서서 두려움에 굴하지 않았다. She got superior scores on intelligence tests, which helped her secure a scholarship at a prestigious university. 그녀는 지능 검사에서 우수한 점수를 받아 명문 대학 장학금을 받았다. She didn't believe in supernatural things, even though her friends claimed to have experienced ghosts in the old house. 그녀는 친구들이 ...
자세한 내용 보기