Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Jan 2004
    Posts
    14

    Default postwwwacct Auto-create DB, DB User, Grant Access

    I've created a postwwwacct script in PHP to auto create a database, database user, and grant access to the database for that user. It's not working, however it seems to be inserting all the correct data into the 'mysql' table. When I load my website after creating an account I get an error 'Unable to connect to database, User does not have privileges' error.

    After the account is created and I log into the account's CPanel, all the correct data is displayed - the user was created, the db was created and the user was granted access to the database. When I click on the username to view the permissions it was granted, everything is checked.

    If I click on the "Update" button from the Manage User Privileges page, everything seems to work then. However after doing that all the data in the 'mysql' database table seem to remain the same.

    Any idea what I'm missing? Is there something other than the 'db' table in the 'mysql' database that I have to specify grant access privileges?

  2. #2
    Member
    Join Date
    Jan 2004
    Posts
    14

    Default

    I solved my problem - after assigning privileges I had to flush the mysql privileges!

Similar Threads & Tags
Similar threads

  1. How to grant create view to user?
    By hpbrantley in forum New User Questions
    Replies: 1
    Last Post: 02-23-2010, 05:14 PM
  2. postwwwacct auto create Mysql DB
    By msd25 in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 06-24-2009, 09:39 AM
  3. Any way to create another user who has access to an existing user's CPanel?
    By brianteeter in forum cPanel and WHM Discussions
    Replies: 8
    Last Post: 09-17-2004, 12:09 PM
  4. Grant user FTP access to "RESTRICTED" directories
    By Roy@ENHOST in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 07-24-2004, 06:13 PM
  5. how to i grant a user ftp access?
    By AbeFroman in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 06-13-2002, 02:51 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube