AlaskanWolf

Well-Known Member
Aug 11, 2001
537
0
316
Fremont CA
Changed the mysql root pass, and getting quite a bit of errors (user side ERROR 1045: Access denied for user: \'[email protected]\' (Using password: YES) 0

whm side:

ERROR 1045: Access denied for user: \'[email protected]\' (Using password: NO)
/usr/bin/mysqladmin: connect to server at \'localhost\' failed
error: \'Access denied for user: \'[email protected]\' (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

Well-Known Member
Aug 13, 2001
836
0
316
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

Well-Known Member
Aug 11, 2001
537
0
316
Fremont CA
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

Well-Known Member
Aug 13, 2001
836
0
316
Never once had a problem w/ that function.
Thanks for the advice!

Rock on chicago.
 

bonnmac

Well-Known Member
Apr 26, 2003
101
0
166
Thank Goodness & Thank You!

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

Active Member
Aug 30, 2001
31
0
306
Not working.

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

Member
Jul 6, 2003
8
0
151
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

Active Member
May 13, 2002
29
0
301
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: