GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY '123456' with grant option;(假设密码为123456)
1.远程用户可以将localhost 改为%
2.只对某一个数据库可以将*.* 改为 xx.*
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY '123456' with grant option;(假设密码为123456)
1.远程用户可以将localhost 改为%
2.只对某一个数据库可以将*.* 改为 xx.*