修改权限:
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