1.update user set host='%' where user ='root';
2.FLUSH PRIVILEGES;
3.ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
4.FLUSH PRIVILEGES;
1.update user set host='%' where user ='root';
2.FLUSH PRIVILEGES;
3.ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
4.FLUSH PRIVILEGES;