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.

Unable to add user to new databases in sql

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

  1. sgriffin

    sgriffin Member

    Joined:
    Nov 15, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    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:
    1
    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