The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Discussion' started by Jontxu40, Jun 28, 2003.

  1. Jontxu40

    Jontxu40 Well-Known Member

    Joined:
    Dec 9, 2002
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    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:
     
  2. Jontxu40

    Jontxu40 Well-Known Member

    Joined:
    Dec 9, 2002
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    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

    :confused: :confused: :confused:

    cPanel.net Support Ticket Number:
     
  3. howard

    howard Well-Known Member

    Joined:
    Apr 20, 2003
    Messages:
    233
    Likes Received:
    0
    Trophy Points:
    16
    you might be missing the /root/.my.cnf file what does ls -lsah /root/.my.cnf show ?

    cPanel.net Support Ticket Number:
     
  4. Jontxu40

    Jontxu40 Well-Known Member

    Joined:
    Dec 9, 2002
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Mysql

    HI :

    Thanks , thanks you very much

    Solved !!!

    cPanel.net Support Ticket Number:
     
  5. khoonchee

    khoonchee Well-Known Member
    PartnerNOC

    Joined:
    Oct 2, 2002
    Messages:
    134
    Likes Received:
    0
    Trophy Points:
    16
    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:
     
  6. DHL

    DHL Well-Known Member

    Joined:
    Mar 8, 2002
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
    Same as khoonchee *sigh* again.

    cPanel.net Support Ticket Number:
     
  7. JesterCobblepot

    JesterCobblepot Registered

    Joined:
    Feb 4, 2003
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    yep im getting the same thing...

    cPanel.net Support Ticket Number:
     
  8. khoonchee

    khoonchee Well-Known Member
    PartnerNOC

    Joined:
    Oct 2, 2002
    Messages:
    134
    Likes Received:
    0
    Trophy Points:
    16
Loading...

Share This Page