[MySQL] DB 생성

MySQL 5.7 이상

CREATE USER joooahn@localhost IDENTIFIED BY '1234' PASSWORD EXPIRE NEVER;

GRANT ALL PRIVILEGES ON 스키마명.* TO joooahn@localhost;
flush privileges;

drop user joooahn@localhost;

 

 

 

MySQL 5.7 미만

CREATE DATABASE homestead CHARACTER SET utf8 COLLATE utf8_bin;
  
GRANT ALL PRIVILEGES ON homestead.* TO 'homestead'@'localhost' IDENTIFIED BY 'secret';
 
flush privileges;

 

 

참고 :

https://www.lesstif.com/pages/viewpage.action?pageId=24445981