When logging on to mysql remotely, the following error occurs: messagefromserver: & quot; Hostisnota

1. Change the table method. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log on to the computer of localhost. After logging on to mysql, change the host entry in the user table in the mysql database and rename it as "%" to log on to the database from localhost: mysql-uroot-pvmwaremysqlusemysql;

1. Change the table method. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log on to the computer of localhost. After logging on to mysql, change the host entry in the user table in the mysql database and change the name from localhost to % log on to the database: mysql-u root-pvmware mysqluse mysql; mysqlupdate user se

1. Change the table method.

It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql on the computer of localhost, and change the "host" entry in the "user" table in the "mysql" database to "%" from "localhost"

Log on to the database: mysql-u root-pvmware

Mysql> use mysql;

Mysql> update user set host = '%' where user = 'root ';

Mysql> select host, user from user;

Mysql> FLUSH RIVILEGES

2. Authorization method.

(1) For example, if you want myuser to use mypassword to connect to the mysql server from any host.

Step 1: Log On As the root user; mysql> mysql-u root-p rootpassword;

Step 2: GRANT permissions; mysql> grant all privileges on *. * TO 'myuser' @ '%' identified by 'mypassword' with grant option;

Step 3: mysql> flush privileges;

(2) If you want to allow myuser to connect to the mysql server from a host with ip address 192.168.1.3, and use mypassword as the password

Mysql> grant all privileges on *. * TO 'myuser' @ '192. 168.1.3 'identified BY 'mypassword' with grant option;

Mysql> flush privileges;

(3) If you want to allow myuser to connect to the dk database of the mysql server from a host with ip address 192.168.1.3, and use mypassword as the password

Mysql> grant all privileges on dk. * TO 'myuser' @ '192. 168.1.3 'identified BY 'mypassword' with grant option;

Mysql> flush privileges;