1. 通过phpmyadmin修改mysql数据库的user表
2. 通过mysql命令行
grant all privileges on *.* to 'username'@remote_host identified by 'password' with grant option
flush privileges
eg:
grant all privileges on *.* to 'root'@10.10.104.46 identified by '' with grant option
flush privileges