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?
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.