Yum updrade atomic mysql

[DarkF@der]

Hello,

did a yum upgrade for atomic mysql
but my admin password from plesk doesn't work anymore even the control panel because password is chaged how to fix it?
Tryed couple off this

Code: Select all

[root@xxxxxxxx darkfader]# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
[root@xxxxxxxx darkfader]# /usr/local/psa/bin/init_conf --update -passwd xxxxxxxx
Unable to connect to database: 1045
[root@xxxxxxxx darkfader]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@xxxxxxxx darkfader]# /usr/local/psa/bin/init_conf --update -passwd xxxxxxxx
Unable to connect to database: 1045
[root@xxxxxxxx darkfader]# /etc/init.d/psa restart
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
[root@xxxxxxxx darkfader]# /usr/bin/mysql -D mysql -e"update user set password=PASSWORD('`cat /etc/psa/.psa.shadow`') where User='admin';"
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@xxxxxxxx darkfader]# mysql_upgrade -u root
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
FATAL ERROR: Upgrade failed
[root@xxxxxxxx darkfader]# /usr/bin/mysql -D mysql -e"update user set password=PASSWORD('`cat /etc/psa/.psa.shadow`') where User='admin';"
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@xxxxxxxx darkfader]# /usr/bin/mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@xxxxxxxx darkfader]# /etc/init.d/psa restart
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

tryed this also

http://kb.parallels.com/346

but with no luck

my plesk panel is down now.

[scott]

Yeah I have no idea how that happened, the mysql upgrade doesnt touch the tables. Thats why you have run the mysql_upgrade script manually. I do know that plesk 10.2 does change things around now, it no longer uses the old admin/setup default credentials. Its now directly tied to PAM so the root username/password is involved.

This is the procedure you use to reset a mysql password:

http://dev.mysql.com/doc/refman/5.0/en/ ... sions.html