Navicat reports 2013 error
Aug 07, 2019 am 11:47 AMnavicat connects to the remote database, a 2013 error solution occurs
Recommended tutorial;MySQL database introductory video Tutorial
Use regular and SSH connection
==Note: SSh connection is Used to connect to the server, while the regular connection is used to connect to the MySQL database in the server (the username and password for the SSH connection here are for the service (the default is root), and the regular username and password are the username and password set by the MySQL installation Password)==
1. Connect to MySQL in the server
The connection name here is arbitrary, the ip is 127.0.0.1; the port is 3306, and the user name is root , the password is the login password when you enter msql -u root -p
; make sure the username and password are correct
2. Then click SSH
The IP here is the IP of the server. The default port is 22. The username and password are the username and password for remote connection to the server (the default is root); make sure the username and password are correct and click Connection Test
==Note: If unsuccessful, please check your password, or vim /etc/mysql/my.cnf
in your MySQL configuration Comment out bind-address = 127.0.0.1)
==
and finally you can operate the database on the server locally!
The above is the detailed content of Navicat reports 2013 error. For more information, please follow other related articles on the PHP Chinese website!

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How to adjust the interface font size in navicat

How to export the er diagram of navicat

How to copy database to another database in navicat

How to export table structure to word using navicat

How to recover accidentally deleted table in navicat

How to undo the previous step in navicat

Which one is easier to use, navicat or datagrip?
