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.
- 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.