mysql.user table is not updated

[taalaibek]

I have:
WHM 10.8.0 cPanel 10.8.2-R73
CentOS 4.3 i686 - WHM X v3.1.0

I upgraded MySQL 4.0 to 4.1 through WHM control panel.

After, I couldn't access as root to mysql (ERROR 1045 (28000): Access denied for user 'root'@'loclahost' (using password: YES))

In the log file I found this:

060505 17:19:33 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
/usr/sbin/mysqld: ready for connections.
Version: '4.1.18-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)

Then i run command mysql_fix_privilege_tables. But again the same error: ERROR 1045 (28000)

I googled but didn't find correct solution. Please help ..

[avijit]

Reset the mysql root password from the WHM and that should fix your issue.

[taalaibek]

Reset the mysql root password from the WHM and that should fix your issue.

I did reset from the WHM but failed.

I tried changing .my.cnf file also, removing "" in user="root" and password="pwd". This not helped also.

Any other suggesstion?

[taalaibek]

i found the solution. it is here:



Mysql gives error of access denied for root@localhost ?

Make sure root pass is in /root/.my.cnf

This is usually the first root pass the box was given once cpanel is installed.

If it still does not work, you will need to reset the mysqld root pass.

First, stop the mysqld, usually /etc/rc.d/init.d/mysql stop

Then stop chkservd to keep it from interfering with mysqld while you work on it
with /etc/rc.d/init.d/chkservd stop

Start up mysqld , but, without the grant tables,

mysqld --skip-grant-tables -u mysql &

Then change the pass..

mysql -u root mysql
UPDATE user SET Password=PASSWORD('new_password') WHERE User='root';
FLUSH PRIVILEGES;

Now you just killall -9 mysqld and start it up normally with it's safe_mysqld
script.