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 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:
    6
    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...
     
  2. arunsv84

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    18
    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.
     
  3. ManXP

    ManXP Well-Known Member

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

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page