phpmyadmin access with user other than root

Hi,
My web developer needs to access a specific database, and he wants to be able to use phpmyadmin for that purpose. I created a user for him which has all the priviledges for that specific database. However I do not want him to know my root password. Is there any way he can access phpmyadmin and only work within its priviledges?

Cheers!
LVL 4
degarayAsked:
Who is Participating?
 
Mark BradyPrincipal Data EngineerCommented:
Yes, if you create a new user you can give him ALL privillages on a specific database ONLY and he can connect only to that database not others. You should of course test the new user before handing it to him. Write a connection script using his username/password combination and connect him to his database. Make sure that works, then try connecting him to any other database and make sure you get permission denied error.
0
 
degarayAuthor Commented:
There was something wrong going over there, however, I deleted the user and created a new one just the way you told me and that seems to work.
0
 
Mark BradyPrincipal Data EngineerCommented:
excellent!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.