Current location - Quotes Website - Team slogan - How to connect mysql and navicat
How to connect mysql and navicat
1 First, mysql database must be installed on the computer. (If you are not sure whether mysql is successfully installed, you can enter "mysql" in the start menu to search. )

2. Open Navicat for Mysql (you can also use the above method here and enter' Navicat' in the start menu search box). After opening, the first' connection' on the left side of the stand-alone toolbar will enter the connection page.

3. The most important step: The opened interface has five boxes to input.

First: connection name. What you need to enter is the name of the newly created connection, which is called "local" here.

The second one: the host name /Ip address needs to enter the Ip address of this machine or directly enter' localhost', so choose the second one here.

Third: port, the port number is entered during installation, which is generally the default.

3306;

The fourth and fifth are: user name and password respectively, which means that the database name, user name and password need to be entered. Suppose the user name is: root and the password is: (Bao

Secret, hey hey). Finally, check the "Save Password" box below.

4. Complete the above steps, and then click "Test Connection IIon" in the lower left corner. If it pops up successfully, just click the "Save" button in the lower right corner. If an error pops up, you need to re-check what is wrong.

5. After clicking Save, you can double-click Local (where Local is the connection name you just entered) and then open the database.