(Mysql 4.X)

insert into user (host,user,password) values ('localhost','유저아이디',password('패스워드'));

flush privileges;


INSERT INTO db VALUES('%', '유저아이디', '유저아이디', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'Y', 'Y');

flush privileges;



(Mysql 5.X)

INSERT INTO mysql.user(User, Host, Password, ssl_cipher, x509_issuer,
x509_subject) VALUES('유저아이디', 'localhost',
Password('패스워드'), '', '', '');
flush privileges;

INSERT INTO mysql.db VALUES('localhost', '유저아이디', '유저아이디', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'Y', 'Y','Y','Y','Y','Y','Y');

flush privileges;