Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
My SQL: creating a database / managing users
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 databases
- Open the Manager (manager.infomaniak.com)
- Go to Web Hosting
- If necessary, click the hosting/domain name concerned
- In the left side panel, click Databases
In the Databases tab you can:
- create a MySQL database by clicking Add a database
- import, export or restore a MySQL database using the arrow in the right part of the Add button
In the Users tab you can:
- create a MySQL database user by clicking the Add a user button
It is also where you can 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 reset 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 read-only 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
MySQL Web applications information
WordPress: https://faq.infomaniak.com/2072
Joomla: https://faq.infomaniak.com/272
Link to this FAQ: