How do I create a database in ISPConfig?

Procédure

What is a database?

A database (its abbreviation is BD, in English DB, database) is an entity in which it is possible to store data in a structured way and with as little redundancy as possible.

This data must be able to be used by programs, by different users.

[PERSON_NAME] ISPconfig, these databases are necessarily MySQL databases.

This compatibility will allow you to install the vast majority of CMS (Content Management System or content management system) available on the market (Wordpress, Joomla, Prestashop, Moodle etc ...)

How do you connect to a database?

To make a connection to a database, you must provide 4 parameters :

• The host name (the IP address of your server)
• The database name
• The username
• The user's password
   

You can find connection scripts using the official PHP documentation

How do you create a database in ISPconfig?

INFORMATION : before creating a Mysql user, check that when creating your domain on ISPCONFIG, you have entered the term "client (client)" in the "Client" field.

1. Go to your ISPCONFIG panel

2. [PERSON_NAME] let's first create a database user. [PERSON_NAME], Click on Sites > Database Users > Add New User

3. Fill in the available fields, then click on "Save". Make sure to select the same Client as the one chosen when creating your site.

Below you can find the French equivalents :

Database user = Username of the database

Database password = [PERSON_NAME]

Repeat Database password = Repeat the password for the database.
 

4. [PERSON_NAME] once you have entered these elements, you should get this screen

5. We will now create a database and indicate that we want to connect using the user we have just created.

To do this Sites > Database > Add database

6. For a standard configuration, you must select your database type, add a database name, then select the database username.

When you have completed these elements you can click on "Save"

You have now created a database.

Video procedure