Mysql 4.X 5.X 유저추가 및 DB 설정

(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;