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

This article mainly introduces the navicat connection database failure report 10038 error solution, the article is very detailed, has a certain reference value, interested friends must read it!

Problem solving of remote connection to mysql (10038)

1. User rights issues

Connect to linux and log in to the database: mysql-uroot-p

Modify the remote login permissions of the root user:

If you want myuser to connect to the mysql server from any host using mypassword

Myuser is your user name and mypassword is your password

Use mysql;GRANT ALL PRIVILEGES ON *. * TO 'myuser'@'%' IDENTIFIED BY' mypassword' WITH GRANT OPTION;flush privileges;quit

2. My.cnf file configuration

Comment out the option skip-networking (note: some materials also say that bind-address is set to 127.0.0.1, but I didn't see this sentence in my configuration file, so I didn't set it. This option is used to set the IP that can access the Mysql externally, has a filtering effect, and is not necessary.

Skip-networking

When running MySQL on a stand-alone machine, use skip-networking to turn off the TCP/IP connection mode of MySQL. When this option is enabled, MySQL cannot be accessed remotely.

Bind-address

For security reasons, if you want the specified IP to access MySQL, you can add bind-address=IP to the configuration file, as long as skip-networking is turned off

Vi / etc/my.cnf

Save exit esc:wq

3. Check to see if the firewall has blocked port 3306. Centos system, in / etc/sysconfig/iptables, is there such a sentence:

-An INPUT-p tcp-m tcp-dport 3306-j ACCEPT is not added, or the following ACCEPT is DROP, just change it to ACCEPT

Vi / etc/sysconfig/iptables save exit esc:wq

4. Restart the firewall and mysql

Service iptables restart service mysql restart above is "navicat connection database failure report 10038 error solution" all the contents of this article, thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.