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)