Table of Contents

Manage MySQL databases

Creating a MySQL database

To create a new database through Virtualmin, do the following:

Database names are case sensitive and can only contain alphanumeric characters and underscores. Other characters, like periods, will cause an error.

  1. Sign in to Virtualmin (https://xxxxxxxx.fb.joyent.us:10000).
  2. Select a domain from the drop-down in the left-hand navigation (your main domain should be already selected when you first login to Virtualmin). This is the domain that you'll add a new database to.
  3. Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
  4. Click Create a new database.
  5. In the Database name field enter a name for your database
    • Database names will automatically be prefixed with your main user name. On secondary domains, the first part of the domain name is inserted as a second prefix after the user name (e.g., username_domainname_dbname ).
  6. For Database server type, select MySQL.
  7. For Character set for MySQL database, choose a character set for your database (the default is UTF-8 Unicode).
  8. Click Create Your database has now been created.
  9. Click Return to database list to see your list of databases

You should now see your newly created database listed under Database name.

Deleting a MySQL database

To delete a database through Virtualmin, do the following:

  1. Sign in to Virtualmin (https://xxxxxxxx.fb.joyent.us:10000).
  2. Select a domain from the drop-down in the left-hand navigation (your main domain should be already selected when you first login to Virtualmin). This is the domain that you'll add a new database to.
  3. Click Edit Databases. You should now see a list of your current databases on the Edit Databases page.
  4. Select the database you want to delete from the left-hand column and click Delete Selected. You will now see a confirmation screen verifying that you want to delete this database.
  5. Click Delete Now Your MySQL database should now be deleted. Click Return to database list if you wish to return to your list of databases for this domain.