#进入mysql 使用root用户
mysql mysql -uroot -p
#查询当前用户列表select user,host from mysql.user;#更新用户属性
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyPassword' WITH GRANT OPTION;#保存修改
FLUSH PRIVILEGES;#保存修改#退出mysqlexit#重启mysql服务器service mysql restart
mysql安装部分安装部分参考连接mysql远程访问开启mysql远程访问#进入mysql 使用root用户mysql mysql -uroot -p#查询当前用户列表select user,host from mysql.user;#更新用户属性GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyPassword' WITH GRANT OPTION;#保存修改FLUSH PRIVILEGES; #保存修改#退