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

This article will explain in detail the solution to the 2013 error of navicat connection database report. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

A 2013 error occurred in the local ssh connection, as shown below:

Adopt conventional and SSH matching connection

Note: the SSh connection is used to connect to the server, while the regular connection is used to connect to the MySQL database in the server (where the user name and password of the SSH connection is service (the default is root), and the user name and password in general is the user name and password set by the installation MySQL).

1. Connect to the MySQL in the server

The connection name here is arbitrary, ip is 127.0.0.1; the port is 3306, the user name is root, and the password is the login password when you type msql-u root-p; make sure the user name and password are correct.

two。 Then click SSH

The IP here is the IP of the server, the default port is 22, and the username and password are the username and password of the remote connection server (default is root); make sure the username and password are correct, and click to test the connection.

Note: if not, please check your password, or comment out bind-address = 127.0.0.1 in vim / etc/mysql/my.cnf in your MySQL configuration.

Finally, you can manipulate the database on the server locally!

About "navicat connection database report 2013 error solution" this article is shared here, 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, please share it out 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.