Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

With Plesk (v. 10.2.0) I can create multiple user accounts for a MySQL database. I however seem not to find a way to restrict one of the user accounts to read only access. The created users do not have the right to execute GRANT / REVOKE.

Am I supposed to use the root database access account for this which Plesk supposedly uses to create the users?

share|improve this question
up vote 3 down vote accepted

Yes, you'll have to tune in MySQL database. You can do it in shell or via embedded DB manager (phpMyAdmin).

For tuning in Linux shell run

 mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql

I think you would need to tune content of user and db tables, but the best would be to refer to original MySQL documentation.

For DB manager, go to Server > Databases > click icon right to local MySQL database (be sure you don't block pop-ups as phpMyAdmin will open in a new window). Then you can open any database in left menu and if you choose privileges tab, you can tune users access.

share|improve this answer
    
Thanks, that icon is well hidden. – stracktracer May 27 '12 at 10:09
    
Yes, the last paragraph in this answer is very important!! In my Plesk it was Server > Database Servers > The spanner icon on the 'MySQL' row then I clicked on any database and chose privileges and there it was. – Coulton Sep 28 '15 at 22:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.