Product:
Search Type:

Some users cannot login to MySQL from localhost after upgrade to Plesk 8. Applications from Application Vault also get mysql "permission denied error".

Article ID: 1247 
Last Review: Oct,04 2006
APPLIES TO:
  • Plesk 8.x for Linux/Unix

RESOLUTION


Make sure that there are no records with empty 'user' or 'password'
fields in 'user' table in 'mysql' database. It can be found using the
following command:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D mysql -e 'select * from user where user="" or password=""'



The output should be empty. If not, delete records with empty 'user' or 'password'
fields.
Keywords: application vault applications installation mysql login permission denied error

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields