Virtualmin /webmin Mysql user problem

October 11, 2013 3.7k views
I have created several user & virtual server on virtualmin/webmin. Now the problem is when I try to assign a particular user to a particular database, I am able to do .... but that user is able to access all the database. user creation through >edit user webmin>server>mysql>user permission ( i gave Select | Insert | Update | Delete | Create | File | Index permission) to a particular user webmin>server>mysql>Database Permissions and select this particular to a particular database. now through my php application I am able to give the credential of this user and access this database as well as other database... But I want this particular user to access only the assigned database.. Any help is appreciated. Thanks in advacne
3 Answers
For the benefit of others that may find themselves in the same predicament, how were you able to solve it?

webmin>server>mysql>user permission should be set to none. Instead go to database permissions and set the user permissions there. That way the permissions are just for that database and not global. Logical really, just not obvious.

However, I would recommend that a database user is a standard user of the virtual website (which means they also get email, even if you don't use it). Only those users get recreated in a virtualmin backup and restore. Plus you set the database password in the virtual server, edit database, password. Then that too gets recreated in backup/restore.

Have another answer? Share your knowledge.