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

This article mainly introduces "what is the method of Navicat connection MySQL". In daily operation, I believe many people have doubts about what is the method of Navicat connection MySQL. Xiaobian consulted all kinds of information and sorted out simple and easy operation methods. I hope to help you answer the doubts of "what is the method of Navicat connection MySQL"! Next, please follow the small series to learn together!

brief description of

Navicat is a fast, reliable and comprehensive database management tool designed to simplify database administration and reduce administrative costs. Navicat's intuitive graphical interface provides an easy way to design and manipulate MySQL, MariaDB, SQL Server, Oracle, PostgreSQL and SQLite data.

When using Navicat to remotely connect to MySQL databases, there are often some errors. Today we will share our experience.

new connection

Open Navicat and select: Connect-> MySQL. A new window will appear and you can enter some basic information:

After the input is completed, click the "Test Connection" button to test whether it can be connected normally!

common mistakes

Errors often occur during database connections. Below we list the specific error messages and the corresponding solutions!

mistake

When first connected, it is likely that:

1130- Host xxx is not allowed to connect to this MySQL server

This means that the connected account does not have remote connection permissions and can only log in on the local host.

At this time, you need to change the host entry in the user table in MySQL database, and change localhost to %:

mysql> use mysql;mysql> update user set host = '%' where user = 'root';mysql> flush privileges;

Mistake 2

Connect again, and you'll see:

2059 - authentication plugin 'caching_sha2_password' cannot be loaded

This is because the encryption rule was mysql_native_password in versions prior to MySQL8, and changed to caching_sha2_password in later versions.

To solve this problem, you can revert MySQL's encryption rules to mysql_native_password:

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Password@123456';

Note: Password@123456 is the password to log in to the database, which can be set according to your own situation.

connect to MySQL

When the above errors are resolved, you can connect MySQL normally:

Note: The password here is the password changed above (e.g. Password@123456).

At this point, the study of "what is the method of Navicat connection MySQL" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.