Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a user that has a set of privileges for all databases in an instance of MariaDB. I'm wondering how the same set of privileges can be made to cover a certain set of databases. Below are my questions with regard to this.

MariaDB [(none)]> show grants;
+----------------------------------------------------------------------------+
| Grants for tester1@localhost                                               |
+----------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON *.* TO |
| 'tester1'@'localhost' IDENTIFIED BY PASSWORD '*AF123'                      |
+----------------------------------------------------------------------------+

What is the simplest way to constrain those privileges to a single, or a set of databases?

How can a certain set of privileges be expanded to include additional databases?

Can this be done using phpMyAdmin?

share|improve this question
    
Last time I used it I could issue any command via phpMyAdmin... So I imagine this is possible if it is possible otherwise. –  dezso Jun 27 '13 at 21:47
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.