Resolved ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost'

[amirfateh2]

hi dears
our server below error happend, i search knowldge base and none of them cant help us:

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Abstract.php:144)

Search for related Knowledge Base articles

ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)' in /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$ma...', Array) #1 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('select param, v...', Array) #4 /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query('select param, v...', Array) #5 /usr/local/psa/admin/plib/db.php(36): Db_Adapter_Pdo_Mysql->query('select param, v...') #6 /usr/local/psa/admin/plib/db.php(212): db_query('select param, v...', false) #7 /us (Abstract.php:144)

 

[UFHH01]

Hi amirfateh2,

and none of them cant help us:

And which solution / work-around did you use to try to solve your issue?

We really need more informations, if you desire further help:

First, pls. make sure to post your output of the command ( logged in as user "root" over SSH ):

plesk version

Second, pls. make sure that you used the "Plesk Repair Utility" ( => Plesk Repair Utility )
Third, pls. don't forget to include log - files from your repair - procedure(s) ( /var/log/plesk ).

Fourth, pls. describe in detail, what you did to resolve your issue.​

 

[amirfateh2]

Hi amirfateh2,


And which solution / work-around did you use to try to solve your issue?

We really need more informations, if you desire further help:

First, pls. make sure to post your output of the command ( logged in as user "root" over SSH ):

plesk version

Second, pls. make sure that you used the "Plesk Repair Utility" ( => Plesk Repair Utility )
Third, pls. don't forget to include log - files from your repair - procedure(s) ( /var/log/plesk ).

Fourth, pls. describe in detail, what you did to resolve your issue.​

hi ufhh01, thanks for your reply
i try to slove problem with some kb in the link below:
Help Center
first:
Product version: Plesk Onyx 17.0.17 Update #21
Update date: 2017/03/31 03:12
Build date: 2017/03/22 17:00
OS version: CentOS 7.3.1611
Revision: ab6766191d3ba26e7b21255ab007fc7fc56d84c6
Architecture: 64-bit
Wrapper version: 1.2
Second: i cant use plesk repair utility, below error ocurred:
[2017-06-10 17:50:33] ERR [panel] SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES):
0: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:144
Zend_Db_Adapter_Pdo_Abstract->_connect()
1: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php:111
Zend_Db_Adapter_Pdo_Mysql->_connect()
2: /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php:460
Zend_Db_Adapter_Abstract->query(string 'select param, val from misc', ar ray)
3: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'select param, val from misc' , array)
4: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:30
Db_Adapter_Pdo_Mysql->query(string 'select param, val from misc')
5: /usr/local/psa/admin/plib/db.php:36
db_query(string 'select param, val from misc', boolean false)
6: /usr/local/psa/admin/plib/db.php:212
get_param(string 'disable_provisioning')
7: /usr/local/psa/admin/plib/Plesk/Mode.php:423
Plesk_Mode::isProvisioningDisabled()
8: /usr/local/psa/admin/plib/common_func.php:95
util_exec(string 'send-error-report', array, array, string 'proc_open', NULL null)
9: /usr/local/psa/admin/plib/common_func.php:28
smart_exec(string 'send-error-report', array, array, string 'proc_open')
10: /usr/local/psa/admin/plib/Os.php:116
Os::exec(string 'send-error-report', array, string 'proc_open')
11: /usr/local/psa/admin/plib/CommonPanel/Exception.php:329
CommonPanel_Exception::_sendRuntimeReportXML(string 'Zend_Db_Adapter_Exc eption', string 'SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhos t' (using password: YES)', string '/usr/local/psa/admin/externals/Zend/Db/Adapte r/Pdo/Abstract.php', integer '144', integer '1045', string '#0 /usr/local/psa/ad min/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract-> _connect()
#1 /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Ada pter_Pdo_Mysql->_connect()
#2 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db _Adapter_Abstract->query(string 'SET sql_mode = ''', array)
#3 /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_A bstract->query(string 'SET sql_mode = ''', array)
#4 /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php(90): Db_Adapte r_Pdo_Mysql->query(string 'SET sql_mode = ''')
#5 /usr/local/psa/admin/plib/api-common/AbstractCu.php(1647): CommonPanel_Applic ation_Abstract::initDbAdapter()
#6 /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php(21): AbstractCu::initD b()
#7 /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php(35): CliUtilityRunner- >run()
#8 /usr/local/psa/admin/plib/api-cli/repair.php(4): require_once(string '/usr/lo cal/psa/admin/plib/api-cli/CliUtilityRunner.php')
--
#0 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__ construct(string 'mysql:dbname=psa;host=localhost;port=3306;charset=utf8', strin g 'admin', string '******', array)
#1 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Ad apter_Pdo_Abstract->_connect()
#2 /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Ada pter_Pdo_Mysql->_connect()
#3 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db _Adapter_Abstract->query(string 'SET sql_mode = ''', array)
#4 /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_A bstract->query(string 'SET sql_mode = ''', array)
#5 /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php(90): Db_Adapte r_Pdo_Mysql->query(string 'SET sql_mode = ''')
#6 /usr/local/psa/admin/plib/api-common/AbstractCu.php(1647): CommonPanel_Applic ation_Abstract::initDbAdapter()
#7 /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php(21): AbstractCu::initD b()
#8 /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php(35): CliUtilityRunner- >run()
#9 /usr/local/psa/admin/plib/api-cli/repair.php(4): require_once(string '/usr/lo cal/psa/admin/plib/api-cli/CliUtilityRunner.php')', integer '1', string '1f2f1b8 8afaae781b9e915d9ad540137', string 'e1f748d9dfa9cd906a7daecc3aa23bc9')
12: /usr/local/psa/admin/plib/CommonPanel/Exception.php:170
CommonPanel_Exception::sendNotification(object of type Zend_Db_Adapter_E xception)
13: /usr/local/psa/admin/plib/api-common/AbstractCu.php:2432
AbstractCu::reportError(object of type Zend_Db_Adapter_Exception)
14: /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php:27
CliUtilityRunner->run()
15: /usr/local/psa/admin/plib/api-cli/CliUtilityRunner.php:35
require_once(string '/usr/local/psa/admin/plib/api-cli/CliUtilityRunner. php')
16: /usr/local/psa/admin/plib/api-cli/repair.php:4
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES) (Abstract.php:144)
exit status 1
third, forth: expaliand in the abow
Best regards

 

