Virtualmin /webmin Mysql user problem

  • Posted October 11, 2013

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


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

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.

For the benefit of others that may find themselves in the same predicament, how were you able to solve it?

Ok I got it solved