{"id":1756,"date":"2020-11-19T15:42:17","date_gmt":"2020-11-19T20:42:17","guid":{"rendered":"https:\/\/kb.n0c.com\/?post_type=ht_kb&p=1756"},"modified":"2026-08-31T12:08:38","modified_gmt":"2026-08-31T16:08:38","slug":"databases","status":"publish","type":"ht_kb","link":"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/","title":{"rendered":"How to Manage Databases with Maria DB"},"content":{"rendered":"\n

Overview<\/strong><\/h2>\n\n\n\n

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.<\/p>\n\n\n\n

In the following, we will limit ourselves to information related to the use for beginners. <\/p>\n\n\n\n

You may refer to the article PhpMyAdmin<\/a> if deemed necessary.<\/p>\n\n\n\n

Note :<\/strong> The Glossary<\/a> contains explanations on multiple topics and can be consulted to clarify certain terms.<\/p>\n\n\n\n

Prerequisite<\/strong><\/h2>\n\n\n\n

Access to https:\/\/mg.n0c.com\/en\/<\/a>.<\/p>\n\n\n\n

Concepts to be Known<\/h2>\n\n\n\n

Details on Users Privileges<\/h3>\n\n\n\n

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.<\/p>\n\n\n\n

Privilege<\/strong><\/td>Definition<\/strong><\/td><\/tr>
ALTER<\/td>Modify properties (ALTER AGGREGATE, ALTER CONVERSION, etc.).<\/td><\/tr>
ALTER ROUTINE<\/td>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.<\/td><\/tr>
CREATE<\/td>Define a table (CREATE TABLE), a new database (CREATE DATABASE), etc.<\/td><\/tr>
CREATE ROUTINE<\/td>Group stocked functions and procedures. <\/td><\/tr>
CREATE TEMPORARY TABLES<\/td>Create a temporary table. A temporary table exists only in the session that created it. <\/td><\/tr>
CREATE VIEW<\/td>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.<\/td><\/tr>
DELETE<\/td>Delete lines in a table. By using commands associated to WHERE, it is possible to select the lines that will be deleted.<\/td><\/tr>
DROP<\/td>Permanently delete a table from a database (DROP TABLE), a role (DROP ROLE), etc.<\/td><\/tr>
EVENT<\/td>Allow to obtain data to monitor or solve problems in SQL.<\/td><\/tr>
EXECUTE<\/td>Execute a prepared instruction.<\/td><\/tr>
INDEX<\/td>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.<\/td><\/tr>
INSERT<\/td>Insert data in a table.<\/td><\/tr>
LOCK TABLES<\/td>Lock a table.<\/td><\/tr>
REFERENCES<\/td>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.<\/td><\/tr>
SELECT<\/td>Return the records in a result table. This command can select one or many columns in a table.<\/td><\/tr>
SHOW VIEW<\/td>Display the value of a executions parameter.<\/td><\/tr>
TRIGGER<\/td>Execute a set of SQL instructions right after an event.<\/td><\/tr>
UPDATE<\/td>Perform modifications on existing lines. Often, this command is used with WHERE to specify on which lines the modification is applicable.<\/td><\/tr><\/tbody><\/table>
Privileges<\/figcaption><\/figure>\n\n\n\n

Icons for Managing Passwords<\/h3>\n\n\n\n

When you have to create or change passwords, there are some icons that will be very useful. The table below explains their meaning.<\/p>\n\n\n

\n
\"Icons<\/a><\/figure><\/div>\n\n\n
Icon<\/strong><\/td>Description<\/strong><\/td><\/tr>
1<\/td>Hide (or display) password<\/td><\/tr>
2<\/td>Password complexity (a red icon shows that the password is not secure enough).<\/td><\/tr>
3<\/td>Generate a password.<\/td><\/tr>
4<\/td>Copy the password.<\/td><\/tr><\/tbody><\/table>
Icons for managing passwords<\/figcaption><\/figure>\n\n\n\n

SQL Databases Management<\/strong><\/h2>\n\n\n\n

Access to the Interface<\/h3>\n\n\n\n

In the Sidebar menu, select Databases<\/strong> -> SQL Databases<\/strong>.<\/p>\n\n\n\n

Please note that the CURRENT DATABASES are displayed at the top of the window and the CURRENT USERS are listed at the bottom.<\/p>\n\n\n\n

Create an SQL Database<\/strong> with a New User<\/h3>\n\n\n\n
    \n
  1. Click on the Create <\/strong>button:<\/li>\n<\/ol>\n\n\n
    \n
    \"\"<\/a><\/figure><\/div>\n\n\n
      \n
    1. Enter the name of the DATABASE<\/strong>:<\/li>\n<\/ol>\n\n\n
      \n
      \"\"<\/a><\/figure><\/div>\n\n\n
        \n
      1. It is recommended to create a database user at this point. Check Create Database User<\/strong> checkbox.<\/li>\n\n\n\n
      2. Provide the USERNAME<\/strong>:<\/li>\n<\/ol>\n\n\n
        \n
        \"\"<\/a><\/figure><\/div>\n\n\n
          \n
        1. Provide the PASSWORD<\/strong>.<\/li>\n\n\n\n
        2. Set the user’s privileges by checking or unchecking the appropriate boxes.<\/li>\n\n\n\n
        3. Click on the CREATE<\/strong> button.<\/li>\n<\/ol>\n\n\n\n

          Create a Database User<\/h3>\n\n\n\n
            \n
          1. In the CURRENT USERS<\/strong> window, click on the Create <\/strong>button:<\/li>\n<\/ol>\n\n\n
            \n
            \"\"<\/a><\/figure><\/div>\n\n\n
              \n
            1. Enter the USERNAME<\/strong>:<\/li>\n<\/ol>\n\n\n
              \n
              \"\"<\/a><\/figure><\/div>\n\n\n
                \n
              1. Provide a PASSWORD<\/strong>.<\/li>\n\n\n\n
              2. Choose the ASSOCIATED DATABASE<\/strong>.<\/li>\n\n\n\n
              3. Define the privileges:<\/li>\n<\/ol>\n\n\n
                \n
                \"\"<\/a><\/figure><\/div>\n\n\n
                  \n
                1. Click on the CREATE<\/strong> button.<\/li>\n\n\n\n
                2. Confirmation messages are displayed and the user is added to the list of CURRENT USERS<\/strong>.<\/li>\n<\/ol>\n\n\n\n

                  Modify Usernames and\/or Passwords<\/strong><\/h3>\n\n\n\n
                    \n
                  1. Locate the database and click the Rename<\/strong> icon next to the user whose name or password you want to change:<\/li>\n<\/ol>\n\n\n
                    \n
                    \"\"<\/a><\/figure><\/div>\n\n\n
                      \n
                    1. Enter the new USERNAME<\/strong> and\/or PASSWORD<\/strong> in the appropriate field.<\/li>\n<\/ol>\n\n\n
                      \n
                      \"\"<\/a><\/figure><\/div>\n\n\n
                        \n
                      1. Click on the SAVE <\/strong>button.<\/li>\n\n\n\n
                      2. Confirmation messages are displayed.<\/li>\n<\/ol>\n\n\n\n

                        Add an User to a Database<\/strong><\/h3>\n\n\n\n

                        Typically, several users will need to connect to the database. It is necessary to add them one by one.<\/p>\n\n\n\n

                          \n
                        1. Locate the database and click on the Add another user<\/strong> icon:<\/li>\n<\/ol>\n\n\n
                          \n
                          \"\"<\/a><\/figure><\/div>\n\n\n
                            \n
                          1. Choose the USER<\/strong>:<\/li>\n<\/ol>\n\n\n
                            \n
                            \"\"<\/a><\/figure><\/div>\n\n\n
                              \n
                            1. Click on the ADD<\/strong> button.<\/li>\n\n\n\n
                            2. A confirmation message is displayed.<\/li>\n\n\n\n
                            3. The user is displayed alongside the database:<\/li>\n<\/ol>\n\n\n
                              \n
                              \"\"<\/a><\/figure><\/div>\n\n\n

                              Manage Database User Privileges  <\/strong><\/h3>\n\n\n\n

                              Anytime, it is possible to modify the privileges of a database user.<\/p>\n\n\n\n

                                \n
                              1. Locate the database and click on the Modify User Privileges<\/strong> icon:<\/li>\n<\/ol>\n\n\n
                                \n
                                \"\"<\/a><\/figure><\/div>\n\n\n
                                  \n
                                1. Check or uncheck the appropriate boxes: <\/li>\n<\/ol>\n\n\n
                                  \n
                                  \"\"<\/a><\/figure><\/div>\n\n\n
                                    \n
                                  1. Click on the SAVE<\/strong> button.<\/li>\n\n\n\n
                                  2. A confirmation message is displayed.<\/li>\n<\/ol>\n\n\n\n

                                    Delete Users <\/strong><\/h3>\n\n\n\n

                                    It is advisable to delete users who no longer use your databases.<\/p>\n\n\n\n

                                      \n
                                    1. Identify the user you wish to remove and click on the Delete<\/strong> icon:<\/li>\n<\/ol>\n\n\n
                                      \n
                                      \"\"<\/a><\/figure><\/div>\n\n\n
                                        \n
                                      1. Approve the deletion at the command prompt.<\/li>\n\n\n\n
                                      2. A confirmation message is displayed.<\/li>\n<\/ol>\n\n\n\n

                                        Remove a User’s Access to a Database<\/h3>\n\n\n\n

                                        Il est essentiel de maintenir \u00e0 jour l’acc\u00e8s des utilisateurs \u00e0 vos bases de donn\u00e9es.<\/p>\n\n\n\n

                                          \n
                                        1. Locate the database and the user to which you want to remove all privileges and click on the Delete<\/strong> icon:<\/li>\n<\/ol>\n\n\n
                                          \n
                                          \"\"<\/a><\/figure><\/div>\n\n\n
                                            \n
                                          1. Approve the deletion at the command prompt.<\/li>\n\n\n\n
                                          2. A confirmation message is displayed.<\/li>\n<\/ol>\n\n\n\n

                                            Delete an SQL Database<\/h3>\n\n\n\n

                                            It is recommended to delete your databases if they are no longer used.<\/p>\n\n\n\n

                                              \n
                                            1. Identify the database and click on the Delete<\/strong> icon:<\/li>\n<\/ol>\n\n\n
                                              \n
                                              \"\"<\/a><\/figure><\/div>\n\n\n

                                              References<\/strong><\/h2>\n\n\n\n

                                              How to Import\/Export Database in Command Line (User Mode).<\/a><\/p>\n\n\n\n

                                              https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/security\/permissions-database-engine?view=sql-server-ver15<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

                                              N0C allows you to perform many functions related to databases which allow you to manage a website. Firstly, the SQL Databases section allows you to manage and create databases, add users, modify their privileges, etc. <\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[164],"ht-kb-tag":[185,186,190,176,188,187,189],"class_list":["post-1756","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databases","ht_kb_tag-database","ht_kb_tag-databases","ht_kb_tag-mysql-2","ht_kb_tag-n0c-2","ht_kb_tag-php-2","ht_kb_tag-phpmyadmin-2","ht_kb_tag-sql-2"],"yoast_head":"\nHow to Manage Databases with Maria DB - N0C KB<\/title>\n<meta name=\"description\" content=\"The article explains how the MG panel provides direct access to MariaDB. The interface allows you to manage website databases. You can create databases, delete them and add users with privileges, to name just a few of the features available to you.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Manage Databases with Maria DB - N0C KB\" \/>\n<meta property=\"og:description\" content=\"The article explains how the MG panel provides direct access to MariaDB. The interface allows you to manage website databases. You can create databases, delete them and add users with privileges, to name just a few of the features available to you.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/\" \/>\n<meta property=\"og:site_name\" content=\"N0C KB\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-31T16:08:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kb.n0c.com\/wp-content\/uploads\/2021\/11\/Bases_donnees_5-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"235\" \/>\n\t<meta property=\"og:image:height\" content=\"107\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kb.n0c.com\\\/en\\\/knowledge-base\\\/databases\\\/\",\"url\":\"https:\\\/\\\/kb.n0c.com\\\/en\\\/knowledge-base\\\/databases\\\/\",\"name\":\"How to Manage Databases with Maria DB - N0C KB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kb.n0c.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kb.n0c.com\\\/en\\\/knowledge-base\\\/databases\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kb.n0c.com\\\/en\\\/knowledge-base\\\/databases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kb.n0c.com\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Bases_donnees_5-1.png\",\"datePublished\":\"2020-11-19T20:42:17+00:00\",\"dateModified\":\"2026-08-31T16:08:38+00:00\",\"description\":\"The article explains how the MG panel provides direct access to MariaDB. The interface allows you to manage website databases. You can create databases, delete them and add users with privileges, to name just a few of the features available to you.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kb.n0c.com\\\/en\\\/knowledge-base\\\/databases\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kb.n0c.com\\\/en\\\/knowledge-base\\\/databases\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kb.n0c.com\\\/en\\\/knowledge-base\\\/databases\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kb.n0c.com\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Bases_donnees_5-1.png\",\"contentUrl\":\"https:\\\/\\\/kb.n0c.com\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Bases_donnees_5-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kb.n0c.com\\\/en\\\/knowledge-base\\\/databases\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/kb.n0c.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\\\/\\\/kb.n0c.com\\\/en\\\/knowledge-base\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Manage Databases with Maria DB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kb.n0c.com\\\/#website\",\"url\":\"https:\\\/\\\/kb.n0c.com\\\/\",\"name\":\"N0C KB\",\"description\":\"Official documentation of the N0C hosting platform\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kb.n0c.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Manage Databases with Maria DB - N0C KB","description":"The article explains how the MG panel provides direct access to MariaDB. The interface allows you to manage website databases. You can create databases, delete them and add users with privileges, to name just a few of the features available to you.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/","og_locale":"en_US","og_type":"article","og_title":"How to Manage Databases with Maria DB - N0C KB","og_description":"The article explains how the MG panel provides direct access to MariaDB. The interface allows you to manage website databases. You can create databases, delete them and add users with privileges, to name just a few of the features available to you.","og_url":"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/","og_site_name":"N0C KB","article_modified_time":"2026-08-31T16:08:38+00:00","og_image":[{"width":235,"height":107,"url":"https:\/\/kb.n0c.com\/wp-content\/uploads\/2021\/11\/Bases_donnees_5-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/","url":"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/","name":"How to Manage Databases with Maria DB - N0C KB","isPartOf":{"@id":"https:\/\/kb.n0c.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/#primaryimage"},"image":{"@id":"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/#primaryimage"},"thumbnailUrl":"https:\/\/kb.n0c.com\/wp-content\/uploads\/2021\/11\/Bases_donnees_5-1.png","datePublished":"2020-11-19T20:42:17+00:00","dateModified":"2026-08-31T16:08:38+00:00","description":"The article explains how the MG panel provides direct access to MariaDB. The interface allows you to manage website databases. You can create databases, delete them and add users with privileges, to name just a few of the features available to you.","breadcrumb":{"@id":"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/#primaryimage","url":"https:\/\/kb.n0c.com\/wp-content\/uploads\/2021\/11\/Bases_donnees_5-1.png","contentUrl":"https:\/\/kb.n0c.com\/wp-content\/uploads\/2021\/11\/Bases_donnees_5-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/kb.n0c.com\/en\/knowledge-base\/databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/kb.n0c.com\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/kb.n0c.com\/en\/knowledge-base\/"},{"@type":"ListItem","position":3,"name":"How to Manage Databases with Maria DB"}]},{"@type":"WebSite","@id":"https:\/\/kb.n0c.com\/#website","url":"https:\/\/kb.n0c.com\/","name":"N0C KB","description":"Official documentation of the N0C hosting platform","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.n0c.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/kb.n0c.com\/en\/wp-json\/wp\/v2\/ht-kb\/1756","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.n0c.com\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/kb.n0c.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/kb.n0c.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.n0c.com\/en\/wp-json\/wp\/v2\/comments?post=1756"}],"version-history":[{"count":32,"href":"https:\/\/kb.n0c.com\/en\/wp-json\/wp\/v2\/ht-kb\/1756\/revisions"}],"predecessor-version":[{"id":23985,"href":"https:\/\/kb.n0c.com\/en\/wp-json\/wp\/v2\/ht-kb\/1756\/revisions\/23985"}],"wp:attachment":[{"href":"https:\/\/kb.n0c.com\/en\/wp-json\/wp\/v2\/media?parent=1756"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/kb.n0c.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=1756"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/kb.n0c.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=1756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}