MySQL 계정생성 & 삭제

생성

use mysql;
insert into user (Host, User, Password) values ('localhost', 'j4ckp4rd', password('1234'));
flush privileges;

데이터베이스 생성 & 권한추가

create database mydb; 
grant all privileges on mydb.* to j4ckp4rd@localhost identified by '1234';

삭제 

use mysql;
drop database mydb;
delete from user where user = 'j4ckp4rd';
delete from db where user = 'j4ckp4rd';

루트권한 부여

GRANT ALL PRIVILEGES ON *.* to j4ckp4rd@localhost IDENTIFIED BY '1234' WITH GRANT OPTION;