How to Create a MySQL Database in StackCP

Most dynamic websites, from WordPress and WooCommerce to Laravel apps and forums, keep their content in a database. On FimuroHost Cloud Hosting you can create one yourself in StackCP in under a minute.

This guide covers creating the database, what you can do with it afterwards and the details you'll need to connect your site to it.

Before you start

• Name length: the name you choose must be between 6 and 20 characters. StackCP adds a short suffix automatically so your name can't clash with another customer's, so the final name will be a little longer than what you typed.
• Size: each database can currently hold up to 1024 MB (1 GB). Limits can change over time, so ask support if you need more.
• WordPress-optimised packages: WordPress-only packages come with their own database, and you can't add more. If you need extra databases, ask support about moving to a standard Cloud Hosting package.

Create the database

1. Log in to your FimuroHost client area, open Services and select your hosting plan.
2. Click Login to Control Panel / StackCP. StackCP opens with the tools for that website (single sign-on, so there is no second password to type).
3. In the Web Tools section, click MySQL Databases.
4. Under Add a new MySQL Database, type a name (6–20 characters), for example shopdata.
5. Click Create Database.
6. The new database appears in the Manage MySQL Databases list. Note its full name, including the suffix.

Managing an existing database

From the Manage MySQL Databases list you can:

• change the database password
• check how much space the database is using
• log in to it directly (this opens phpMyAdmin)
• delete a database you no longer need (this can't be undone, so export a copy first)

You can also add extra MySQL users and manage existing ones from the same page. A separate user is handy if you want to give a developer access without sharing your main credentials.

The details your website needs

Most applications ask for four values. Here's where they go in a WordPress wp-config.php file:

Common problems

• "Error establishing a database connection" usually means the host is set to localhost or the name is missing its suffix. Copy both values exactly from StackCP.
• Access denied usually means a wrong password. Set a new one in StackCP, then update your config file to match.

Need help?

If something doesn't work as described, open a support ticket from your client area or message us on WhatsApp at 01818160926. Tell us the domain name and what you have already tried, and we'll take it from there.