What can I do if I can't access mysql under Linux?

mysql is a relational database management system, but recently users have reported that it is impossible to access mysql under Linux system. I believe many users have encountered this problem. What is going on? What can I do if I can't access mysql under Linux? Let's take a look at the solution.

1, problems and abnormal

ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@75d634ea - APPARENT DEADLOCK! ! ! Complete Status:

Managed Threads: 3

Active Threads: 3

Active Tasks:

2, Find Reasons

, determine the problem of MySQL permissions

3, the solution process

1 mysql -uroot -proot mydbName

2" grant all privileges on *.* to wangs@&lsquo ;%’ identified by ‘123456’;

3" flush privileges;

4" exit;

5" /etc/init.d/mysql restart< Br>

4, the description of the command

Enter mysql, the user is root, the password is root, the database is mydbName, -u means user, -p means password,

increase User wangs, all permissions, the database is *, the following .* is indispensable, % represents all remote IP addresses, if you want to limit the IP address, write the IP address separately,

The password is 123456, note Quotation marks & lsquo; are indispensable to indicate a string.

The above commands and procedures cannot be omitted.

The above is the solution to the mysql can not access mysql, the user can find the cause according to the abnormal situation of the problem when the same failure, and then solve the problem.