Shulou(Shulou.com)06/01 Report--

Linux system can not access mysql how to solve, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

1. Problems and exceptions

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

Managed Threads: 3

Active Threads: 3

Active Tasks:

2. Find the reason

It is painstaking to know that it is a problem of MySQL permissions.

3. Resolution process

1 "mysql-uroot-proot mydbName

2 "grant all privileges on *. * to wangs@'%' identified by '123456'

3 "flush privileges

4 "exit

5 "/ etc/init.d/mysql restart

4. Description of the command

Enter mysql, user is root, password is root, database is mydbName,-u, which means user, and-p means password.

Add user wangs, all permissions, database is *, followed by. * indispensable,% represents all remote IP addresses, if you want to define IP addresses, write IP addresses separately

The password is 123456. Note that the quotation marks are indispensable and are used to indicate that it is a string.

After reading the above, have you mastered how to solve the problem of inaccessible mysql in Linux system? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.