create database testdb
insert into user (Host, User, Password) values('%', '유저ID', password('패스워드'))
insert into user (host, user, password) values('localhost','유저ID',password('패스워드'));
insert into db values('%', 'testdb', '유저ID', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y','Y','Y','Y','Y','Y');
insert into db values('localhost', 'testdb', '유저ID', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y','Y','Y','Y','Y','Y');
update user set Select_priv ='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y';
GRANT ALL PRIVILEGES ON *.* to 유저ID@"%" IDENTIFIED BY 'testdb' WITH GRANT OPTION;
flush privileges
insert into user (Host, User, Password) values('%', '유저ID', password('패스워드'))
insert into user (host, user, password) values('localhost','유저ID',password('패스워드'));
insert into db values('%', 'testdb', '유저ID', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y','Y','Y','Y','Y','Y');
insert into db values('localhost', 'testdb', '유저ID', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y','Y','Y','Y','Y','Y');
update user set Select_priv ='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y';
GRANT ALL PRIVILEGES ON *.* to 유저ID@"%" IDENTIFIED BY 'testdb' WITH GRANT OPTION;
flush privileges






18218
1
7












댓글을 달아 주세요