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

This article mainly introduces the navicat connection mysql method, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor with you to understand.

1. First of all, you must have mysql's database installed on your computer. (if you are not sure whether you have successfully installed mysql, you can type "mysql" in the start menu to search)

two。 Open your Navicat for Mysql (you can also use the above method here by typing 'navicat'' in the start menu search box)

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

4. The most important step: open the interface with five boxes to enter.

The first one: connection Name needs to enter the name of the new connection you created. Here we will name it 'local'.

The second one: Host Name/Ip Address, what you need to enter is your local ip address or type 'localhost',' directly. Here we choose the second one.

The third: Port, enter the port number of your installation, which is usually 3306 by default

The fourth and fifth are: UserName and Password, which means you need to enter your database name, user name and password. My user name is: root, password: (secret, hey, hey). Finally, check the small box of 'Save Passwod'' below.

5. Complete the above steps, and then click the 'Test Connectiion'' button in the lower left corner. If success pops up, congratulations, just click on the 'save' button in the lower right corner. If error pops up, you need to re-check where you filled it wrong.

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

Thank you for reading this article carefully. I hope the article "how to connect navicat to mysql" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.