GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'rootpasswd' WITH GRANT OPTION; 如果 root@后边的%改变成固定的ip则就是只允许该ip进行登录