关于MYSQL客户端连不上 mysql服务器 修改表

use mysql;

update user set host = '%' where user = 'root';

flush privileges;

-----------------------------------------------------------------------------

grant all privileges on *.* to 'root'@'%' identified by '你想要的密码';

--------------------------------------------------------------------------------

修改密码

mysql> update mysql.user set password=PASSWORD(‘新密码’) where User=’root’;­

mysql> flush privileges;­

mysql> quit­