Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

up vote 2 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

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.