Overview
The MG panel gives direct access to Maria DB. The interface allows you to manage databases of Internet sites. It is possible to create databases, delete them, add users with privileges, just to give an idea of the possibilities available to you.
In the following, we will limit ourselves to information related to the use for beginners.
You may refer to the article PhpMyAdmin if deemed necessary.
Note :The Glossary contains explanations on multiple topics and can be consulted to clarify certain terms.
Prerequisite
Access to https://mg.n0c.com/en/.
Concepts to be Known
Details on Users Privileges
Throughout this article, some English terms related to user privileges will come up often. We invite you to refer to the table below to understand their meaning.
| Privilege | Definition |
| ALTER | Modify properties (ALTER AGGREGATE, ALTER CONVERSION, etc.). |
| ALTER ROUTINE | Modify the definition of a routine, that can be an aggregate function, a normal function or a procedure. Routines are SQL objects that allow defining a logic to apply to data. |
| CREATE | Define a table (CREATE TABLE), a new database (CREATE DATABASE), etc. |
| CREATE ROUTINE | Group stocked functions and procedures. |
| CREATE TEMPORARY TABLES | Create a temporary table. A temporary table exists only in the session that created it. |
| CREATE VIEW | Define a view. A view is a virtual table; in other words, it is a table whose data are not stored in the database, and containing informations from many tables. |
| DELETE | Delete lines in a table. By using commands associated to WHERE, it is possible to select the lines that will be deleted. |
| DROP | Permanently delete a table from a database (DROP TABLE), a role (DROP ROLE), etc. |
| EVENT | Allow to obtain data to monitor or solve problems in SQL. |
| EXECUTE | Execute a prepared instruction. |
| INDEX | Perform commands associated to indexes such as CREATE INDEX. With an index placed on one or many columns, a database system can first search data on the index and, if what is searched is found, it knows more rapidly where are the records. |
| INSERT | Insert data in a table. |
| LOCK TABLES | Lock a table. |
| REFERENCES | The reference permission on a table allows to create a foreign key that refers to this table; this way, administrators can perform required modifications without having to take into account the needs of the persons to whom the table has been referenced. |
| SELECT | Return the records in a result table. This command can select one or many columns in a table. |
| SHOW VIEW | Display the value of a executions parameter. |
| TRIGGER | Execute a set of SQL instructions right after an event. |
| UPDATE | Perform modifications on existing lines. Often, this command is used with WHERE to specify on which lines the modification is applicable. |
Icons for Managing Passwords
When you have to create or change passwords, there are some icons that will be very useful. The table below explains their meaning.
| Icon | Description |
| 1 | Hide (or display) password |
| 2 | Password complexity (a red icon shows that the password is not secure enough). |
| 3 | Generate a password. |
| 4 | Copy the password. |
SQL Databases Management
Access to the Interface
In the Sidebar menu, select Databases -> SQL Databases:
Please note that the CURRENT DATABASES are displayed at the top of the window and the CURRENT USERS are listed at the bottom.
Create an SQL Database with a New User
- Click on the Create button:
- Enter the name of the DATABASE:
- It is recommended to create a database user at this point. Check Create Database User checkbox.
- Provide the USERNAME:
- Provide the PASSWORD.
- Set the user’s privileges by checking or unchecking the appropriate boxes.
- Click on the CREATE button.
Create a Database User
- In the CURRENT USERS window, click on the Create button:
- Enter the USERNAME:
- Provide a PASSWORD.
- Choose the ASSOCIATED DATABASE.
- Define the privileges:
- Click on the CREATE button.
- Confirmation messages are displayed and the user is added to the list of CURRENT USERS.
Modify Usernames and/or Passwords
- Locate the database and click the Rename icon next to the user whose name or password you want to change:
- Enter the new USERNAME and/or PASSWORD in the appropriate field.
- Click on the SAVE button.
- Confirmation messages are displayed.
Add an User to a Database
Typically, several users will need to connect to the database. It is necessary to add them one by one.
- Locate the database and click on the Add another user icon:
- Choose the USER:
- Click on the ADD button.
- A confirmation message is displayed.
- The user is displayed alongside the database:
Manage Database User Privileges
Anytime, it is possible to modify the privileges of a database user.
- Locate the database and click on the Modify User Privileges icon:
- Check or uncheck the appropriate boxes:
- Click on the SAVE button.
- A confirmation message is displayed.
Delete Users
It is advisable to delete users who no longer use your databases.
- Identify the user you wish to remove and click on the Delete icon:
- Approve the deletion at the command prompt.
- A confirmation message is displayed.
Remove a User’s Access to a Database
Il est essentiel de maintenir à jour l’accès des utilisateurs à vos bases de données.
- Locate the database and the user to which you want to remove all privileges and click on the Delete icon:
- Approve the deletion at the command prompt.
- A confirmation message is displayed.
Delete an SQL Database
It is recommended to delete your databases if they are no longer used.
- Identify the database and click on the Delete icon:
