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

    New Thread systemctl start mariadb error but mysql running

    codepoet, Nov 19, 2018 at 9:14 PM, in forum: Database Discussion
    Replies:
    0
    Views:
    21
    codepoet
    Nov 19, 2018 at 9:14 PM
  2. Netcrusher

    Backup with errors - roundcube mysqldump failed

    Netcrusher, Nov 19, 2018 at 1:08 AM, in forum: Data Protection
    Replies:
    1
    Views:
    50
    cPanelLauren
    Nov 20, 2018 at 12:14 PM
  3. lahmar amine

    mysql error

    lahmar amine, Nov 17, 2018 at 3:56 PM, in forum: Database Discussion
    Replies:
    1
    Views:
    54
    cPanelLauren
    Nov 20, 2018 at 11:17 AM
  4. cPanelAlex

    SOLVED [Defect] MySQL Connection Failures and 500 Errors; CloudLinux + Imunify360

    cPanelAlex, Nov 15, 2018 at 6:45 AM, in forum: General Discussion
    Replies:
    2
    Views:
    596
    HostXNow_Chris
    Nov 15, 2018 at 12:17 PM
  5. ronaldst

    SOLVED MySQL errors - password and plugin authentication specified

    ronaldst, Nov 7, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    98
    cPanelLauren
    Nov 9, 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