====== Manage MySQL databases ======

===== Creating a MySQL database =====

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

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

  - Sign in to Virtualmin (''%%https://xxxxxxxx.fb.joyent.us:10000%%'').
  - 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.
  - Click **Edit Databases**. You should now see a list of your current databases on the //Edit Databases// page.
  - Click **Create a new database.** 
  - 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// ).
  - For //Database server type//, select **MySQL**.
  - For //Character set for MySQL database//, choose a character set for your database (the default is UTF-8 Unicode).
  - Click **Create** Your database has now been created.
  - 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:

  - Sign in to Virtualmin (''%%https://xxxxxxxx.fb.joyent.us:10000%%'').
  - 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.
  - Click **Edit Databases**. You should now see a list of your current databases on the //Edit Databases// page.
  - 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.
  - 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.