MySQL DB생성 및 계정추가

MySQL Database 생성

 

create database database_name default character set utf8;

 

 

계정추가

 

1. local에서만 연결할 경우
   grant all privileges on dbname.* to user_name@localhost identified by 'password' with grant option;
   
   

2. 원격서버에서도 접근가능
   grant all privileges on dbname.* to user_name@'%' identified by 'password' with grant option;