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]

Mysql

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]

Mysql

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.php?s=&threadid=13549

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

Hope this might help anyway ...

cPanel.net Support Ticket Number: