`

JoyentJoyent

Knowledge Base

9.1. Creating a MySQL database

The best way to create a new MySQL database is through Webmin. Although you can create MySQL databases in phpMyAdmin, the database will not show up in Webmin. This can be problematic if you want to create a separate MySQL user.

Note: database names can only contain alphanumeric characters and underscores. Other characters, like periods, will cause an error.

  1. Login to Webmin (https://webmin.server.textdrive.com/)

    Note: You'll need to substitute server with the name of the actual server for your account.

  2. In the Servers section, click Virtualmin Virtual Servers
  3. Under Domain name, click the link for the domain you’d like to add a MySQL database to
  4. Near the bottom of the page, click Edit Databases
  5. Click Create a new database
  6. In the Database name field enter a name for your database
    Note: database names can only contain alphanumeric characters and underscores. Other characters, like periods, will cause an error.
  7. Under Database server type, make sure to select MySQL
  8. Click Create
  9. Click Return to database list to see your list of databases

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