{"id":12889,"date":"2022-10-06T09:52:56","date_gmt":"2022-10-06T09:52:56","guid":{"rendered":"https:\/\/test2.gginternal.net\/knowledgebase\/article\/what-is-a-mysql-database-and-what-is-it-used-for\/"},"modified":"2022-10-06T09:52:56","modified_gmt":"2022-10-06T09:52:56","slug":"what-is-a-mysql-database-and-what-is-it-used-for","status":"publish","type":"ht_kb","link":"https:\/\/ggservers.com\/knowledgebase\/article\/what-is-a-mysql-database-and-what-is-it-used-for\/","title":{"rendered":"What Is a MySQL Database and What Is It Used For?"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/ggservers.com\/knowledgebase\/wp-content\/uploads\/2024\/03\/banner10_1mgbruh.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>This guide will help you understand what a MySQL database is and what it is used for.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u2753 What Is a MySQL Database and what is it used for \u2753<\/h1>\n\n\n\n<p>MySQL is one of the most popular database systems, widely used in applications, websites, and Minecraft plugins and mods.<\/p>\n\n\n\n<p>You can use a MySQL database with multiple plugins or mods to store information regarding your server (like the inventory or ranks of players) as long as the plugin permits it.<\/p>\n\n\n\n<p>Some examples of plugins that work with a MySQL database are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/ggservers.com\/knowledgebase\/article\/how-to-set-up-and-use-luckperms\/\">LuckPerms<\/a><\/li>\n\n\n\n<li>CoreProtect<\/li>\n\n\n\n<li><a href=\"https:\/\/www.spigotmc.org\/resources\/advancedban.8695\/\">AdvancedBan<\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>The advantages of MySQL over other storing alternatives (like storing in text) are that the MySQL database is faster, more efficient, and has a lower chance of data loss.<\/p>\n\n\n\n<p>Also, using a MySQL database comes in handy when you are running a BungeeCord server, because you can use one database for all of your servers.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\"><a href=\"https:\/\/ggservers.com\/knowledgebase\/article\/how-to-set-up-and-configure-bungeecord\/\">Here<\/a> is our guide explaining BungeeCord.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">  How to Get a MySQL Database  <\/h1>\n\n\n\n<p>To be able to use a MySQL database, you must verify if your plan includes one. The MySQL database can be added either in the order process or later if you change your mind and decide it is needed.<\/p>\n\n\n\n<p>To get a the database for an existing server, just open a ticket under your billing account requesting it, and our team will take the necessary actions.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\"><a href=\"https:\/\/ggservers.com\/knowledgebase\/article\/how-to-open-a-support-ticket\/\">Here<\/a> is our guide for opening a ticket.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>The price for the MySQL database is $2 per month.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">Also, the database came free for premium services or standard ones with billing cycles longer than 3 months (quarterly).<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\"> \ufe0f How to Create a MySQL Database  \ufe0f<\/h1>\n\n\n\n<p>If you already have a MySQL database included on your server plan, all you have to do is create it.<\/p>\n\n\n\n<p>You can do so by following the next steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Log in to your Multicraft panel <a href=\"https:\/\/mc.ggservers.com\/site\/login\">here<\/a>.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Click on <code>Advanced<\/code>, then on <code>MySQL Database<\/code>, then on <code>Create Database<\/code>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/ggservers.com\/knowledgebase\/wp-content\/uploads\/2024\/03\/5_14z6ewn.png\" alt=\"MySQL Database\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/ggservers.com\/knowledgebase\/wp-content\/uploads\/2024\/03\/4_1vgathy.png\" alt=\"Create Database\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Now you&#8217;ve created the database. Now you can note the connection information to be able to use them for any plugin or mod you want. (<code>Host<\/code>, <code>Name<\/code>, <code>Username<\/code>, and <code>Password<\/code>).<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/ggservers.com\/knowledgebase\/wp-content\/uploads\/2024\/03\/3_ayju1w.png\" alt=\"Connection Info\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u274c How to Delete a MySQL Database \u274c<\/h1>\n\n\n\n<p>You are able to delete the existing MySQL database assigned to your server at any time.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">\u26a0 NOTE \u26a0: Deleting a database will also remove all information present on it (such as plugin data) without the option to get it back.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>If you ever want to remove your existing MySQL database, you can do so by following the next steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Log in to your Multicraft panel <a href=\"https:\/\/mc.ggservers.com\/site\/login\">here<\/a>.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>Click on <code>Advanced<\/code>, then on <code>MySQL Database<\/code>, then on <code>Delete Database<\/code>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/ggservers.com\/knowledgebase\/wp-content\/uploads\/2024\/03\/5_14z6ewn.png\" alt=\"MySQL Database\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/ggservers.com\/knowledgebase\/wp-content\/uploads\/2024\/03\/1_n4z9wm.png\" alt=\"Delete Database\"\/><\/figure>\n\n\n\n<p>Now you&#8217;ve just removed your existing database.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-success\">If you have any issues or questions regarding the MySQL database, please contact us on live chat or via the <a href=\"https:\/\/ggservers.com\/knowledgebase\/article\/how-to-open-a-support-ticket\/\">ticket system<\/a>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">\u2755Useful Links\u2755<\/h1>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/ggservers.com\/knowledgebase\/article\/how-to-upgrade-or-downgrade-your-service\/\">How to Upgrade or Downgrade Your Service<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ggservers.com\/knowledgebase\/article\/addons-general-information-and-how-to-order-one\/\">Addons &#8211; General Information and How to Order One<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ggservers.com\/knowledgebase\/article\/premium-support-addon\/\">Premium Support Addon<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This guide will help you understand what is a MySQL database and what it is used for.<\/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":[27],"ht-kb-tag":[],"class_list":["post-12889","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-minecraft"],"acf":[],"_links":{"self":[{"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/12889","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=12889"}],"version-history":[{"count":0,"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/12889\/revisions"}],"wp:attachment":[{"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=12889"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-category?post=12889"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/ggservers.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-tag?post=12889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}