How to create and manage MySQL databases

If your website runs an application such as WordPress, Joomla, or a custom build, you'll need a MySQL database. You can create and manage it directly from your Extra Administrator account.

Creating a database

1. Log in to Virtualmin with your Extra Administrator account.
2. Go to Edit Databases in the side menu.
3. Click Create a new Database.
4. Enter a name for the database and select the MySQL type.
5. Click Create.

Virtualmin will automatically create an associated user with permissions on that database; you'll see the generated username and password on the same screen.

Managing the database (phpMyAdmin)

1. From Edit Databases, click your database's name.
2. Click the Manage button or the phpMyAdmin icon to open the visual database manager.
3. From there you can import/export .sql files, create tables, or run queries.

Importing or exporting a database

On the database screen you'll find the Import Database and Export Database tabs, which let you upload a .sql file or download a full copy.

Changing the database user's password

Go to Edit Databases → Database Users, select the user, and update the password. Remember to also update this value in your application's configuration file (for example, wp-config.php in WordPress).