db/mysql

mysql 관리자 원격 접속 문제

C/H 2013. 7. 24. 09:30

insert into user (host,user,password) values('%','root',password('-password-'));
grant all privileges on *.* to 'root'@'%' identified by '-password-' with grant option;
-- grant select, insert, update, create, drop, reload, shutdown, alter, super, lock tables, replication client on *.* to 'backup-user'@'localhost' identified by '-password-';
-- grant select, insert, update, create, drop, reload, shutdown, alter, super, lock tables, replication client on *.* to 'root'@'%' identified by '-password-';
flush privileges;

grant select, insert, update, create, drop, reload, shutdown, alter, super, lock tables, replication client on *.* to 'backup'@'localhost' identified by '-password-';

반응형