2009. 7. 28. 18:25

[Programming][MySQL] User 추가하기.


use mysql;

create database dbname;

insert into user(user, host, password, ssl_cipher, x509_issuer, x509_subject) VALUES('username', 'localhost',password('password'), '', '', '');

// 권한 주기
insert into db values('localhost', 'dbname', 'username', 'Y', 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

// 업뎃. (안하면 적용 안됨)
flush privileges;