Solved

phpmyadmin access with user other than root

Posted on 2011-03-14
3
329 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

The purpose of this article is to fix the unknown display problem in Linux Mint operating system. After installing the OS if you see Display monitor is not recognized then we can install "MESA" utilities to fix this problem or we can install additio…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

822 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