MySQL How to open remote connection (default is not turned on, even if the password is correct, still inaccessible)

MySQL How to open remote connection

• |
• Browse:1846
• |
• Updated: 2015-03-11 20:19

• 1
• 2
• 3
• 4
• 5
• 6

Step through ReadingBaidu Experience: jingyan.baidu.com

Everyone in the company's work, often encounter MySQL database stored in a person's computer, you want to connect to the MySQL service, the computer equipped with the MySQL service must open the remote connection.

Baidu Experience: jingyan.baidu.comTools/Materials

• Mysql
• Windows

Baidu Experience: jingyan.baidu.comMethod/Step

2. 1

   Use the CTRL + R key combination to quickly open the cmd window and enter the cmd command to open the cmd window.

   Steps to read
4. 2

   Use the "mysql-uroot-proot" command to connect to the local MySQL service.

   Steps to read
6. 3

   Using the "Use MySQL" command, select the database you want to use, modify the basic information of the remote connection, save it in the MySQL database, and use the MySQL database.

   Steps to read
8. 4

   Use "grant all privileges on * * to ' root ' @ '% ' identified by ' root ' with Grant OPTION;" command to change the settings for a remote connection.

   Steps to read
10. 5

    Use "flush privileges;" command to refresh the permission that you just modified to take effect.

    Steps to read
12. 6

    Use "select Host,user from User;" See if the changes were successful.

    steps to read END

MySQL How to open remote connection (default is not turned on, even if the password is correct, still inaccessible)