Knowledge base

This guide explains how to add a MySQL database and how to find all the settings necessary to configure your scripts and CMS.

Creating or modifying the users of your MySQL database

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

Under the Databases tab you can:

• create a MySQL database by clicking on Add a database
• import, export or restore a MySQL database using the arrow in the right part of the Add button

Under the Users tab you can:

• create a MySQL database user by clicking on the Add a user button

It is also the place where you will find the necessary information to configure CMS or web applications:

• the name of a database (e.g., XXXX_dbname)
• the database user name (e.g., XXXX_username)
• the password for a database user name (the one you chose when creating the MySQL user, to be redefined if you have forgotten it)
• the MySQL server for databases / hostname (e.g., XXXX.myd.infomaniak.com) with its version (e.g, 5.7)

Information on the rights of database users

• with reading rights: the user can only see the structure and content of a table and therefore make SELECT-type requests
• with writing rights: the user can edit the structure and content of the database
• with administration rights: the user can delete the database
• with no rights: the user will not see the database displayed in phpMyAdmin