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