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.*