mariadb users

[maxwas]

Hello All,

I have set up apache with per user web directories for a class to test web pages. PHP is enabled for the per users. I have mariadb running on the box too and a few of my students have asked if they can have access to a database to play around with. How do I provide access to students to create/edit/drop their own databases without causing any harm?

Thanks in advance,

Max

 

[Dimitris]

A possible solution would be creating the database(s) for them and give out users which have permissions on those DBs.

create studentsdb, create user student01, create user student02, et cetera. give all those users rights on studentsdb and let them create something, but insist that playing around with it includes drop * so they won't be too invested...