These forums are locked and archived, but all topics have been migrated to the new forum. You can search for this topic on the new forum: Search for allow user to create database in a virtual domain on the new forum.
Web Hosting and Cloud Computing Control Panels
Howdy,
For that to work, you'd want to make sure the "MySQL Database Enabled" feature is checked in "Edit Virtual Server".
Additionally, look in Administration Options -> Edit Owner Limits, and make sure they haven't reached the database limit set in "Maximum allowed databases".
And lastly, on that same screen, look in "Allowed capabilities and features", and make sure that "Can manage databases" is checked.
-Eric
great....thanks eric! that worked!
HEllo. I have same problem i create virtual server with real domein name create user and check avrything from this
'' For that to work, you'd want to make sure the "MySQL Database Enabled" feature is checked in "Edit Virtual Server".
Additionally, look in Administration Options -> Edit Owner Limits, and make sure they haven't reached the database limit set in "Maximum allowed databases".
And lastly, on that same screen, look in "Allowed capabilities and features", and make sure that "Can manage databases" is checked. ''
But i user still can manage databases create and manage users and permisions for database
:((((
hello, I have the same problem, all the proper settings have been enabled, but my user still gets "No Privileges" message in phpMyAdmin...
I triple checked everything but still nothing...
please help?
Howdy,
The above steps are about how to allow a user to create databases from within Virtualmin.
There isn't an easy and supported way to do that from within phpMyAdmin, unfortunately.
If a database is created outside of Virtualmin -- Virtualmin won't know about it, and won't know to include it with the backups for that domain.
Because of that, database users don't have rights to create databases, unless it's done using Virtualmin.
If you really wanted, you could manually grant a user MySQL privileges to create a database... but we highly recommend against it, and it will mean Virtualmin won't be able to manage it, and that it won't be part of your backups.
-Eric