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 settings to configure your scripts and CMS on a Web hosting.

Manage databases

To access the database management page of your hosting:

1. Click here in order to access the management of your product on the Manager Infomaniak (Need help?).
2. Click directly on the nameallocated to the product concerned.
3. Click on Databases (or MariaDB (if necessary) in the left side menu:
   

Databases

Under the tab Databases you can:

• Create a MySQL database/MariaDB by clicking on the button Add Database.
• Import, Export or restore a MySQL database by clicking on the chevron ‍ to the right of the button Add.

Users

Under the tab Users you can:

• Create a MySQL/MariaDB database user by clicking on the button Add User.

Configuration information

It is also here that you will find the information required to configure CMS or web applications:

• The name of a database (e.g. XXXX_dbname)
• The user name of a database (e.g. XXXX_username)
• The password the user name of a database ( the one you chose to create MySQL/MariaDB user to redefine if you have forgotten it)
• The MySQL/MariaDB server databases / host name / hostname (e.g. XXXX.myd.infomaniak.com) with its version (5.7 e.g.)

User Rights, Shared Servers & Cloud

• With rights in reading-Select.
• With rights in Writing: "INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES"
• With Rights admin: "CREATE, DROP, INDEX, ALTER, CREATE VIEW, SHOW VIEW, REFERENCES"
  • + "CREATE ROUTINE, ALTER ROUTINE, EXECUTE, TRIGGER, EVENT" on Cloud Server only (be aware of this other guide on this subject)
• Without no rights: the user will not see the database in phpMyAdmin

Web application databases

• Be aware of this other guide about WordPress.
• Be aware of this other guide about Joomla.