How do I create a database under 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 with as little redundancy as possible.

This data must be usable by programs and by different users.

If you have opted for a configuration with 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 connect 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 by 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 correctly entered the term "client (client)" in the "Client" field.

1. Go to your ISPCONFIG panel

2. We will first create a database user. To do this, click on Sites > Database users > Add New User

How do I create a database under ISPConfig?

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

How do I create a database under ISPConfig?

Below you can find the correspondences in French:

Database user = Username of the database

Database password = Password of the database

Repeat Database password = Repeat the password of the database.

4. If you have entered these elements correctly, you should get this screen

How do I create a database under ISPConfig?

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

To do this Sites > Databases > Add database

How do I create a database under ISPConfig?

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

How do I create a database under ISPConfig?

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

You have now created a database.

Video procedure


help.lws.net/a/284
Was this article helpful?

Yes

No

Read 33 147 times

Thank you! Feel free to ask questions about our documentation if you would like more information, and help us improve it.

Similar articles

A question about this article?

Ask the LWS team and the community. Answers are published after moderation.

Ask the LWS team and its community a question

GDPR: Controller: LWS-Ligne Web Services. Purpose: moderation and public publication of your question, possible notification of an answer. Legal basis: consent (Art. 6(1)(a) GDPR). Email retention: 90 days after notification, 12 months maximum without an answer. To exercise your rights, see the GDPR section of our Terms and Conditions.