Question: How do I create a new database? Print

Answer : 

Creating a new database is required when installing applications such as WordPress, Joomla, Laravel, custom PHP scripts, or when setting up a development environment. GHFS Hosting allows you to create databases easily using the Plesk control panel.

This article explains how to create a database and database user step by step.

1. Create a New Database in Plesk

Steps:

1. Log in to your Plesk panel

2. Go to Websites & Domains

3. Click Databases

4. Click Add Database

5. Enter a Database Name

6. Under Related Site, choose the domain (optional)

7. Under Database Server, select MySQL/MariaDB (default)

2. Create or Assign a Database User

You must choose how to assign a database user:

Option A: Create a new user

1. Select Create a new database user

2. Enter a username

3. Enter a strong password

Option B: Assign an existing user

• Choose User from the dropdown list

This user must have sufficient permissions to access the database.

3. Allow Remote Access (Optional)

If you want to connect from an external MySQL client:

• Enable Access Control

• Allow access from specific IPs

By default, databases are accessible only locally for security.

4. Save the Database

When finished:

1. Click OK

2. Your database will be created

You will now see:

• Database name

• Database user(s)

• Management tools (phpMyAdmin, access settings, etc.)

5. Using the Database for Applications

Provide the following details when installing software like WordPress:

GHFS Hosting uses localhost as the database server in almost all cases.

6. Edit or Reset Database User Passwords

If needed:

1. Go to Databases

2. Click your database

3. Open User Management

4. Select the user

5. Update the password

Useful when:

• Migrating a site

• Installing a new CMS

• Fixing database connection errors

7. Delete a Database (Be Careful)

If you delete a database:

• All tables and data are permanently removed

• WordPress or other applications will stop working

Only delete databases you are certain you no longer need.

8. When to Contact GHFS Hosting Support

Support can help if:

• You are unsure which database belongs to your site

• You cannot create a new database due to plan limits

• You receive permission or MySQL errors

• You need help configuring a script or CMS

GHFS Hosting can guide you or create the database for you.