ERROR 1045: Access denied for user: 'root@localhost'

[Jontxu40]

Hi :

We are problems with this error at WHM and Cpanel

I am reading all post and it seems the solution is change the pass for Mysql, but I think Mysql have the pass good

At ssh, working like root, "> mysql " give me this error

At ssh > mysql -uroot -pmypass work fine

It seems root can´t accees at mysql without pass and WHM and Cpanel give me the same error. Other servers let me go into mysql without passs

Any idea

cPanel.net Support Ticket Number:

[Jontxu40]

Hi again :

If mysql password = root password why when I try to enter into Mysql by console, I get the error :

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

I can´understand ... The password are equals



cPanel.net Support Ticket Number:

[howard]

you might be missing the /root/.my.cnf file what does ls -lsah /root/.my.cnf show ?

cPanel.net Support Ticket Number:

[Jontxu40]

HI :

Thanks , thanks you very much

Solved !!!

cPanel.net Support Ticket Number:

[khoonchee]

Hi,

I am having the same problem here and have checked the .my.cnf is in the root folder.

Running the above command returns the below output :

4.0K -rwx------ 1 root root 38 Aug 15 22:38 /root/.my.cnf*

I have also tried updated the MYSQL password through WHM but there was error message during the update :

Waiting for mysql to restart.....030815 22:38:18 Can't start server: Bind on TCP/IP port: Address already in use
030815 22:38:18 Do you already have another mysqld server running on port: 3306 ?
030815 22:38:18 Aborting

030815 22:38:18 /usr/sbin/mysqld: Shutdown Complete

Done
Changing Password....ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Done
Reloading Mysqld...
Done
Attempting to restart mysql

Waiting for mysql to restart....
.
.
.
.
.
.
.
.
.
.
finished.

I have tried check the password in the .my.cnf file and the password did updated.

Any advise would be appreciated.

cPanel.net Support Ticket Number:

[DHL]

Same as khoonchee *sigh* again.

cPanel.net Support Ticket Number:

[JesterCobblepot]

yep im getting the same thing...

cPanel.net Support Ticket Number:

[khoonchee]

Hi,

Try this thread :

http://forums.cpanel.net/showthread....threadid=13549

We have successfully resolved it after we found that it is due to the "Special character" in our MYSQL root password.

Hope this might help anyway ...

cPanel.net Support Ticket Number: