Mysql modification to enable remote connection, mysql modification to enable

Mysql modification to enable remote connection, mysql modification to enable

Regarding the remote connection to mysql, we often encounter mysql databases stored on a certain computer during our work. If you want to connect to the mysql service, the remote connection must be enabled on the computer with the mysql service installed.

Step 1, Connect your database with dos (I am talking about win here)

Then select the system library, mysql

Command: use mysql. Of course, you can also check which databases have been created in mysql.

Select mysql

Then run the command grant all privileges on *. * TO 'root' @ '%' identified by 'root' with grant option;

This sentence is a key sentence.

After the execution is completed, clear the cache.

OK basically

You can check it out.

Now, if the database in mysql is on your machine, it can be accessed by others on the LAN.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.