error 1045 (mysql)

[AlaskanWolf]

Changed the mysql root pass, and getting quite a bit of errors (user side ERROR 1045: Access denied for user: \'root@localhost\' (Using password: YES) 0

whm side:

ERROR 1045: Access denied for user: \'root@localhost\' (Using password: NO)
/usr/bin/mysqladmin: connect to server at \'localhost\' failed
error: \'Access denied for user: \'root@localhost\' (Using password: NO)\'


already checked the .my.cnf file and it matches the new password, any ideas as i have 500 customers screaming down my back

[feanor]

Did you change it w/ the WHManager or did you change it from the command line? You should do it from the WHManager and then restart all CPanel 3 servers, and run the phpmyadminupdate (within cpanel/bin somewhere... don\'t remember exactly where)... that will update the include files for the user frontend that is within each user\'s cpanel.....


Let me know.

[AlaskanWolf]

WHM screws up when you try change the root mysql pass, I have found a fix for this for any other hosts that might encounter such error

step by step

login via ssh

run the commands as follows:

killall mysqld
safe_mysqld --skip-grant-tables &
/usr/local/cpanel/startup

Then login into WHM reset the MySQL root
password.

go back to ssh...

killall mysqld
/etc/rc.d/init.d/mysql start

And that should fix it... =)

[feanor]

Never once had a problem w/ that function.
Thanks for the advice!

Rock on chicago.

[bonnmac]

I'm so glad this post was here. It's almost 2 years old but it just got me out of a jam. Thanks a million!

Originally posted by AlaskanWolf
WHM screws up when you try change the root mysql pass, I have found a fix for this for any other hosts that might encounter such error

step by step

login via ssh

run the commands as follows:

killall mysqld
safe_mysqld --skip-grant-tables &
/usr/local/cpanel/startup

Then login into WHM reset the MySQL root
password.

go back to ssh...

killall mysqld
/etc/rc.d/init.d/mysql start

And that should fix it... =)

cPanel.net Support Ticket Number:

[toma1708]

I tried that and it didn't fixed the problem.

WHM 6.4.2
Cpanel 6.4.2-E85
RedHat 7.3

Any other ideas ?

Thank you.

Catalin

cPanel.net Support Ticket Number:

[SS ToXiC]

all you have to do is reload the mysql...


once you change the mysql password, login to phpmyadmin and reload the mysql.

cPanel.net Support Ticket Number:

[NiteStalker22]

I've only ever used the 'Reset MySQL Root Password' in Webfsck Manager.. or whatever.

Then if you must.. edit the .....

/usr/local/cpanel/3rdparty/phpMyAdmin/config.inc.php

..file with a new crypted password.

It's rare for me to need to go that far though.. only really ever need to just reset it.

cPanel.net Support Ticket Number: