Solve the problem that Navicat cannot connect to the MySQL server in the Centos system in VMware

Solution to Host 'xxxx' is not allowed to connect to this MySQL server

Error: 1130 -Host *** is not allowed to connect to this MySQL server

There is also an error with the IP here. I entered 192.168.117.101 but it was reported as 192.168.117.1

There are many possible reasons why the connection fails. If the error message above is displayed, the following is the solution. If not,

Possible reasons include: Network is not connected, article link: Centos sets static IP and connects to the external network,

The Linux server firewall does not open the mysql port: turn off the Centos firewall

For Ubuntu, you can also refer to the above two blogs. You can also look for it in my column, you should be able to find it.

Directly on the solution:

First log in to mysql in the virtual machine

mysql -u root -p

Enable mysql

use mysql;

Allow remote connections Authorization

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your root password' WITH GRANT OPTION;

It is best to refresh the permissions; it may take effect even without refreshing.

flush privileges;

Then test the connection and you will find it successful

This is the end of this article about solving the problem that Navicat cannot connect to MySQL server in Centos system in VMware. For more related content about Navicat cannot connect to VMware MySQL server, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!