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!

mysql error [moved]

Discussion in 'Database Discussion' started by ras`, May 29, 2006.

  1. ras`

    ras` Member

    Joined:
    Apr 25, 2006
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    151
    Hi,

    I am encountering error messages as I visit one of our site:

    Warning: mysql_connect(): Access denied for user: 'onlinecd_db2@xxx.xxx.xxx' (Using password: YES) in /home/internet/public_html/directory/class/db.php on line 28
    Error connecting to the serverAccess denied for user: 'onlinecd_db2@xxx.xxx.xxx' (Using password: YES)

    anyone encounter the same and tell me how to resolve this thing.
    glad to hear from anybody.

    ras
     
    #1 ras`, May 29, 2006
  2. tweakservers

    tweakservers Well-Known Member

    Joined:
    Mar 30, 2006
    Messages:
    379
    Likes Received:
    0
    Trophy Points:
    166
    are you connecting using ip address or using localhost? If IP address, does it allowed for the database in Cpanel allowed host?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 tweakservers, May 29, 2006
  3. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,051
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    Earth
    Try following the below steps.

    1. Login to cPanel for that domain.
    2. Goto 'Databases' and delete the user assigned to that particular database.
    3. Add the user and assign to the database again with full privilages.
    4. Edit the db.php file and replace the old database username/password with the new one you have just created.

    Also check whether your are using the servername as IP addr or localhost. Change it to 'localhost'

    Hope this will help you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 madaboutlinux, May 29, 2006
  4. kemis

    kemis Well-Known Member

    Joined:
    Feb 17, 2005
    Messages:
    104
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Georgetown, TX
    Yeah, going to WHM --> Change a User or Database Password and resetting my mysql root password back to my usual fixed the problem for me. Many others are having this same issue. Happened to me after an auto-upgrade last night to 4.1.19. :-(

    All is well again, I believe.

    -- Matt
     
    #4 kemis, Jun 1, 2006
  5. ras`

    ras` Member

    Joined:
    Apr 25, 2006
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    151
    Thanks guys for all the information,

    After deleting and replacing it, solves the problem.
     
    #5 ras`, Jun 6, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - mysql error [moved]
  1. CompWebStudio

    The mysql service failed to start error

    CompWebStudio, Feb 24, 2019, in forum: Database Discussion
    Replies:
    2
    Views:
    191
    cPanelMichael
    Feb 25, 2019
  2. aries

    Error in MySQL upgrade from 5.6 to 5.7

    aries, Feb 22, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    193
    cPanelMichael
    Feb 25, 2019
  3. mayadesigns

    Error mysql

    mayadesigns, Feb 7, 2019, in forum: Discusión en Español
    Replies:
    1
    Views:
    83
    cPanelLauren
    Feb 8, 2019
  4. MHD_MUS

    cPanel mysql backup Error 1045

    MHD_MUS, Dec 7, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    269
    cPanelLauren
    Dec 10, 2018
  5. codepoet

    systemctl start mariadb error but mysql running

    codepoet, Nov 19, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    378
    cPanelMichael
    Nov 27, 2018

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.
    Accept Learn More...
    Dismiss Notice