Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    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:
     
  2. Jontxu40

    Jontxu40 Well-Known Member

    Joined:
    Dec 9, 2002
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    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: '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:
    166
    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:
    156
    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:
    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: '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:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. DHL

    DHL Well-Known Member

    Joined:
    Mar 8, 2002
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    306
    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:
    151
    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:
    166
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice