How to remotely log on to MySQL Server in Linux

In Linux, if you attempt to log on to the MySQL Server using the MySQL Adminstrator GUI Tool, the Server returns the following error message: Host '60-248-32-13.hinet-ip.hinet.net 'is not allowed to connect to this MySQL server.

This is because of permission issues. The solution is as follows:

Shell> mysql -- user = root-p

Enter Password

Mysql> use mysql

Mysql> grant select, INSERT, UPDATE, delete on [db_name]. * TO [username] @ [ipadd] identified by '[password]';

[Username]: User code for remote login

[Db_name]: indicates the name of the database to be opened to the user.

[Password]: User password for remote login

[Ipadd]: The DNS Name after IP address or IP address reverse lookup. In this example, enter '60-248-32-13.hinet-ip.hinet.net '. Enclose the quotation marks (')

(In fact, it is executed on the remote server. Fill in the IP address of the local host .)

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

I have encountered some problems with MySQL over the past two days, so I am afraid to forget it. Put it up and keep it for backup.

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 and 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 log on to. The value can be an IP address or a host name,

Changing the value of the host field to % indicates that you can log on to the mysql server as an xuys user on any client machine. We recommend that you set the value 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 modification to the authorization table must be reload again, that is, step 1.

If you still cannot connect from the client after the above three steps, perform the following operations to insert a record in the db table of the mysql database:

Use mysql;

Insert into db values ('2017. 168.88.234 ',' % ', 'xuys', 'y ', 'y', 'y ');

Update db set host = '%' where user = 'xuys ';

Repeat steps 2nd and 3 above.