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 grant privileges not saving

Discussion in 'General Discussion' started by twinfinity, Apr 20, 2011.

  1. twinfinity

    twinfinity Member

    Joined:
    Jan 3, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    I upgraded MySQL to 5.1.56.

    When creating user and database, they both exist but the user has no privileges to the database even the privileges were granted when added as user to the database. Script installers won't select database. For ex:

    WordPress:

    I scoured Google for a fix but have yet to find one... any help is highly appreciated !!
     
  2. m4rc3

    m4rc3 Active Member

    Joined:
    Mar 26, 2010
    Messages:
    39
    Likes Received:
    2
    Trophy Points:
    8
    does anything show up on cpanel's error log when you try all that ?
     
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    The error log is at /usr/local/cpanel/logs/error_log and the MySQL error log is at /var/lib/mysql/hostname.err (where hostname is the full hostname of the machine that you get when you run "hostname -f" command). To tail these, you'd do:

    Code:
    tail -fn0 /usr/local/cpanel/logs/error_log
    tail -fn0 /var/lib/mysql/hostname.err
    You'd want to run the command right before trying to create a database in cPanel and then see if any errors appear in either log.
     
  4. boorsekala

    boorsekala Registered

    Joined:
    May 23, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    i have same problem wich solution ?
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    It depends on the exact error message that is logged to the cPanel error log when you experience this problem.

    If you have root access to the server, please consider opening a ticket for this issue so we may investigate further:

    Submit A Ticket

    Thank you :)
     
Loading...

Share This Page