{"id":11297,"date":"2022-10-11T12:40:14","date_gmt":"2022-10-11T10:40:14","guid":{"rendered":"https:\/\/assistance.groupemagiconline.com\/?post_type=ht_kb&p=11297"},"modified":"2022-10-11T12:43:34","modified_gmt":"2022-10-11T10:43:34","slug":"affecter-un-utilisateur-mysql-a-ma-base-de-donnees","status":"publish","type":"ht_kb","link":"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/affecter-un-utilisateur-mysql-a-ma-base-de-donnees\/","title":{"rendered":"Assign a MySQL user to my database"},"content":{"rendered":"

In this guide we will see how to assign a MySQL user to your 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
In the section YOUR MYSQL USERS<\/strong>\u00a0click on the button ACTIONS<\/b> of the desired user, then\u00a0Change rights<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Choose the database and click on the button\u00a0ADD<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
The user is now assigned to the database. You can do the same for the other databases.<\/p>\n
\"\"<\/a><\/pre>\n
New Planet space<\/h2>\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 RIGHTS<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Choose the database and click on the button\u00a0ADD<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
The user is now assigned to the database. You can do the same for the other databases.<\/p>\n
\"\"<\/a><\/pre>","protected":false},"excerpt":{"rendered":"
In this guide we will see how to assign a MySQL user to your database. The first step is to go to your Magic Online or Nuxit client interface. Then click on Hostings. Click on the DATABASE MANAGEMENT button. In the section YOUR MYSQL USERS click on the button ACTIONS...<\/p>","protected":false},"author":52,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[20,734,1246,727],"ht-kb-tag":[1272],"class_list":["post-11297","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hebergements-web","ht_kb_category-mutualise-standard","ht_kb_category-hebergements-cloud-evolution","ht_kb_category-mysql-prive","ht_kb_tag-affecter-un-utilisateur-mysql-a-ma-base-de-donnees"],"_links":{"self":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/11297","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=11297"}],"version-history":[{"count":1,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/11297\/revisions"}],"predecessor-version":[{"id":11311,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/11297\/revisions\/11311"}],"wp:attachment":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/media?parent=11297"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=11297"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=11297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}