When I try to access Plesk Panel 12.5 in Centos 7 receives the following message:
ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Access denied for user 'admin'@'localhost' (using password: YES) (Error code: 1045) (Abstract.php:69)
I have fixed with this solution (the only one that worked):
1. run this line, copy the password to some text file:
cat /etc/psa/.psa.shadow
2. vi /etc/my.cnf
i for insert, under [mysqld] add the skip-grant-tables (or skip_grant_tables) option. esc :x! (to get out and save changes)
***3. restart mysql using this line:
systemctl restart mariadb.service
***IMPORTANT*** (and FYI Plesk team!!!) The Plesk 12.5 documentation for CentoOS7 users needs to be updated, because CentoOS7 is running MariaDB and the restart option has CHANGED from previous versions (at least that's what I understood from the CentOS7 forum messages I read)
4. Now you should be able to run the following line to see the incorrect password set up for admin:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql -Ne"select * from user where User='admin';"
5. Reset it to the password you pasted, the correct one:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql -Ne"update user set Password=PASSWORD('$AES-128-....==') where User='admin';"
6. Refresh browser to see you can now login again to Plesk.
The problem is that every day the same thing happens.
But, why do I have to repeat those steps every day?
Is there any way to save them?
ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Access denied for user 'admin'@'localhost' (using password: YES) (Error code: 1045) (Abstract.php:69)
I have fixed with this solution (the only one that worked):
1. run this line, copy the password to some text file:
cat /etc/psa/.psa.shadow
2. vi /etc/my.cnf
i for insert, under [mysqld] add the skip-grant-tables (or skip_grant_tables) option. esc :x! (to get out and save changes)
***3. restart mysql using this line:
systemctl restart mariadb.service
***IMPORTANT*** (and FYI Plesk team!!!) The Plesk 12.5 documentation for CentoOS7 users needs to be updated, because CentoOS7 is running MariaDB and the restart option has CHANGED from previous versions (at least that's what I understood from the CentOS7 forum messages I read)
4. Now you should be able to run the following line to see the incorrect password set up for admin:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql -Ne"select * from user where User='admin';"
5. Reset it to the password you pasted, the correct one:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql -Ne"update user set Password=PASSWORD('$AES-128-....==') where User='admin';"
6. Refresh browser to see you can now login again to Plesk.
The problem is that every day the same thing happens.
But, why do I have to repeat those steps every day?
Is there any way to save them?
- OS: CentOS Linux 7.2.1511 (Core)
- Plesk version: 12.5.30 Update #30