PHPMyAdmin controls in vB...restrict by usergroup/individual user

[Sovereign]

That's right, I'm asking for something a little unusual. I'm running a free hosting service, and while my users have FTP, they don't have cPanel as I am on shared hosting with cPanel only for the main account. I need some of them to be able to access/modify/create certain databases.

As in Joe Users has access to create 5 DB. He creates one called alliance_joe_mysite (append joe_ to the alliance_ that is placed infront of a DB name automatically). He has full access to this database, can drop/edit/run queries. He cannot mess with other DB however.

Is this possible?

[Rich]

Hello,

Can't you just create the DB for him, and add him as a user that can edit that DB? I know I have the ability to add users to a DB giving them edit abilities only on that db. (Never used it though.)

[Sovereign]

I do, but for my hosting, I want them to be able to manage DBs themselves.

[Kirk Y]

Try checking with your webhost, some hosts allow individual MySQL Users access to phpMyAdmin using their User/PW, their permissions can be set in the cPanel and they're only able to edit a database that they've been granted access to.

[merk]

or install your own phpmyadmin copy..

[Kirk Y]

What if you're running on a shared server...

[merk]

PHPMyAdmin will still run in such an enviroment.