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 Problems

Discussion in 'General Discussion' started by ManXP, Feb 18, 2009.

  1. ManXP

    ManXP Well-Known Member

    Joined:
    Feb 3, 2005
    Messages:
    62
    Likes Received:
    0
    Trophy Points:
    156
    One of cpanel accounts always experience troubles with MySQL. When visiting site, sometimes it displays MySQL errors "access denied", what means MySQL can not connect to database.

    The only way to fix it - delete MySQL users from cPanel COMPLETELY (not just remove user from database) and re-create them again (using same passwords). It fixes problem for some time.

    Sometimes this problem occurs 2-3 times per day, sometimes- once per week...

    It really drives me crazy...
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. arunsv84

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    68
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    If you are getting access denied error, make sure there is full permission for that user.

    grant all privileges on *.* to database@localhost identified by 'password'

    Hope this helps.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. ManXP

    ManXP Well-Known Member

    Joined:
    Feb 3, 2005
    Messages:
    62
    Likes Received:
    0
    Trophy Points:
    156
    Unfortunately, it does not help. The only way to fix it - delete MySQL user completely, and re-add it again
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. arunsv84

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    68
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    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