MySQL Remote connection error 10038--navicat for MySQL (10038)

Known as one of the most popular open source database, MySQL is widely used in various scenarios, Alibaba Cloud provides high available ApsaraDB RDS for MySQL with enhanced MySQL service reduced enterprise’s database expenses, and helped enterprises utilize technology to fight against novel coronavirus.

MySQL Remote connection error 10038--navicat for MySQL (10038)

Reprint: http://blog.csdn.net/chana1101/article/details/39641415

Http://www.cnblogs.com/ohmydenzi/p/5521121.html

When the MySQL 5.7 database is installed under Ubuntu server16.04.1 and then connected via Navicat for MySQL under Windows, the Can ' t connect to MySQL server on xxx.xxx.xxx.xx appears X (10038) of the problem.

The solution is as follows:

1. Authorization

Mysql>grant all privileges on * * to ' root ' @ '% ' identified by ' Youpassword ' with GRANT option;

Mysql>flush privileges;

2, modify the/ETC/MYSQL/MYSQL.CONF.D (the old version is this directory:/etc/mysql/my.conf)

Find bind-address = 127.0.0.1 this line

Change to bind-address = 0.0.0.0

If it is not resolved, the remote port (3306) may not be open.

Reference: http://jingyan.baidu.com/article/63acb44add614761fcc17ec2.html

MySQL Remote connection error 10038--navicat for MySQL (10038)