2、linux mysql修改权限

修改权限：
1、mysql -uroot -p 登录

2、select host ,user from mysql.user;

±----------±--------------+
| host | user |
±----------±--------------+
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
±----------±--------------+

2、grant all privileges on . to root@’%’ identified by ‘123456’;

3、flush privileges;

4、 select user,host from mysql.user;

±--------------±----------+
| user | host |
±--------------±----------+
| root | % |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
±--------------±----------+

5、 update mysql.user set authentication_string=password(‘123456’) where user=‘root’; #更改所有用户密码

6、flush privileges;

7、exit