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. Kikloo

    Mysql errors after upgrading to 5.7

    Kikloo, May 17, 2019 at 11:53 AM, in forum: Database Discussion
    Replies:
    6
    Views:
    97
    cPanelLauren
    May 17, 2019 at 1:36 PM
  2. RickKukiela

    Encountered error in Mysql::initcache

    RickKukiela, May 15, 2019, in forum: Database Discussion
    Replies:
    2
    Views:
    101
    cPanelMichael
    May 16, 2019
  3. Stacy HM

    MySQL error in users cPanel

    Stacy HM, Apr 27, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    240
    cPanelMichael
    Apr 30, 2019
  4. robahas

    MySQL user name is too long error

    robahas, Apr 27, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    195
    cPanelMichael
    Apr 30, 2019
  5. mismari

    Failed building wheel for mysqlclient error

    mismari, Apr 16, 2019, in forum: Workarounds and Optimization
    Replies:
    5
    Views:
    257
    cPanelMichael
    Apr 19, 2019

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