This guide explains how to add a MySQL/MariaDB database, create or modify users and how to find all the necessary parameters to configure your scripts and CMS on a Web Hosting.

Manage databases

To access the database management page of your hosting:

1. Click here to access the management of your product on the Infomaniak Manager (need help?).
2. Click directly on the name assigned to the relevant product.
3. Click on Databases (or MariaDB if necessary) in the left sidebar:
   

Databases

Under the Databases tab, you can:

• Create a MySQL/MariaDB database by clicking the Add a database button.
• Import, export or restore a MySQL database by clicking on the dropdown arrow ‍ to the right of the Add button.

Users

Under the Users tab, you can:

• Create a MySQL/MariaDB database user by clicking the Add user button.

Configuration information

This is also where you will find the required information to configure CMS or web applications:

• The name of a database (for example XXXX_dbname)
• The username of a database (for example XXXX_username)
• The password for the database username (the one you chose when creating the MySQL/MariaDB user reset if you have forgotten it)
• The MySQL/MariaDB server for databases / the host name / hostname (for example XXXX.myd.infomaniak.com) with its version (5.7 for example)

User rights, shared servers & Cloud

• With read permissions: “SELECT”
• With write permissions: "INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES"
• With admin rights: "CREATE, DROP, INDEX, ALTER, CREATE VIEW, SHOW VIEW, REFERENCES"
  • + "CREATE ROUTINE, ALTER ROUTINE, EXECUTE, TRIGGER, EVENT" on Cloud Server only (refer to this other guide for more information)
• With no rights: the user will not see the database appear in phpMyAdmin

Web application databases

• Refer to this other guide about WordPress.
• Refer to this other guide about Joomla.