티스토리 뷰

System Story/Database

MySQL 원격 접속을 위한 GRANT 설정

불량펭귄 helperchoi 2013. 11. 10. 23:42

use mysql;

grant all privileges on *.* to 'root'@'%';

flush privileges;


update user set host = '%' where user = 'mysql';
 
grant all on test.* to 'mysql';

select host, user, select_priv, update_priv, delete_priv  from user;

반응형
댓글
댓글쓰기 폼