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

반응형

'db > mysql' 카테고리의 다른 글

mysql root 비번 분실  (0) 2013.09.24
mysql trigger signal  (0) 2013.08.26
MySQL Trigger 테이블당 하나의 Event Trigger  (0) 2013.01.22
Mysql TIMESTAMP 여러 컬럼 사용  (0) 2013.01.21
mysql 5.5.x my.cnf 참고  (0) 2012.09.13