Solve the problem that the mysql client cannot be accessed by IP addresses.

Solve the problem that mysql clients cannot access using IP addresses: usemysql; selecthost, userfromuser; usemysql; updateusersethost % whereuserroot; selecthost, userfromuser; FLUSHPRIVILEGES;

Solve the problem that mysql clients cannot access through IP addresses. use mysql; select host, user from user; use mysql; update user set host = '%' where user = 'root'; select host, user from user; flush privileges;

Solve the problem that the mysql client cannot be accessed by IP addresses.

Use mysql;
Select host, user from user;
Use mysql;
Update user set host = '%' where user = 'root ';
Select host, user from user;
Flush privileges;