Web Hosting Talk : Web Hosting Main Forums : Web Hosting : Cpanel Mysql Databases

[|k_m_k_z!|]

Hi,

I'm trying to create a program that would accept the purchase of a website, copy all the files to a user-specified directory, create a database and user, and write the required information to the config.php file. The problem I'm having is that I'm using cPanel on my site, and I cannot create databases or users without going through it. I already tried to GET/POST hack but it requires the user to 1. create the user, 2. create the DB, and 3. to link the DB and user. Since PHP is serverside and it can't send variables without actually GOING to the page, I can't figure out how to create the DBs and users without logging into cPanel. I also tried to login to MySQL and use CREATE and USE to fill in the DB and table info, but my hosting provider made it impossible to do that by taking away the permissions.

Any clues?

Thank you so much,

KMKZ

[PMH-Steve]

What type of account do you have? For this type of thing you are going to need either root access or a reseller account that allows you to setup a remote access key for WHM.

If you get root access or a reseller account with the remote key feature enabled you can use it to issue commands from a PHP script to create the accounts and so forth.

The issue with needing to actually log into cPanel will be taken care of by that remote access key. Then to fix the "actually having to go to the page problem" you can use something like the snoopy class for PHP (http://snoopy.sourceforge.net/) to issue commands to to WHM behind the scenes, which is really very easy to do.

If you search these forums for "PHP snoopy" you will find some info on this.

If you already now all this then sorry I misunderstood your post.

[|k_m_k_z!|]

Well, yes, you somewhat misunderstood my post, but this Snoopy thing is very interesting... I think I'll check it out.

What I really wanted to know is how I can have a PHP script setup a MySQL user, database, and then assign the user priviliges on that database. After it is created, the PHP script would write the info to another file, so it could access the database (this I know how to do).

I have a regular account with the WHM and cPanel x2... I just wish I could use my main MySQL account to create DB's and users, but my hosting provider wont let me...

Thanks for your help...

KMKZ

[overulehost]

yeah, to create accounts,etc you need the access key from whm.....
Well why code yourself when you can get great software like whmautopilot
Check them out