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 |