How to connect to database file in navicat

How to use Navicat to connect to the database?

1. Open Navicat and click the ‘Conection’ button in the upper left corner.

#2. After clicking, a menu will pop up. We need to choose which type of database it is. Just choose it according to the type of database you deployed locally. Here I am Select MySql.

Related recommendations: "Navicat for mysql graphic tutorial"

3. After selection, a pop-up window will appear. In this window, we first enter the Host name or IP address of the database. If it is local, just fill in "localhost". The default port is 3306. If you use another local port, you need to fill in the real port number.

#4. Then you need to fill in the username and password to connect to the database. After filling it out, you can click the test button on the lower left.

#5. After clicking, if the pop-up window shows "successful", then the settings are correct and the connection can be successful. If not, it means you have filled in the wrong place. . If there is no problem, click the ‘ok’ button.

#6. Return to the main window, right-click on the database you just connected to, and click ‘Open Connection’.

7. After clicking, a window will pop up. You need to fill in the access password for this database, enter the password, and click the ‘ok’ button.

#8. We can open the locally deployed database and use this tool to perform various operations on the database.

The above is the detailed content of How to connect to database file in navicat. For more information, please follow other related articles on the PHP Chinese website!