Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Manage MySQL/MariaDB Users and Databases
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:
- log in to the Infomaniak Manager (manager.infomaniak.com) using a web browser like Brave or Firefox
- click on the icon at the top right of the interface (or navigate using the left sidebar menu, for example)
- choose Hosting (in the Web & Domain universe)
- click directly on the name of the relevant object in the displayed table
- click on Databases or MariaDB in the left sidebar menu, for example:
or
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 the chevron to the right of the Add button
Users
Under the Users tab, you can:
- create a MySQL/MariaDB database user by clicking the Add a 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 (e.g.,
XXXX_dbname
) - the database username (e.g.,
XXXX_username
) - the password for the database username (the one you chose when creating the MySQL/MariaDB user to reset if you forgot it)
- the MySQL/MariaDB server of the databases / hostname (e.g.,
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 queries
- with write rights: the user can modify the structure and content of the database
- with administrative rights: the user can delete the database
- with no rights: the user will not see the database appear in phpMyAdmin
Web Application Databases
Link to this FAQ: