DEV Community

sunj
sunj

Posted on

mysql 계정 생성, 2022-06-07

#mysql
  1. MYSQL 계정 생성 
create user '계정ID'@'localhost' identified by '비밀번호';
Enter fullscreen mode Exit fullscreen mode
  1. 모든 권한 부여 
grant all privileges on *.* to '계정ID'@'localhost';
Enter fullscreen mode Exit fullscreen mode
  1. 권한 적용 
FLUSH PRIVILEGES;
Enter fullscreen mode Exit fullscreen mode
  1. MYSQL 데이터베이스 만들기 
CREATE DATABASE 데이터베이스 이름;
Enter fullscreen mode Exit fullscreen mode

Top comments (3)

Collapse
 
sunj profile image
sunj •

create user '계정ID'@'%' identified by '비밀번호'; 외부접근허용 계정

Collapse
 
sunj profile image
sunj •

use 데이터베이스 이름; 데이터베이스 사용

Collapse
 
sunj profile image
sunj •

drop database 데이터베이스 이름; 삭제하는 기능

Read next

amaraiheanacho profile image

The Boomi community you didn't know you needed

Amarachi Iheanacho -

karandaid profile image

Optimizing Database Scalability in Microservices

Karandeep Singh -

mdarifulhaque profile image

2441. Largest Positive Integer That Exists With Its Negative

MD ARIFUL HAQUE -

dexterxt profile image

Building a Trader Bot with Sentiment Analysis: A Step-by-Step Guide

Dexter -