I want to configure phpMyAdmin to be able to accept one of several different user account logins. Each user would be allocated a specific database and only have access to that.
The default configuration with phpMyAdmin is one super user, e.g. root which has access to every database on the server.
I need to be able to give people access to certain database(s) but not all.
Could you either
- offer a solution
- comment on my findings with the existing solution below which had to be adjusted to properly work
The following solution works - with an additional step (described below): http://alandoyle.com/tutorials/configuring-phpmyadmin-for-multiple-users/
The additional steps are to first assume you've setup a mysql user and password, e.g. 'anotheruser' and associated this user with a database - i.e. added this user to the list of users that can access that database.
The 2nd additional step is to run the SQL query block quoted in the page of the above solution again (after already running it once, as instructed in the original text, pretty much as quoted (obviously making sure the correct password is used)) but this time for the actual user you want to give access. So if your user name is 'anotheruser', then you replace pma with anotheruser and pmapassword with the password for anotheruser.
So together with all the instructions this seems to work. It would appear then that each time a new user is to be added, that same SQL query has to be run for the new user. But the impression I got from the solution was that this was a one off SQL query to support adding any number of users and adding them to databases via the phpmyadmin ui. Thoughts?
Other solutions looked at on SO (but not quite what I need):
- Is there a tool like phpMyAdmin which can be configured to access just a single database?: http://stackoverflow.com/questions/2446475/is-there-a-tool-like-phpmyadmin-which-can-be-configured-to-access-just-a-single-d
- how to configure config.inc.php to have a loginform in phpmyadmin: http://stackoverflow.com/questions/2341504/how-to-configure-config-inc-php-to-have-a-loginform-in-phpmyadmin