转自 :http://blog.itpub.net/29660208/viewspace-1185990/
GRANT ALL PRIVILEGES ON *.* TO 'root'@'本地Ip' IDENTIFIED BY '数据库密码' GRANT ALL PRIVILEGES ON *.* TO 'root'@'本地Ip' IDENTIFIED BY '数据库密码'
flush privileges
GRANT ALL PRIVILEGES ON *.* TO 'root'@'本地Ip' IDENTIFIED BY '数据库密码' GRANT ALL PRIVILEGES ON *.* TO 'root'@'本地Ip' IDENTIFIED BY '数据库密码'
flush privileges
![](https://i-blog.csdnimg.cn/blog_migrate/859a00a593a78ed7fe31566497e68852.png)