{"id":12798,"date":"2020-05-26T07:35:01","date_gmt":"2020-05-26T07:35:01","guid":{"rendered":"https:\/\/test2.gginternal.net\/knowledgebase\/article\/mysql-wizard-creating-a-database-and-a-user\/"},"modified":"2020-05-26T07:35:01","modified_gmt":"2020-05-26T07:35:01","slug":"mysql-wizard-creating-a-database-and-a-user","status":"publish","type":"ht_kb","link":"https:\/\/ggservers.com\/knowledgebase\/article\/mysql-wizard-creating-a-database-and-a-user\/","title":{"rendered":"MySQL Wizard – Creating a Database and a User"},"content":{"rendered":"\n
\"\"\/<\/figure>\n\n\n\n
\"\"\/<\/figure>\n\n\n\n

MySQL is an Open Source SQL database management system structured to collect data; a tool that should be a great option for your website.
\nThis article should help you on how you can create a Database and a User through the MySQL Wizard.<\/p>\n\n\n\n

\n\n\n\n

Creating a Database and a User<\/h1>\n\n\n\n

Firstly, log in on your cPanel<\/a> on https:\/\/web.ggservers.com:2083
\nThe credentials<\/a> have been emailed<\/a> to you shortly after the purchase process.<\/p>\n\n\n\n

    \n
  1. MySQL Wizard<\/strong>

    Once logged, scroll down to ” Databases ” and click on the option for MySQL Wizard.<\/li>\n<\/ol>\n\n\n\n
    \"\"\/<\/figure>\n\n\n\n
      \n
    1. Name<\/strong>

      Give your Database a name and click to proceed.<\/li>\n<\/ol>\n\n\n\n
      \"\"\/<\/figure>\n\n\n\n
        \n
      1. Your User<\/strong>

        Right now, the Wizard is also creating a new User to be able access the Database and click to continue.<\/li>\n<\/ol>\n\n\n\n
        \"\"\/<\/figure>\n\n\n\n

        You can also use the option to generate a security password on Password Generator<\/strong>.<\/p>\n\n\n\n

          \n
        1. User Privileges<\/strong>

          The Wizard should help you now to choose what permissions you’d like your user you just created to get access to specified actions.<\/li>\n<\/ol>\n\n\n\n
          \"\"\/<\/figure>\n\n\n\n
            \n
          • You can either select the box that gives ” All Privileges<\/strong> ” or you can simply select the boxes that you’d like to be able with your User you just created.

            Both options Make Changes<\/strong> and Next Step<\/strong> should work on the same way.<\/li>\n<\/ul>\n\n\n\n

            \u2714 Click on any of them.<\/p>\n\n\n\n

            \n\n\n\n

            Done!
            \nYou just create a new Database and a User for your Website!<\/p>\n\n\n\n

            Feel free to open a ticket in your client area if you need any further help.<\/p>\n","protected":false},"excerpt":{"rendered":"

            Creating a Database and a User on cPanel using MySQL Wizard<\/p>\n","protected":false},"author":3,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"_acf_changed":false,"_sitemap_exclude":false,"_sitemap_priority":"","_sitemap_frequency":"","footnotes":""},"ht-kb-category":[35],"ht-kb-tag":[],"class_list":["post-12798","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-webhosting"],"acf":[],"_links":{"self":[{"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/12798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=12798"}],"version-history":[{"count":0,"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/12798\/revisions"}],"wp:attachment":[{"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=12798"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-category?post=12798"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-tag?post=12798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}