MySQL can connect with localhost, but can not use IP connection problem, LAN 192.168.*.* cannot connect MySQL

The reason is that the permission is not opened

1. The command line enters MySQL (assuming root user's password is also root) Mysql–uroot–proot 2. Use MySQL database using MySQL; 3. Grant all privileges on * * to ' root ' @ '% ' identified by ' root ', or grant all privileges on * * to ' root ' @ '% ' IdentiFi ED by ' password ' with GRANT OPTION;

where * * means all libraries. All tables, ' root ' @ '% ' identified by ' root ' the previous root is the username,% refers to all access IP, and the latter root means the password
This is certainly a rough man's empowerment method, a quiet woman should write her beautiful and specific, such as:

Grant all privileges the MDB.MTBL to ' beautiful ' @ ' 10.38.62.233 ' identified by ' woman ';

4. Refresh permissions (effective without restarting) flush privileges;

I heard that the actual implementation is to put the user and Privilige table things into memory.

5. Restart the MySQL service

MySQL can connect with localhost, but can not use IP connection problem, LAN 192.168.*.* cannot connect MySQL