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

Question

I've changed the password for admin user of mysql in phpmyadmin and now I can't access neither my Plesk panel and neither mysql via ssh. The error it triggers is:

SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES) (Abstract.php:144)

If I enter skip-grant-tables in my.cnf, I can access Plesk, phpmyadmin and mysql via ssh, but it doesn't allow me to change password.

How can I do to regain normal access to the Plesk panel?

Thanks

possible duplicate of [How to reset or recover admin account password for MySQL?](http://serverfault.com/questions/4309/how-to-reset-or-recover-admin-account-password-for-mysql) — Deer Hunter, Apr 28 '15 at 08:35

score 0 · Accepted Answer · answered Apr 28 '15 at 08:13

0

If you use --skip-grant-tables than you can't change password with set Password = PASSWORD('string'), but you can do

UPDATE mysql.user set Password = <HASHED_STRING> where User = <ADMIN_USER> AND Host = 'localhost';

You can create hashed string with following command

select PASSWORD('test');
+-------------------------------------------+ 
| PASSWORD('test')                          |
+-------------------------------------------+
| *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 |
+-------------------------------------------+
1 row in set (0,00 sec)

answered Apr 28 '15 at 08:13

Navern

1,619
1
10
14

This works but I can't understand which password choose to make it work again – Ponzaro Apr 28 '15 at 08:47
use any password to get access to mysql via ssh. I can't really tell about plesk panel. – Navern Apr 28 '15 at 08:54
Yes, for MySQL it's Ok, but plesk still doesn't work – Ponzaro Apr 28 '15 at 08:55
Mb this link will help. kb.mediatemple.net/questions/1710/How+can+I+change+my+Plesk+admin+password%3F#dv – Navern Apr 28 '15 at 09:01
Ok, solved for plesk using http://KB.odin.com/112492 – Ponzaro Apr 28 '15 at 09:05

score -1 · Answer 2 · answered Apr 28 '15 at 08:19

-1

This is frequently asked question that already has an answer.

http://www.debian-administration.org/article/442/Resetting_a_forgotten_MySQL_root_password

answered Apr 28 '15 at 08:19

Kondybas

6,964
2
20
24

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

2 Answers2