How to modify mysql to allow remote connections

Regarding the issue of MySQL remote connection, we often encounter MySQL database stored on someone's computer when working in the company. If we want to connect to the MySQL service, the computer with the MySQL service installed must enable remote connection

The first step is to connect to your database using DOS (I am talking about Win here)

Then select the system library, mysql

Command: use mysql , of course you can also see which libraries have been created in your mysql

Then select mysql

Then execute the command to modify permissions: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

This is a very crucial sentence.

After execution, clear the cache

ok basically

Don't worry, you can check it out.

Now the database in mysql on your machine can be accessed by others if it is in the local area network.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.