ERROR 1045: Access denied for user: '[email protected]'

Jontxu40

Well-Known Member
Dec 9, 2002
47
0
156
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 :confused:

cPanel.net Support Ticket Number:
 

Jontxu40

Well-Known Member
Dec 9, 2002
47
0
156
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: '[email protected]' (Using password: NO)

I can´understand ... The password are equals

:confused: :confused: :confused:

cPanel.net Support Ticket Number:
 

howard

Well-Known Member
Apr 20, 2003
233
0
166
you might be missing the /root/.my.cnf file what does ls -lsah /root/.my.cnf show ?

cPanel.net Support Ticket Number:
 

Jontxu40

Well-Known Member
Dec 9, 2002
47
0
156
Mysql

HI :

Thanks , thanks you very much

Solved !!!

cPanel.net Support Ticket Number:
 

khoonchee

Well-Known Member
PartnerNOC
Oct 2, 2002
134
0
166
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: '[email protected]' (Using password: YES)
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[email protected]' (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

Well-Known Member
Mar 8, 2002
87
0
306
Same as khoonchee *sigh* again.

cPanel.net Support Ticket Number: