Unable to access MySQL solution under 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.

The above is the Linux system can not access the MySQL solution, the user encountered the same failure can be based on the problem of the abnormal conditions to find out why, and then solve the problem of the right remedy.