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!

Unable to add user to new databases in sql

Discussion in 'Database Discussion' started by sgriffin, Nov 20, 2003.

  1. sgriffin

    sgriffin Member

    Joined:
    Nov 15, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    A client is unable to create any new databases using cpanel,
    add any existing users to existing databases..

    His password has been reset.
    Latest cpanel release version.
    mysql (3.23.56)

    I wasn't able to find anything in a search of the forum.
     
  2. sgriffin

    sgriffin Member

    Joined:
    Nov 15, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    busted out the mysql book

    mysql -h localhost -u root

    use mysql
    grant all on *.* to insertuser@'localhost' identified by 'pass';

    quit
     
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