Solved

phpmyadmin access with user other than root

Posted on 2011-03-14
3
331 Views
Last Modified: 2013-11-15
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!
0
Comment
Question by:degaray
  • 2
3 Comments
 
LVL 20

Accepted Solution

by:
Mark Brady earned 500 total points
ID: 35133182
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
 
LVL 4

Author Closing Comment

by:degaray
ID: 35133330
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
 
LVL 20

Expert Comment

by:Mark Brady
ID: 35133390
excellent!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you use Debian 6 Squeeze and you are tired of looking at the childish graphical GDM login screen that is used by default, here's an easy way to change it. If you've already tried to change it you've probably discovered that none of the old met…
In my business, I use the LTS (Long Term Support) versions of Linux. My workstations do real work, and so I rarely have the patience to deal with silly problems caused by an upgraded kernel that had experimental software on it to begin with from a r…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question