Allow MySQL users...

Just wondering how I go about allowing a mysql user access to create more than one database. I want 3 databases under one user but phpMyAdmin spits back "Access denied for user..."


Thanks,

You need to go into the reseller panel to setup more of anything for a particular user.

Click > Reseller Panel > List/Modify Accounts > Next click on the user you would like to give access to 3 MySQL DBs.

The only mysql user that has access to all of a User's databases is the DirectAdmin username/password. It will be the exact same user/pass that you use to login.

John

Hmmm.... while all that makes sense to me, it seems somewhat illogical.

What if user "x" wants to have 3 DB's sharing the same user? Obviously I am not going to give him the admin user info, doesn't it make sense to have it setup like this:

Login to the user account, click "MySQL databases" choose "Create new database" and if a user is already made have a drop down that says "Use this user: domain_user" or "Create new user..."??

That way we can have both options.

What do you think?

plesk stylee

Hello,

We can have a look at something like that, after FreeBSD

John

Well, I guess that's ok....

Go FreeBSD!