[UFHH01]

Hi amirfateh2,

sorry... you are trying to make it too easy for you. The KB - link you provided is a SEARCH link, so it is absolutely unclear, WHAT you did to resolve your issue/error/problem.

Without any further informations, I can only suggest to follow:

=> Unable to access Plesk: Access denied for user 'admin'@'localhost' (using password: YES)​

 

[amirfateh2]

Hi amirfateh2,

sorry... you are trying to make it too easy for you. The KB - link you provided is a SEARCH link, so it is absolutely unclear, WHAT you did to resolve your issue/error/problem.

Without any further informations, I can only suggest to follow:

=> Unable to access Plesk: Access denied for user 'admin'@'localhost' (using password: YES)​

thanks , itry it but last step (5) below erro ocurred:
/usr/local/psa/bin/admin --show-password
[2017-06-10 19:43:08] ERR [panel] SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES):
0: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:144
Zend_Db_Adapter_Pdo_Abstract->_connect()
1: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php:111
Zend_Db_Adapter_Pdo_Mysql->_connect()
2: /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php:460
Zend_Db_Adapter_Abstract->query(string 'select param, val from misc', array)
3: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:238
Zend_Db_Adapter_Pdo_Abstract->query(string 'select param, val from misc', array)
4: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:30
Db_Adapter_Pdo_Mysql->query(string 'select param, val from misc')
5: /usr/local/psa/admin/plib/db.php:36
db_query(string 'select param, val from misc', boolean false)
6: /usr/local/psa/admin/plib/db.php:212
get_param(string 'disable_provisioning')
7: /usr/local/psa/admin/plib/Plesk/Mode.php:423
Plesk_Mode::isProvisioningDisabled()
8: /usr/local/psa/admin/plib/common_func.php:95
util_exec(string 'send-error-report', array, array, string 'proc_open', NULL null)
9: /usr/local/psa/admin/plib/common_func.php:28
smart_exec(string 'send-error-report', array, array, string 'proc_open')
10: /usr/local/psa/admin/plib/Os.php:116
Os::exec(string 'send-error-report', array, string 'proc_open')
11: /usr/local/psa/admin/plib/CommonPanel/Exception.php:329
CommonPanel_Exception::_sendRuntimeReportXML(string 'Zend_Db_Adapter_Exception', string 'SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)', string '/usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php', integer '144', integer '1045', string '#0 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()

 

[UFHH01]

Hi amirfateh2,

are you able to use the command ( logged in as user user "root" over SSH ):

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql

or:

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

( if the connect to your database - server is successfull, pls. continue with : )

use mysql;

?

If not, pls. follow:

=> How to get or reset password for admin account in Plesk​

 

[amirfateh2]

Hi amirfateh2,

are you able to use the command ( logged in as user user "root" over SSH ):

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql

or:

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

( if the connect to your database - server is successfull, pls. continue with : )

use mysql;

?

If not, pls. follow:

=> How to get or reset password for admin account in Plesk​

hi UFHH01
thanks for your reply , i try that but coudnt solve problem
our problem exactly is innodb table of all batabase is corrupted!
thus any database couldnt work, i hope this can help to pardon what is my server problem,
please look at attched screenshot for more details,
thanks

 

[UFHH01]

Hi amirfateh2,

if you can't solve your MySQL - issues with the help of KB - articles and if the provided link ( MySQL :: MySQL 5.5 Reference Manual :: 14.23 InnoDB Troubleshooting ) isn't any help as well, you might like the information, that Plesk provides as well "Professional Services", where advanced linux administrators help you to solve your issues directly on your server:

=> https://www.plesk.com/help-center/professional-services/administrative-services​

 

[amirfateh2]

Hi amirfateh2,

if you can't solve your MySQL - issues with the help of KB - articles and if the provided link ( MySQL :: MySQL 5.5 Reference Manual :: 14.23 InnoDB Troubleshooting ) isn't any help as well, you might like the information, that Plesk provides as well "Professional Services", where advanced linux administrators help you to solve your issues directly on your server:

=> Administrative services - Plesk​

thanks i submit our problem in administrative-services form

 

[amirfateh2]

Hi amirfateh2,

if you can't solve your MySQL - issues with the help of KB - articles and if the provided link ( MySQL :: MySQL 5.5 Reference Manual :: 14.23 InnoDB Troubleshooting ) isn't any help as well, you might like the information, that Plesk provides as well "Professional Services", where advanced linux administrators help you to solve your issues directly on your server:

=> https://www.plesk.com/help-center/professional-services/administrative-services​

hi UFHH01
i submit ticket in administrative-services but any person dont reply it!

 

[UFHH01]

Hi amirfateh2,

you should be aware, that the 12.06. is a national holiday in Russia and it states at the mentioned link:

Please note that this service is provided from 0300-1200 GMT from Monday to Friday. Urgent cases outside these hours should be referred to the Plesk 24×7 support team.