{"id":11312,"date":"2022-10-11T14:58:05","date_gmt":"2022-10-11T12:58:05","guid":{"rendered":"https:\/\/assistance.groupemagiconline.com\/?post_type=ht_kb&p=11312"},"modified":"2022-10-13T09:03:07","modified_gmt":"2022-10-13T07:03:07","slug":"gerer-un-utilisateur-mysql","status":"publish","type":"ht_kb","link":"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/gerer-un-utilisateur-mysql\/","title":{"rendered":"Manage a MySQL user"},"content":{"rendered":"

In this guide we will see how to manage a user of your MySQL database.<\/p>\n

\t\t

\r\n \t\t\t \t\t\t \t\t\t\t

\r\n \t\t\t\t\tThis option is reserved for<\/strong> to subscribers who have ordered the MySQL Private (SQLGOLD)<\/strong><\/a>. \t\t\t\t<\/p>\r\n \t\t\t \t\t\t\r\n \t\t<\/div>\r\n \t\t<\/p>\n

First, go to your trademark control panel, Magic Online<\/a> or Nuxit<\/a>.<\/p>\n

Then click on Lodging<\/strong>.<\/p>\n

\"Lodging<\/a><\/pre>\n
Click on the button DATABASE MANAGEMENT<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
It is possible to :<\/p>\n
Add a user from your existing database.<\/a>
\nAssign a MySQL user to your database.<\/a>
\nChange the user's password.<\/a>
\nChange the value max_user_connections.<\/a>
\nDelete the user.<\/a><\/p>\n
Change password<\/h2>\n
Go to the customer area > Menu Lodging<\/strong> > Heading MANAGEMENT DATABASE<\/strong> DATA <\/strong>> Section YOUR MYSQL USERS<\/strong>.<\/p>\n
Then click on the button ACTIONS<\/b> of the desired user, then Change password<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Enter the new password and click on the button VALIDATE<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
The password has been modified, the interface displays this confirmation message.<\/p>\n
\"\"<\/a><\/pre>\n
New Planet space<\/h3>\n
Always start by going to your client interface Magic Online<\/a> or Nuxit<\/a>.<\/p>\n
Then click on the menu Support<\/strong> or Authcode domain<\/strong>\u00a0which lead directly to the Planet interface.<\/p>\n
\"\"<\/a><\/pre>\n
Once the interface is open, follow the menu\u00a0Shared Hosting<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Click on WEB MANAGEMENT<\/strong> of the accommodation in question.<\/p>\n
\"Nuxit<\/a><\/pre>\n
In the section YOUR MYSQL USERS<\/strong>\u00a0click on the button ACTIONS<\/b> of the desired user, then CHANGE PASSWORD<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Enter the new password and click on the button VALIDATE<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
The password has been modified, the interface displays this confirmation message.<\/p>\n
\"\"<\/a><\/pre>\n
Change the value max_user_connections<\/h2>\n
Go to the customer area > Menu Lodging<\/strong> > Heading MANAGEMENT DATABASE<\/strong> DATA <\/strong>> Section YOUR MYSQL USERS<\/strong>.<\/p>\n
Then click on the button ACTIONS<\/b> of the desired user, then Edit max_user_connections<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Set the new value and click on the button VALIDATE<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
The change is taken into account, the interface displays this confirmation message.<\/p>\n
\"\"<\/a><\/pre>\n
New Planet space<\/h3>\n
Always start by going to your client interface Magic Online<\/a> or Nuxit<\/a>.<\/p>\n
Then click on the menu Support<\/strong> or Authcode domain<\/strong>\u00a0which lead directly to the Planet interface.<\/p>\n
\"\"<\/a><\/pre>\n
Once the interface is open, follow the menu\u00a0Shared Hosting<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Click on WEB MANAGEMENT<\/strong> of the accommodation in question.<\/p>\n
\"Nuxit<\/a><\/pre>\n
In the section YOUR MYSQL USERS<\/strong>\u00a0click on the button ACTIONS<\/b> of the desired user, then MODIFY MAX_USER_CONNECTIONS<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Set the new value and click on the button VALIDATE<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
The change is taken into account, the interface displays this confirmation message.<\/p>\n
\"\"<\/a><\/pre>\n
Delete user<\/h2>\n
Go to the customer area > Menu Lodging<\/strong> > Heading MANAGEMENT DATABASE<\/strong> DATA <\/strong>> Section YOUR MYSQL USERS<\/strong>.<\/p>\n
Then click on the button ACTIONS<\/b> of the desired user, then Delete user<\/strong>.<\/p>\n
If the link does not appear, it is not possible to apply the deletion because it is a default user of an existing database. You must first delete the database to be able to delete him.<\/p>\n
\"\"<\/a><\/pre>\n
Confirm with YES<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
The deletion is applied. If one of your sites uses this user, you must make the change quickly to avoid any connection errors.<\/p>\n
\"\"<\/a><\/pre>\n
New Planet space<\/h3>\n
Always start by going to your client interface Magic Online<\/a> or Nuxit<\/a>.<\/p>\n
Then click on the menu Support<\/strong> or Authcode domain<\/strong>\u00a0which lead directly to the Planet interface.<\/p>\n
\"\"<\/a><\/pre>\n
Once the interface is open, follow the menu\u00a0Shared Hosting<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Click on WEB MANAGEMENT<\/strong> of the accommodation in question.<\/p>\n
\"Nuxit<\/a><\/pre>\n
In the section YOUR MYSQL USERS<\/strong>\u00a0click on the button ACTIONS<\/b> of the desired user, then DELETE THE USER<\/strong>.<\/p>\n
If the link does not appear, it is not possible to apply the deletion because it is a default user of an existing database. You must first delete the database to be able to delete him.<\/p>\n
\"\"<\/a><\/pre>\n
Enter the new password and click on the button VALIDATE<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
The password has been modified, the interface displays this confirmation message.<\/p>\n
\"\"<\/a><\/pre>","protected":false},"excerpt":{"rendered":"
In this guide we will see how to manage a user of your MySQL database. You need to start by going to your Magic Online or Nuxit client interface. Then click on Hostings. Click on the DATABASE MANAGEMENT button. It is possible to: Add a user from your database...<\/p>","protected":false},"author":52,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[734,1246,733,727],"ht-kb-tag":[],"class_list":["post-11312","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mutualise-standard","ht_kb_category-hebergements-cloud-evolution","ht_kb_category-performance","ht_kb_category-mysql-prive"],"_links":{"self":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/11312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/comments?post=11312"}],"version-history":[{"count":3,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/11312\/revisions"}],"predecessor-version":[{"id":11352,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/11312\/revisions\/11352"}],"wp:attachment":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/media?parent=11312"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=11312"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=11312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}