Virtualmin /webmin Mysql user problem

Posted on 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.

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

This textbox defaults to using Markdown to format your 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.

pablo

October 12, 2013

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

malcb

September 19, 2014

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.