What if you can't access MySQL under the Linux system?

MySQL is a relational database management system, but recently a user reflects, in the Linux system can not access MySQL, I believe many users have encountered this problem, this is how it? What can I do if I can't access MySQL under Linux? Let's take a look at the solution here.

　　1, problems and anomalies

Threadpoolasynchronousrunner-com.mchange.v2.async.threadpoolasynchronousrunner$deadlockdetector@75d634ea-- Apparent deadlock!!! Complete Status:

Managed Threads:3

Active Threads:3

Active Tasks:

　　2. Find the reason

It's a question of MySQL permissions.

　　3, the resolution process

1 "Mysql-uroot-proot Mydbname

2 "Grant all Privileges" *.* to wangs@ '% ' of ' identified by ' 123456 ';

3 "flush privileges;

4 "exit;

5 "/etc/init.d/mysql Restart

　　4. Description of the Order

Enter MySQL, user is root, password is root, database is mydbname,-u meaning for user, p-meaning is password,

Increase user wangs, all permissions, database for *, behind. * Must be small,% for all remote IP address, if you want to limit the IP address, write the IP address alone,

The password is 123456, note that the quote ' is not small, used to represent a string.

None of the above commands and procedures can be omitted.