Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Create a database / manage MySQL/MariaDB users
This guide explains how to add a MySQL/MariaDB database, create or modify users, and find all the necessary parameters to configure your scripts and CMS on a Web Hosting.
Database Management
To access the database management page of your hosting:
- Log in to the Infomaniak Manager (manager.infomaniak.com) from a web browser like Brave or Firefox
- Click on the icon at the top right of the interface (or navigate through the left side menu, for example)
- Choose Hosting (under Web & Domain)
- Click directly on the name of the relevant object in the displayed table
- Click on Databases or MariaDB in the left side menu, for example:
or
Databases
Under the Databases tab, you can:
- Create a MySQL/MariaDB database by clicking on the Add a database button
- Import, export, or restore a MySQL database using the arrow on the right side of the Add button
Users
Under the Users tab, you can:
- Create a MySQL/MariaDB database user by clicking on 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 username of a database (e.g., XXXX_username)
- The password of the database username (the one you chose when creating the MySQL/MariaDB user reset it if forgotten)
- The MySQL/MariaDB server for databases / hostname (e.g., XXXX.myd.infomaniak.com) with its version (5.7, for example)
User Rights
- With read rights: the user can only view the structure and content of a table and perform SELECT-type queries
- With write rights: the user can modify the structure and content of the database
- With administration rights: the user can delete the database
- Without any rights: the user will not see the database in phpMyAdmin
Web Application Databases
Link to this FAQ: