Friends, do you know how to connect Navicat for MySQL to the database? Today I will explain the tutorial guide for Navicat for MySQL to connect to the database. If you are interested, come and take a look with me. I hope it can help you.
Step 1: Start the software. After the software is installed, double-click the shortcut icon on the desktop to start Navicat for MySQL. The startup interface is as shown in the figure below.
Navicat for MySQL startup interface.
Step 2 Set connection properties. There is a [Connect] button in the upper left corner of the software window. After clicking it, a prompt box for connection properties will pop up. First, give [Connect] a suitable name and then enter the correct connection information. If you want to manage a remote database, Just enter the correct IP address in the IP address bar.
Open the connection dialog box and set properties
Step 3: After the connection is successful, you will see all the MySQL databases on this machine in the navigation window on the left. The gray ones indicate that the database is not open, and the green ones indicate the databases that have been opened.
Example of connected mysql database
Step 4 Right-click a gray database, and the right-click menu includes commands such as opening the database, closing the database, creating a new database, deleting the database, database properties, running SQL files, dumping SQL files and data transfer, and managing users.
Example of right-click menu for gray database
