登陆mysql (用cmd进入到mysql安装的bin目录下),
输入:mysql -u root -p 回车后再输入密码 (或者使用Navicat for MySQL进入命令界面 )
再执行:
mysql >grant all privileges on *.* to root@"%" identified by "Passwd";
mysql >flush privileges;
-------------------------------------------------------
原文地址:http://blog.youkuaiyun.com/qq247300948/article/details/23551811