Is there a way to give someone login information for my phpmyadmin but only allow them to see/manipulate a specific database? I am getting some new software and the guy who has written it has requested an ftp username as well as access to my phpMyAdmin....now I can set up an ftp account for him that will only allow him to get into the one area, but is there any way to do this with phpmyadmin?

6/25/2009 4:31:56 PM

IIRC, each database can/does have it's own password, but this is by no means something I work with very often.

6/25/2009 4:33:53 PM

well the database itself each has it's own password....but the actual phpmyadmin URL requires a separate login that as far as I know...I only get one of....and even if I could have two, I'd need to limit what that second user would see on my phpmyadmin...?

6/25/2009 4:44:11 PM

http://www.devshed.com/c/a/PHP/Doing-More-With-phpMyAdmin-Part-1/

6/25/2009 5:02:07 PM

he should be able to log in with the individual db user/pass, so long as that user/pass has full access (select, insert, update, reference, delete, etc.)

6/25/2009 5:26:35 PM

phpmyadmin just uses the grant tables from mysql

so just grant the permissions for that one database to his username and you should be set

6/25/2009 6:17:49 PM

hmmm.....well I access phpMyAdmin on the web (not on my own computer) so it's a URL and the username and password are the admin ones that I'm not giving out to anyone...(this is for my business which I use hostgator and that manages it)... I've never used the phpmyadmin client itself...whenever I've needed to do anything sql related on my personal server, I just login via ssh...

But anyway, I decided that there was no reason why he needed to access my database because I can run the sql file myself...which I assumed he knew....but apparently he did not so he's going to send me the file, supposedly.

Thanks for your help guys

6/25/2009 7:26:25 PM

if the guy who wrote your software didn't know that you could run mysql queries from the command line, i think it's time you found a new software developer.

6/25/2009 7:44:39 PM

all he has to do is login to the phpmysqladmin using the login/pass for his database. It will only let him see and manipulate that db. It's pretty easy.

6/25/2009 7:45:37 PM