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

This article mainly introduces the method of mysql modification and opening to allow remote connection, the article is very detailed, has a certain reference value, interested friends must read it!

The first step is to connect to your database with dos (I'm talking about win)

Then select the system library, mysql

Command: use mysql, of course, you can also look at what libraries have been created in your mysql.

Select mysql after that

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

This sentence is a very key sentence.

After execution, clear the cache

Ok is basically

Don't worry, you can check it out.

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

The above is all the contents of mysql's modification and opening method that allows remote connections. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.