간단한 DB 계정 생성

create database if not exists [Database name];
grant usage on *.* to [DB User]@localhost identified by "[DB Password];
grant all on [DB Name].* to [DB User]@localhost;
flush privileges;

 

 

EX)

create database if not exists netfu_db;
grant usage on *.* to netfu_user@localhost identified by "netfu_password";
grant all on netfu_db.* to netfu_user@localhost;
flush privileges;