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;

댓글

댓글 쓰기

이 블로그의 인기 게시물

Create fixed rounded button by Tailwind

To create a fixed, rounded button using Tailwind CSS , you can combine Tailwind's fixed utility (for positioning) with the rounded classes (for rounding the button). This is useful if you want a button that stays in a fixed position on the screen, such as at the bottom-right corner. Here’s how to do it: Example of a Fixed Rounded Button <button class="fixed bottom -4 right -4 bg-blue -500 text-white px -6 py -3 rounded-full shadow-lg"> Fixed Button </button> Explanation: fixed : Positions the button fixed relative to the viewport. It will stay in the same position even when the user scrolls. bottom-4 : Positions the button 1rem (16px) from the bottom of the screen. right-4 : Positions the button 1rem (16px) from the right side of the screen. bg-blue-500 : Sets the background color to blue. text-white : Sets the text color to white. px-6 py-3 : Adds horizontal ( px-6 ) and vertical ( py-3 ) padding for sizing the button. rounded-full : Mak...
자세한 내용 보기

ssh-copy-id in ansible

ssh-copy-id is a command-line tool used to copy your public SSH key to a remote server's authorized_keys file, allowing you to log in to the server without entering a password. Ansible is an open-source automation tool used to manage and configure multiple remote servers simultaneously. In Ansible, you can use the authorized_key module to manage the authorized keys of remote servers. This module allows you to add, remove, or replace SSH keys in a remote user's authorized_keys file. To add your public SSH key to a remote server using Ansible, you can use the authorized_key module. Here's an example playbook that adds your public SSH key to a remote server's authorized_keys file: - name: Add SSH key to authorized_keys hosts: your_server become: true tasks: - name: Install SSH key for current user authorized_key: user: your_username key: " {{ lookup('file', '/path/to/your/public/key/id_rsa.pub') }} " ...
자세한 내용 보기

Install and run an FTP server using Docker

To install and run an FTP server using Docker, follow these steps. We’ll use the popular stilliard/pure-ftpd image, which is a lightweight and widely used FTP server. Step 1: Install Docker Make sure Docker is installed on your machine. If it isn’t, install it using the instructions below: Ubuntu/Debian: sudo apt update sudo apt install docker.io -y Mac: Install Docker Desktop from Docker's website . Windows: Install Docker Desktop from Docker's website . Verify Docker is installed: docker --version Step 2: Pull the FTP Server Docker Image Use the stilliard/pure-ftpd image, which is a simple and effective FTP server. docker pull stilliard/ pure -ftpd Step 3: Run the FTP Server Run the FTP server container using the following command: docker run -d --name ftp-server \ - p 21 : 21 -p 30000 - 30009 : 30000 - 30009 \ - e FTP_USER_NAME=testuser \ - e FTP_USER_PASS=testpass \ - e FTP_USER_HOME= /home/testuser \ stilliard/pure-ftpd Explanation...
자세한 내용 보기

Creating an synchronous HTTP request using Spring RestTemplate

While RestTemplate is now in maintenance mode and WebClient is recommended for new applications, it’s still widely used in existing projects. Here’s how you can configure and use RestTemplate in a Spring Boot application: 1. Add Dependencies Ensure the following dependency is present in your pom.xml : < dependency > < groupId > org.springframework.boot </ groupId > < artifactId > spring-boot-starter-web </ artifactId > </ dependency > 2. Configure a RestTemplate Bean Define a RestTemplate bean in a configuration class to enable dependency injection: import org.springframework.boot.web.client.RestTemplateBuilder; import org.springframework.context. annotation .Bean; import org.springframework.context. annotation .Configuration; import org.springframework.web.client.RestTemplate; @Configuration public class RestTemplateConfig { @Bean public RestTemplate restTemplate(RestTemplateBuilder builder) { ret...
자세한 내용 보기

Read a file in Java, 자바 파일 읽기

To convert a File object into an InputStream in Java, you can use the FileInputStream class. Here's an example: import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; public class FileToInputStreamExample { public static void main(String[] args) { File file = new File( "path/to/file.txt" ); try { InputStream inputStream = new FileInputStream(file); // Use the inputStream as needed... // Close the inputStream when you're done inputStream.close(); } catch (IOException e) { e.printStackTrace(); } } } In the code above, replace "path/to/file.txt" with the actual path to your file. The FileInputStream class is used to create an input stream from the file. You can then use the inputStream object to read the contents of the file or perform any other operations you need. Finally, rem...
자세한 내용 보기

difference between truncate and truncate_preserve in hbase

In HBase, both truncate and truncate_preserve commands are used to delete all the data in a table, but they behave differently in terms of how they handle the table’s schema and regions. 1. truncate Purpose : Deletes all data and regions in a table and then recreates it with the same schema. What It Does : When you run truncate , it: Disables the table. Deletes all data and metadata (including region splits) in the table. Drops all regions and recreates the table as a single region with the original schema. Re-enables the table. Effect on Regions : After truncate , all region splits are lost, so the table will start with only one region. This is useful for development or quick data purging but is inefficient for large tables that rely on pre-split regions for load balancing. Command Syntax : truncate 'table_name' 2. truncate_preserve Purpose : Deletes all data in a table but preserves the table’s regions and schema. What It Does : When you use truncate_...
자세한 내용 보기

Using venv in Python

Using venv in Python allows you to create a virtual environment, which is an isolated environment to manage dependencies for a specific project. Here's how you can use it step by step: 1. Create a Virtual Environment Open your terminal or command prompt. Navigate to the folder where you want to create the virtual environment. Run the following command: python -m venv myenv Replace myenv with the name you want for your virtual environment. This will create a directory named myenv containing the virtual environment. 2. Activate the Virtual Environment Activation depends on your operating system: On Windows : myenv \S cripts \a ctivate On macOS/Linux : source myenv /bin/ activate After activation, your terminal prompt will change, showing the name of the virtual environment (e.g., (myenv) ). 3. Install Dependencies With the virtual environment activated, you can now install packages using pip : pip install package _n ame For example: pip install req...
자세한 내용 보기

Parasite of korean movie

"Parasite" directed by Bong Joon-ho. It won four Academy Awards, including Best Picture, Best Director, Best Original Screenplay, and Best International Feature Film. "Parasite" is a dark comedy-thriller that explores the theme of class conflict in modern-day South Korea. The film follows the impoverished Kim family as they infiltrate the wealthy Park family's home and try to improve their own lives by exploiting the situation. But as their plan unfolds, things start to spiral out of control, leading to unexpected and shocking consequences. It's a brilliantly crafted film with outstanding performances, a captivating storyline, and thought-provoking themes. It's definitely worth watching!
자세한 내용 보기

Getting start with Puppeteer

To develop a program that collects data from a Single Page Application (SPA) using Puppeteer, you'll need to install Puppeteer and set up a script that navigates the SPA, interacts with elements, and extracts the desired data. Puppeteer is a Node.js library that provides a high-level API to control Chrome or Chromium browsers. Follow the steps below to create your data collection program: Step 1: Set up Node.js and Puppeteer Make sure you have Node.js installed on your machine. If not, download and install it from the official website ( https://nodejs.org/ ). Create a new Node.js project by running the following commands in your terminal: mkdir spa_data_collector cd spa_data_collector npm init - y npm install puppeteer Step 2: Create the data collection script Create a new file in the project directory, e.g., dataCollector.js , and add the following code: const puppeteer = require ( 'puppeteer' ); ( async ( ) => { try { // Launch the browser const...
자세한 내용 보기