mysql> USE mysql;
SELECT * FROM USER WHERE USER='root' AND HOST='%'; ----这个是远程访问账号
UPDATE USER SET PASSWORD=PASSWORD('123456') WHERE USER='root' AND HOST='%';
FLUSH PRIVILEGES;
mysql> USE mysql;
SELECT * FROM USER WHERE USER='root' AND HOST='%'; ----这个是远程访问账号
UPDATE USER SET PASSWORD=PASSWORD('123456') WHERE USER='root' AND HOST='%';
FLUSH PRIVILEGES;