We are teaching MySQL to a class. Students are creating databases but they all go to a default folder. How can we re-direct where each students database goes so only that student has permissions to view his/her own work?
Printable View
We are teaching MySQL to a class. Students are creating databases but they all go to a default folder. How can we re-direct where each students database goes so only that student has permissions to view his/her own work?
a good way to do this is:
connect as root,
create an account for each user/student and now each will have his own folder.
http://dev.mysql.com/doc/mysql/en/create-user.html