How to connect navicat to mysql

1. First, the mysql database must be installed on your computer. (If you don’t know whether you have successfully installed mysql, you can enter "mysql" in the start menu and search)

Related recommendations: "Navicat for mysql Using graphic tutorial》

2. Open your Navicat for Mysql (you can also use the above method here and enter 'navicat' in the start menu search box)

3. After opening, click the first 'connection' on the left side of the toolbar to enter the connection page.

#4. The most important step: the opened interface has five boxes that require input.

The first one: connection Name needs to enter the name of your new connection, here we will name it 'local';

The second one: Host Name/Ip Address you need Enter the IP address of your machine or directly enter 'localhost'. Here we choose the second one;

The third one: Port, enter the port number when you installed it, which is usually the default 3306;

The fourth and fifth are: UserName and Password respectively, which means you need to enter your database name, username and password. My username is: root, password: (confidential, hehe). Finally, check the little box below ‘Save Password’.

5. Complete the above steps, then click on the ‘Test Connection’ in the lower left corner. If success pops up, congratulations, just click on the ‘save’ button in the lower right corner. If an error pops up, you need to carefully check where you made a mistake.

6. After clicking 'save', you can double-click "Local" ('Local' here is the connection Name you just entered), and then open your database .

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