Connect to phpMyAdmin as a non-administrative user

[eugenio]

Sorry for my english.

I've 2 db (db1 and db2) and for each db I've assigned a user (user1, user2) with all privileges.

I would each user can connect to phpMyAdmin with specific username e password, because there are really two user and I wouldn't give them main username/password of the site.
Can they do?
Bisides, is it possbile each connect directly to own db, so user1 don't access to db2 and user don't access to db1?

Thank you
Regards
Eugenio

[shadmego]

Unfortunately, the only user that can use phpmyadmin is the CPanel user (or root user) for your account. This is the user HM created for you when you signed up with them.

This is done for security purposes. There is a way that you can allow remote access to the database for other users, but it involves downloading a remote database management program and adding the remote database IP address in CPanel AND the mysql firewall through your account preferences page.

Check out some posts here that talk about remote access to mysql.

Here is a good one. (http://www.hostmonsterforum.com/showthread.php?t=2663&highlight=remote+access+mysql)

As far as user1 accessing db2, as long as you don't give permissions to user1 on db2, there should be no way for a user to access a database that they don't have permissions on.

~regards, and welcome to the community

[eugenio]

Nooooo! :-(

Thank you shadmego!
Regards