Home Database navicat Navicat reports 2013 error

Navicat reports 2013 error

Aug 07, 2019 am 11:47 AM
navicat

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!

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

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to adjust the interface font size in navicat How to adjust the interface font size in navicat Apr 24, 2024 pm 04:24 PM

How to adjust the interface font size in navicat

How to export the er diagram of navicat How to export the er diagram of navicat Apr 24, 2024 pm 04:21 PM

How to export the er diagram of navicat

Where is the navicat cache file? Where is the navicat cache file? Apr 24, 2024 pm 06:06 PM

Where is the navicat cache file?

How to copy database to another database in navicat How to copy database to another database in navicat Apr 24, 2024 pm 07:24 PM

How to copy database to another database in navicat

How to export table structure to word using navicat How to export table structure to word using navicat Apr 24, 2024 pm 07:57 PM

How to export table structure to word using navicat

How to recover accidentally deleted table in navicat How to recover accidentally deleted table in navicat Apr 24, 2024 pm 06:21 PM

How to recover accidentally deleted table in navicat

How to undo the previous step in navicat How to undo the previous step in navicat Apr 24, 2024 pm 05:48 PM

How to undo the previous step in navicat

Which one is easier to use, navicat or datagrip? Which one is easier to use, navicat or datagrip? Apr 24, 2024 pm 07:15 PM

Which one is easier to use, navicat or datagrip?

See all articles