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

It is believed that many inexperienced people have no idea about how to connect to MySQL database in navicat. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Navicat is a powerful tool for graphical operation of MySQL, but when the server of the database does not open 3306 ports to the office network, it is impossible to connect the database directly with navicat in the office network. If you want to operate and view the database, you can only log in to the database server by ssh first, and then operate the database on the command line, which is very unfriendly, and there will be some problems such as long lines and garbled codes. Here is a solution. Servers generally open ssh ports to the office network, and navicat can connect to the database by configuring ssh channels. It is also essentially a SSH jump, but it is the same as connecting to a database directly. The configuration is as follows

Open navicat, click File-> New connection-> click the SSH tab, check the use of SSH channel, fill in the IP, user name and password of the SSH connection, and click OK. Then click the General tab, fill in the address to write localhost, user name to fill in the database user name, password is the database user's password, click OK. Double-click the name of the database on the left to successfully connect to the database.

After reading the above, have you mastered how to connect to the MySQL database in navicat? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.