Setting up a MySQL Database

The next thing you will want to do is setup a database. The most common database in use today is MySQL. You can also setup NoSQL databases if you choose, such as Riak, CouchDB or MongoDB. The easiest way to setup a database on your SmartMachine is through the web GUI management portal, Webmin. For these instructions, you will use Webmin to setup a MySQL database. You can find more information on Webmin [here].

At a Glance This topic guides you through setting up a MySQL database through Webmin/Virtualmin on your SmartMachine.

To create a new database:

Database names are case sensitive and can only contain alphanumeric characters and underscores.

1. Log in to Webmin (follow instructions here on how to find login credentials for your SmartMachine).
2. Select a domain from the drop-down in the left-hand navigation pane. This is the domain to which you will add a new database.
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.

   Virtualmin creates the database name by pre-pending the domain name to the name you give. The character limit for a database name is 64 characters (hard coded in MySQL).

6. For Database server type, select MySQL.
7. Click Create. 

This generates a new database with the name you specify. You can see a list of all your databases by clicking the Return to database list link.

When accessing a database using a domain-username login, there is a 16 character limit to MySQL usernames. Check the MySQL login suggested by Webmin under Edit Mail and FTP Users > User > Other Users Permisions.