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-';
반응형