7
1
I want a non-techie (marketing/sales) to have access to the data I manage regularly via phpMyAdmin:
- without any ability to alter/insert/delete
- without me having to build a special database-viewer-app
I have created a new User with limited privileges, but I don't want My non-techie to have to use a command prompt and learn mysql commands.
Optimally I want him to be able to go to phpmyadmin UI, but only have the abilities allowed (in this case read-only).
Do I need to set up a separate phpmyadmin where the controlling user is this weaker user? Or is there a special "log in as a specific user" interface I've missed in the documentation?
UPDATE:
I've seen login screens as googletorp suggested when i used pmas auto-installed by hosts but never on the out-of-the-box versions i've installed.
I tried commenting out $cfg['Servers'][$i]['user'], and $cfg['Servers'][$i]['pass'] googletorp suggested - that perhaps it would present me with a login screen. But instead I get error #1045:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Then I thought to perhaps comment out the $cfg['Servers'][$i]['controluser'] and $cfg['Servers'][$i]['controlpass']. But the comments say they're already supposed to be a read-only user.
hm...
my specific question is how one can "login with the user you created and see how the interface looks." by opening phpmyadmin, i am automatically "running mysql" through my original fully powered user. i think i can set the user through which mysql is accessed via the config file... but i don't want to change the config file every time i want the guy in marketing to look at the database. i want to send him to essentially go to a login screen where he can login with the restricted user i've created. is there such a UI in phpmyadmin, or can it only ever act under the user in the config file? – Jonah Goldstein – 2010-09-28T08:08:19.600
hmmm... perhaps my response to holms is clearer? at least i hope so:) – Jonah Goldstein – 2010-09-28T08:18:20.413
I tried removing the user in the configuration file and got an error, described a little more above. You're right though - I have seen this screen before when PMA was installed automatically by a host, but never when I've installed it. – Jonah Goldstein – 2010-09-29T16:20:38.900