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

1. Open the Manager (manager.infomaniak.com)
2. Go to Web Hosting
3. If necessary, click the hosting/domain name concerned
4. 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