Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to solve the error code 10038 in navicat remote connection". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Navicat remote connection mysql error 10038 is generally due to the following two reasons:

One: local firewall problem

Set up the firewall when mysql and navicat are installed locally and the mysql service is turned on.

First, right-click or click the inbound rule, find the new rule, and click.

Click the port.

Fill in 3306 in the specific local port.

Keep clicking on the next step.

You can give a good name here.

You can try to connect before, but if you still can't, it may be a server problem.

Two: server port 3306 is not open

First of all, you need to open the port in the security group.

I am using the Ali cloud server here. First of all, you need to enter the CVM and find the security group.

Go inside and find the configuration rules.

Then add it quickly and add port 3306.

After that, enter the instance list again under the CVM, and click remote connection to enter the server terminal.

Then type firewall-cmd-- query-port=3306/tcp on the command line

If no is shown here, you need to have the firewall open port 3306:

1. Open port 3306

Firewall-cmd-zone=public-add-port=3306/tcp-permanent

two。 Restart the firewall

Firewall-cmd-reload

View ports that are already open

Firewall-cmd-list-ports

Then you need to have mysql enable remote access:

1. Log in to mysql (if you forget the database password, read on)

Mysql-u root-p

two。 Set the access address (I can connect successfully without setting it in practice)

If you want to allow the user root to connect to the mysql server from the host with ip 192.168.1.123, and use root as the password GRANT ALL PRIVILEGES ON *. * TO 'root'@'192.168.1.123'IDENTIFIED BY' password' WITH GRANT OPTION

3. Refresh

Flush privileges

If you forget your password when logging in to mysql in step 1 above, you can do the following.

(the following mainly comes from: the solution of forgetting password for mysql under linux)

1. Check whether the mysql service is started, and if so, shut down the mysql service

Run the command: ps-ef | grep-I mysql

If it is on, run the closed command: service mysqld stop

two。 Modify the configuration file my.conf of mysql

Generally, under the / etc directory, run the command: vi / etc/my.cnf, edit the file,

Add a sentence under the [mysqld] tag of the file: skip-grant-tables

And then wq! Save exit.

3. Restart the database

Run the command: service mysqld start

4. Access to the mysql database

Run the command: mysql-u root

5. Modify the password

Run statement: use mysql

Continue running the statement: update mysql.user set authentication_string=password ('root_password') where user='root'

Replace root_password with the password you want

6. Delete what was added in step 2, restart the server, and log in to the server using the password you just changed.

At this point, it's all over.

"how to solve the navicat remote connection error code 10038" is introduced here, thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.