Create a database / manage MySQL/MariaDB users

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

Database management

To access your hosting database management page:

1. open the Manager (manager.infomaniak.com)
2. go to Web Hosting
3. if necessary click on the hosting/domain name concerned
4. in the left side panel, click on Databases

Data base

Under the Databases tab you can:

• create a MySQL/MariaDB database by clicking on the Add database button
• import , export or restore a MySQL database using the arrow in the right part 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 information required to configure CMS or web applications:

• the name of a database (for example XXXX _dbname)
• the username of a database (e.g. XXXX _username)
• the password for the username of a database (the one you chose when creating the MySQL/MariaDB user to redefine if you have forgotten it)
• the MySQL/MariaDB database server / the hostname (for example XXXX .myd.infomaniak.com ) with its version (5.7 for example)

User rights

• with read rights : the user can only see the structure and content of a table and therefore perform SELECT type queries
• with write rights : the user can modify the structure and content of the database
• with administrative rights : the user can delete the database
• without any rights : the user will not see the database appear in phpMyAdmin

Web application databases

• WordPress
• Joomla