Access to a database not through cpanel?

[Asaphira]

For now, I only know the way to phpMyAdmin through the cpanel. Say I want one of my hostees to access her own database without touching other databases. Is there a way to do that?

[fahim]

Yes and in fact, it's simple.

I'll give you a quick rundown on how to do it.


Login to Cpanel
Click on "Mysql Databases" under the "Databases" box
Create a database for your hostee. If you already created one, skip this step.
Create a user account for your hostee. Once you create their account, your account name will automatically be affixed in front of the hostee's user name. For example, my hosting account with cirtex is under the username "fahimo". If I were to create John an account, his mysql username would actually be fahimo_john.
This user at the moment can not access any of your databases. On that same page, look for "Add Users to your Database". Select your hostee's username and your hostee's database, check the All box under privileges (it's checked by default), and then click "Add User to Database"


Now when your hostee logs into phpmyadmin or through any other script using his user/pass combination, he will be restricted to only the databases you specify.

I hope that helps.

- Fahim Ferdous, Web Developer
thefahim@gmail.com

[Asaphira]

Now when your hostee logs into phpmyadmin or through any other script using his user/pass combination, he will be restricted to only the databases you specify.

Thanks! Though, since phpmyadmin has already been installed into the domain, is that the phpmyadmin my hostee is supposed to log into, or does she have to install her own? Like.. I try to use her user/pass for: http://mydomain.com:2082/3rdparty/phpMyAdmin/index.php (this is obviously not my correct domain) but only my cpanel log-in works. Her user/pass has no effect at all.