Question

Virtualmin /webmin Mysql user problem

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

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!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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