Linux system cannot use Access to MySQL solution

Linux systems cannot use Access to MySQL solutions. MySQL is the most common relational database management system, but there are a lot of users in the process will also encounter a number of small problems, a Linux system users found in the Linux system can not access MySQL, why is this cause? How can we solve it? Let's find the answer together.

Linux

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.

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.