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.

Error in mysql

Discussion in 'Database Discussions' started by camposomar, Sep 4, 2009.

  1. camposomar

    camposomar Active Member
    PartnerNOC

    Joined:
    Mar 30, 2009
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Guadalajara
    hello all.

    i getting this error... i already update cpanel but not works yet :(

    DBD::mysql::st execute failed: There is no such grant defined for user 'coinvest_claudia' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 1133.
    DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 1134.

    thx
     
  2. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    Basically in a nutshell, you created a database and you created a user for that database but you forgot to attach that user to the database and give it permissions to use the database that you created.

    Creating databases on Cpanel is a 3 step process ....

    1. Create the database

    2. Create the user

    3. VERY IMPORTANT! Attach user to the database and give
    that user full priveleges in the new database!

    All 3 of these tasks are in the same place in your Cpanel interface!

    Don't feel bad. It is actually a common problem to forget the 3rd step
    which I even do myself on occasion when I'm tired or busy ;)
     
Loading...

Share This Page