MySQL How to modify turn on allow remote connection

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

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

Then select System Library, MySQL

Command: Use MySQL, of course you can also see what libraries you have created in MySQL

Then choose MySQL

Then execute the command to modify permissions: GRANT all privileges on * * to ' root ' @ '% ' identified by ' root ' with GRANT OPTION;

That's a key word.

Done, clear the cache.

Ok basically

Don't worry, you can check it out.

Now your machine on the MySQL database, if the LAN, you can chant other people to visit.

MySQL How to modify turn on allow remote connection