Possible for Virtualmin to Create Database at user level?

6 posts / 0 new
Topic locked
Last post
#1 Sun, 01/15/2012 - 12:38
kotakomputer

Possible for Virtualmin to Create Database at user level?

I have read this doc: http://www.virtualmin.com/documentation/tutorial/how-to-create-database

And wonder if Virtualmin logged as user can create a database. This is very important for user hosting to create their own database without admin/root access.

Sun, 01/15/2012 - 17:55
andreychek

Yup, a Virtual Server owner can create a database user, if they have rights to do so (which I believe they do by default).

-Eric

Mon, 01/16/2012 - 04:00
kotakomputer

Ok after playing more than 2 hours on Virtualmin UI I found the Create Database feature!

Why so long? Because when I click "Server - MySQL Database Server" then Virtualmin show me the default database but there is a small link "Return to database list". This happen WHEN THERE IS 1 DATABASE ONLY.

So, I think better Virtualmin show the list of database when I click "Server - MySQL Database Server", even ONLY 1 DATABASE, ok?

Also, by default Virtualmin better automatically add PREFIX to the database name, think this server used by many people in Share Hosting environment.

Sun, 01/22/2012 - 07:53
framon

kotakomputer is right, it would be nice to have the account owner name as prefix for database the virtualmin user creates, in this way is very easy to see which database belong to who.

user: romolo

databases: romolo_drupal, romolo_wpress

is it currently possible to tun on this setting / behaviour ?

Sun, 01/22/2012 - 22:42
andreychek

Sure, you can do that.

To set a database prefix, go into System Settings -> Server Templates -> Default -> MySQL Database.

In there, you can tweak "Prefix for additional databases".

On my system, I typically set that to:

${USER}_

Thu, 01/26/2012 - 02:39
framon

Thanks for the tip I'll try to tweek the settings

Topic locked