How to solve the problem of being unable to access mysql in Linux system
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!
