How to create and manage databases

Learn to create and administer MySQL databases for your web applications.

Basic concepts

What is a database?

A database is an organized system for storing information. Web applications like WordPress, Joomla or PrestaShop need a database to store content, users, settings, etc.

Step by step

Create a database

1

Access the control panel

Inicia sessió a control.intergrid.cat.

2

Go to the databases section

Select your hosting and look for the 'Databases' or 'MySQL' option.

3

Create the database

Click on 'Create database' and enter a descriptive name. Write down the exact name, user and password generated.

4

Assign permissions

Assign a user to the database with the necessary permissions. If it's a new database, usually a user with all permissions is automatically created.

Management

Manage databases

Create additional users

You can create multiple users for the same database with different access permissions.

Change passwords

From the control panel you can change the password of database users at any time.

Delete databases

If you no longer need a database, you can delete it from the panel. This action is irreversible, so make a backup first if you need it.

Best practices

Important tips

Write down the credentials
Save the database name, user, password and server address in a safe place. You will need this data to configure your web applications.
Make regular backups. It is very important to make periodic backups of databases to avoid information loss.
Need help?

If you have problems creating or managing databases, contact our support team.

 Create support ticket