启动黑窗口,进入到mysql安装的bin路径下
输入命令进入mysql:mysql -u root -p
然后输入密码,登录mysql
查看默认数据库:show databases;
选择mysql数据库:use mysql
查看MySQL用户及权限:select host, user, authentication_string, plugin from user;
更改root权限为'%':update user set host = '%' where user ='root';
刷新权限:flush privileges;
再次查看MYSQL的root用户权限,发现已经更改了