MySQL 원격 접속을 위한 GRANT 설정

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;