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.

mysql error [moved]

Discussion in 'Database Discussions' 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?
     
    #2 tweakservers, May 29, 2006
  3. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    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.
     
    #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. Leee-John

    Mysql process error log

    Leee-John, May 22, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    101
    cPanelMichael
    May 23, 2017
  2. willrijo

    Error upgrading mysql 5.5 to MariaDB 10.1

    willrijo, May 15, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    240
    rpvw
    May 16, 2017
  3. Terry Bogard

    Mysql error : Access denied for user '[cpaneluser]'@'localhost' (using password: NO)

    Terry Bogard, May 8, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    198
    cPanelMichael
    May 9, 2017
  4. Sametto Chan

    Mysqli statement execute error: Connection was killed

    Sametto Chan, May 5, 2017, in forum: Database Discussions
    Replies:
    6
    Views:
    212
    Sametto Chan
    May 29, 2017
  5. zambara

    Legacy backup restoration mysql error

    zambara, Apr 30, 2017, in forum: Data Protection
    Replies:
    2
    Views:
    235
    cPanelMichael
    May 2, 2017

Share This Page