1.链接远程Linux服务器
2.然后输入 ->
mysql -u root -p
回车会出现 Enter password: 然后将我们的root用户密码输入进去再次回车
3.切换到mysql数据库 ->
use mysql
4.查看一下现有用户及连接权限 ->
select user, password, host from user
5.添加一个root用户,密码暂时为空,允许任意Ip访问’%’ ->
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '' WITH GRANT OPTION
也可以直接添加root用户时添加密码 ->
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION
6.修改一下root用户的密码 ->
update user set password=PASSWORD('123456') where user='root'
7.刷新一下mysql的权限 ->
flush privileges