Creating and Managing Databases in Enhance

Enhance uses MySQL (MariaDB) for databases. This guide covers creating a database, creating a database user, accessing phpMyAdmin, and importing or exporting data.

The Databases Tab

Click your website, then go to Databases. The tab has two sub-sections: Databases and Users. The Databases sub-section lists all databases for the site; the Users sub-section lists all database users with their username, authentication plugin, and which databases they have access to.

Creating a Database

1. Log in to web.teklanhosting.co.uk.
2. Click your website, then go to Databases.
3. Click Add database.
4. Enter a name and click Add.

Enhance automatically prefixes the database name with your account name. For example, if your account is example and you enter mysite, the actual database name will be example_mysite. Use this full prefixed name in your application's configuration.

Creating a Database User

1. Go to the Users sub-tab and click Add user.
2. Enter a username and a strong password.
3. Select which database the user should have access to.
4. Click Add.

Note down the full database name (including the account prefix), the username, password, and host (localhost) — you will need these for your application's configuration file.

Connecting Your Application

Most PHP applications (WordPress, Laravel, Craft CMS, etc.) store database credentials in a config file:

Host:     localhost
Database: example_mysite
Username: example_myuser
Password: yourpassword

For WordPress this is wp-config.php. For Laravel it is the .env file (DB_HOST, DB_DATABASE, DB_USERNAME, DB_PASSWORD).

Accessing phpMyAdmin

phpMyAdmin is available from within Enhance to browse, query, import, and export your databases.

1. Go to Databases and find the database you want to manage.
2. Click the phpMyAdmin icon next to it.

You will be logged in automatically — no separate credentials needed.

Importing a Database

To restore from a .sql dump:

1. Open phpMyAdmin and select your database from the left panel.
2. Click the Import tab.
3. Choose your .sql file and click Go.

For large files (over 50 MB), upload via SFTP and import directly over SSH:

mysql -u example_myuser -p example_mysite < backup.sql

Exporting a Database

1. Open phpMyAdmin and select your database.
2. Click the Export tab.
3. Choose Quick export format SQL and click Go.

Save the downloaded .sql file somewhere safe — it is a complete backup of your database.