• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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

amirfateh2

New Pleskian
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)
 

Attachments

  • plesk.jpg
    plesk.jpg
    238.4 KB · Views: 12
Last edited:
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 ):
Code:
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 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 ):
Code:
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
 
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:

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()
 
Hi amirfateh2,

are you able to use the command ( logged in as user user "root" over SSH ):
Code:
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql

or:
Code:
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:

 
Hi amirfateh2,

are you able to use the command ( logged in as user user "root" over SSH ):
Code:
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql

or:
Code:
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:

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
 

Attachments

  • photo_2017-06-10_19-15-57.jpg
    photo_2017-06-10_19-15-57.jpg
    270.2 KB · Views: 17
Last edited:
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:

thanks i submit our problem in administrative-services form
 
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:

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