How to solve the connection between the client and the server (mysql): "xxx. xxx" is not allowed to connect to this mysql server

1. Go to mysql and create a new user, xuys. Format: grant permission on Database Name. table name user @ login host identified by "User Password"; grant select, update, insert, delete on *. * to xuys@192.168.88.234 identified by "xuys1234"; view the result, execute: use mysql; select host, user, password from user; you can see that the created xuys user already exists in the user table. The host field indicates the host to be logged on. The value can be an IP address or a host name. Changing the value of the host field to % indicates that the host can be logged on to the mysql server as an xuys user on any client, we recommend that you set it to % during development. Update user set host = '%' where user = 'xuys ';
2../mysqladmin-uroot-p21century reload./mysqladmin-uroot-p21century shutdown
3../mysqld_safe -- user-root & remember: any modifications to the authorization table must be reloaded, that is, step 1 is executed. If you still cannot connect from the client after the preceding three steps, perform the following operations to insert a record in the database table of the mysql database: use mysql; insert into db values ('100. 192. 168.88.234 ',' % ', 'xuys', 'y ', 'y', 'y'); update db set host = '%' where user = 'xuys '; repeat steps 2nd and 3 above.