PDA

View Full Version : Restricting access to databases


jipskin
02-06-2006, 08:43 PM
I'm not sure if this is the appropriate place for this question but any help is appreciated.

I have phpMyAdmin installed on my server and a client of mine wants to be able to edit his website's database to make minor changes. Is it possible to give him a unique user name and password so that he only has access to his database and none of the other ones on my server?

Thanks in advance for your help.

GJay
02-06-2006, 09:04 PM
You can use the 'CREATE USER' command, and grant/revoke permissions as you see fit. You'll need to have permission yourself to do this of couse, but I assume it's your server+DB:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html