Shulou(Shulou.com)06/01 Report--

This article is to share with you about how to report an error 10038 in navicat. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

After configuring the newly-built database of Navicat, it always prompts a 10038 error during the point connection test, and cannot enter the database. Upload a file of PHP connection to the database in the server. Test, the server can access mysql normally, and the cmd dos window of win is used to test. You cannot use the external network to access mysql, that is, the private network of the server can be accessed normally, but the public network is not available. Specific solutions:

Set up the mysql service to allow public network access, and modify the configuration file of mysql, either my.ini or my.cnf [Linux].

1: set the configuration file for mysql

/ etc/mysql/my.cnf

Find bind-address = 127.0.0.1 and comment it out; / / the purpose is to make it no longer only allowed for local access

It can also be changed to bind-address = 0.0.0.0

Restart mysql:/etc/init.d/mysql restart

2: log in to the mysql database on Linux: mysql-u root-p

Mysql > use mysql

Query the host value:

Mysql > select user,host from user

If there is no host value of "%", execute the following two sentences:

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

Mysql > flush privileges

This is the revised situation.

After the modification, I tested or prompted the same error, and later found that the firewall of the server was not turned off. After turning off the firewall, I was able to connect normally.

Attach the opening / closing method of the firewall

Opening and closing methods of LINUX Firewall

1) take effect after restart

Enable: chkconfig iptables on

Turn off: chkconfig iptables off

2) effective immediately and expire after restart

Enable: service iptables start

Turn off: service iptables stop

It is important to note that you can use the above command to enable and close other services under Linux.

When the firewall is enabled, make the following settings to open the relevant port

Modify the / etc/sysconfig/iptables file to add the following:

-A RH-Firewall-1-INPUT-m state-- state NEW-m tcp-p tcp-- dport 80-j ACCEPT

-A RH-Firewall-1-INPUT-m state-- state NEW-m tcp-p tcp-- dport 22-j ACCEPT

Thank you for reading! This is the end of this article on "what to do with navicat error 10038". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.