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 how to find all the necessary settings to configure your scripts and CMS.
Database management
To access your hosting database management page:
- open the Manager (manager.infomaniak.com)
- go to Web Hosting
- if necessary click on the hosting/domain name concerned
- 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
Link to this FAQ: