Home > Database > Navicat > body text

Navicat reports 2013 error

angryTom
Release: 2019-08-07 11:47:21
Original
8072 people have browsed it

Navicat reports 2013 error

navicat connects to the remote database, a 2013 error solution occurs

Recommended tutorial;MySQL database introductory video Tutorial

Navicat reports 2013 error

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

Navicat reports 2013 error

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

Navicat reports 2013 error

==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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!