{"id":4927,"date":"2020-03-25T17:57:05","date_gmt":"2020-03-25T21:57:05","guid":{"rendered":"https:\/\/www.globo.tech\/learning-center\/?p=4927"},"modified":"2020-03-25T17:57:06","modified_gmt":"2020-03-25T21:57:06","slug":"how-to-install-and-upgrade-mysql-in-windows-server-2016","status":"publish","type":"post","link":"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/","title":{"rendered":"How to Install and Upgrade MySQL in Windows Server 2016"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"628\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/how-to-install-update-mysql-windows-server.jpg\" alt=\"How to install and upgrade MySQL on Windows Server 2016\" class=\"wp-image-4928\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to Install MySQL in Windows Server 2016<\/h2>\n\n\n\n<p>If you are using the Windows server to host your website, you may use the MsSQL database server as a database backend. But, MsSQL is Microsoft&#8217;s commercial product and you will need to purchase license to use MsSQL will all features. So it is very difficult for small businesses to pay license costs.<\/p>\n\n\n\n<p>To resolve this, you could try open-source database servers like, MySQL database server and use it as a database backend to save a license cost. You should install MySQL in your Windows Server 2016.<\/p>\n\n\n\n<p>MySQL is a part of the Linux-based server and specially designed for LAMP\/LEMP stack. It is also available for the Windows operating system. So you should use MySQL to manage and host your application.<\/p>\n\n\n\n<p>In this tutorial, we will show you how to install and upgrade MySQL server on Windows Server 2016.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Prerequisites<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>A <a href=\"https:\/\/www.globo.tech\/dedicated-server-hosting\">server<\/a> running Windows Server 2016.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Download MySQL Installer<\/h2>\n\n\n\n<p>MySQL Server is available for Microsoft Windows 64-bit operating systems only. Before installing MySQL Server, it is recommended to see <a href=\"https:\/\/www.mysql.com\/support\/supportedplatforms\/database.html\">https:\/\/www.mysql.com\/support\/supportedplatforms\/database.html<\/a> for supported Windows platform.<\/p>\n\n\n\n<p>The simple and easiest way to install MySQL server in Windows Server 2016 <a href=\"https:\/\/www.globo.tech\/cloud-server-pricing\">system <\/a>is to install it using MySQL installer. MySQL installer provides a simple and user-friendly wizard to install MySQL on Windows.<\/p>\n\n\n\n<p>At the time of writing this article, the latest available version of MySQL is MySQL 8.0.19.<\/p>\n\n\n\n<p>You can download the latest version of MySQL installer from the <a href=\"https:\/\/dev.mysql.com\/downloads\/installer\/\">MySQL Community Download page<\/a> as shown below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"732\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Download.png\" alt=\"MySQL Download on official website.\" class=\"wp-image-4929\"\/><\/figure>\n\n\n\n<p>As you can see, there is two option available for download:<\/p>\n\n\n\n<p><strong>1-<\/strong> If you are connected to the internet, you can choose the online installation version mysql-installer-web-community-8.0.19.0.msi.<\/p>\n\n\n\n<p><strong>2-<\/strong> If you are not connected to the internet and want to install MySQL offline, you can choose the offline installation version mysql-installer-community-8.0.19.0.msi.<\/p>\n\n\n\n<p>Click on the <strong>Download<\/strong> button to download the MySQL MSI installer.<\/p>\n\n\n\n<p>You can install the following components using the MySQL installer:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL Server<\/li><li>MySQL Workbench<\/li><li>MySQL Notifier<\/li><li>MySQL Shell<\/li><li>MySQL Router<\/li><li>ODBC Connector<\/li><li>C++ Connector<\/li><li>J Connector<\/li><li>Net Connector<\/li><li>MySQL Documentation<\/li><li>Samples and Examples<\/li><\/ul>\n\n\n\n<p>Once you are done, you can proceed to the next step.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Install MySQL Server<\/h2>\n\n\n\n<p>You can follow the below steps to install the MySQL server on Windows server 2016:<\/p>\n\n\n\n<p><strong>Step 1 &#8211;<\/strong> Double click on the downloaded <strong>mysql-installer-web-community-8.0.19.0.msi<\/strong> file. You should see the MySQL Installer wizard in the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-1.png\" alt=\"MySQL Installer -Choosing a Setup Type.\" class=\"wp-image-4930\" width=\"590\" height=\"446\"\/><\/figure>\n\n\n\n<p>Developer Default option will install the selected version of MySQL Server with other MySQL tools required for MySQL development.<\/p>\n\n\n\n<p><strong>Step 2 &#8211;<\/strong> Choose your desired setup type and click on the <strong>Next<\/strong> button. You should see the list of all dependencies required to install MySQL server:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-2.png\" alt=\"MySQL Installer -Check Requirements.\" class=\"wp-image-4931\" width=\"590\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 3 &#8211;<\/strong> Click on the <strong>Execute<\/strong> button to install all dependencies. Once all the dependencies are installed, you should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-3.png\" alt=\"MySQL Installer -Check Requirements - Selection.\" class=\"wp-image-4932\" width=\"590\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 4 &#8211;<\/strong> Click on the <strong>Next<\/strong> button to start the installation. You will be asked to install the MySQL server with some missing dependencies:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-4.png\" alt=\"MySQL Installer -Check Requirements - Pop-up.\" class=\"wp-image-4933\" width=\"590\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 5 &#8211;<\/strong> Click on the <strong>Yes<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-5.png\" alt=\"MySQL Installer - Installation - Ready to download.\" class=\"wp-image-4934\" width=\"590\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 6 &#8211;<\/strong> Click on the <strong>Execute<\/strong> button to download and install the MySQL server with all required dependencies. Once the installation has been completed, you should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-6.png\" alt=\"MySQL Installer - Installation - Complete.\" class=\"wp-image-4935\" width=\"590\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 7 &#8211;<\/strong> Click on the <strong>Next<\/strong> button. You should see the product configuration page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-7.png\" alt=\"MySQL Installer - Product Configuration - Ready to configure.\" class=\"wp-image-4936\" width=\"590\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 8 &#8211;<\/strong> Click on the <strong>Next<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-8.png\" alt=\"MySQL Installer - High Availability.\" class=\"wp-image-4937\" width=\"590\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 9 &#8211;<\/strong> Select the <strong>Standalone MySQL server<\/strong> and click on the <strong>Next<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-9.png\" alt=\"MySQL Installer - Type and Networking.\" class=\"wp-image-4938\" width=\"590\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 10 &#8211;<\/strong> Choose the server configuration type and click on the <strong>Next<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-10.png\" alt=\"MySQL Installer - Authentication Method.\" class=\"wp-image-4939\" width=\"590\" height=\"447\"\/><\/figure>\n\n\n\n<p><strong>Step 11 &#8211;<\/strong> Select the authentication method and click on the <strong>Next<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-11.png\" alt=\"MySQL Installer - Accounts and Roles.\" class=\"wp-image-4940\" width=\"590\" height=\"447\"\/><\/figure>\n\n\n\n<p><strong>Step 12 &#8211;<\/strong> Set your root password and click on the <strong>Next<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-12.png\" alt=\"MySQL Installer - Windows Service.\" class=\"wp-image-4941\" width=\"592\" height=\"449\"\/><\/figure>\n\n\n\n<p><strong>Step 13 &#8211;<\/strong> Configure MySQL service and click on the <strong>Next<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-13.png\" alt=\"MySQL Installer - MySQL Router Configuration.\" class=\"wp-image-4942\" width=\"592\" height=\"449\"\/><\/figure>\n\n\n\n<p><strong>Step 14 &#8211;<\/strong> Click on the <strong>Execute<\/strong> button to apply the changes. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-14.png\" alt=\"MySQL Installer - Apply Configuration confirmation.\" class=\"wp-image-4943\" width=\"594\" height=\"449\"\/><\/figure>\n\n\n\n<p><strong>Step 15 &#8211;<\/strong> Click on the <strong>Finish<\/strong> button to complete the MySQL server configuration. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-15.png\" alt=\"MySQL Installer - Product Configuration - Ready to configure.\" class=\"wp-image-4944\" width=\"592\" height=\"445\"\/><\/figure>\n\n\n\n<p><strong>Step 16 &#8211;<\/strong> Click on the <strong>Next<\/strong> button to configure MySQL Router. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-16.png\" alt=\"MySQL Installer - MySQL Router Configuration.\" class=\"wp-image-4945\" width=\"592\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 17 &#8211;<\/strong> Click on the <strong>Finish<\/strong> button to complete the Router configuration. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-17.png\" alt=\"MySQL Installer - Product Configuration.\" class=\"wp-image-4947\" width=\"592\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 18 &#8211;<\/strong> Click on the <strong>Next<\/strong> button to configure Samples and Examples. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-18.png\" alt=\"MySQL Installer - Connect To Server.\" class=\"wp-image-4948\" width=\"592\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 19 &#8211; <\/strong>Select the MySQL server to receive sample schemas and data, click on the <strong>Check<\/strong> button and click on the <strong>Next<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-19.png\" alt=\"MySQL Installer - Apply Configuration.\" class=\"wp-image-4949\" width=\"592\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 20 &#8211;<\/strong> Click on the <strong>Execute<\/strong> button to apply the changes. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-20.png\" alt=\"MySQL Installer - Apply Configuration confirmation.\" class=\"wp-image-4950\" width=\"592\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 21 &#8211;<\/strong> Click on the <strong>Finish<\/strong> button to complete the configuration. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-21.png\" alt=\"MySQL Installer - Product Configuration.\" class=\"wp-image-4951\" width=\"592\" height=\"446\"\/><\/figure>\n\n\n\n<p><strong>Step 22 &#8211;<\/strong> Click on the <strong>Next<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"789\" height=\"595\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-22.png\" alt=\"MySQL Installer - Installation Complete.\" class=\"wp-image-4952\"\/><\/figure>\n\n\n\n<p><strong>Step 23 &#8211;<\/strong> Click on the <strong>Finish<\/strong> button to complete the installation and launch MySQL Workbench and MySQL Console. You should see the following page:<\/p>\n\n\n\n<p>MySQL Workbench:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1366\" height=\"768\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Workbench.png\" alt=\"MySQL Wordbench - Welcome.\" class=\"wp-image-4953\"\/><\/figure>\n\n\n\n<p>MySQL Console:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Console.png\" alt=\"MySQL Console.\" class=\"wp-image-4954\" width=\"1025\" height=\"576\"\/><\/figure>\n\n\n\n<p>Once you are done, you can proceed to the next step.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Upgrade MySQL Server<\/h2>\n\n\n\n<p>If you have MySQL Server already installed on your Windows server and want to upgrade it to the latest version, follow the below steps:<\/p>\n\n\n\n<p><strong>Step 1 &#8211;<\/strong> Download the latest version of MySQL installer from the MySQL Community Download page.<\/p>\n\n\n\n<p><strong>Step 2 &#8211;<\/strong> Double click on the downloaded mysql-installer-web-community-8.0.19.0.msi file. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-Upgrade.png\" alt=\"MySQL Installer - First step to upgrade.\" class=\"wp-image-4955\" width=\"590\" height=\"447\"\/><\/figure>\n\n\n\n<p><strong>Step 3 &#8211;<\/strong> Click on the <strong>Next<\/strong> button. You should see the installed version and available upgrade version of MySQL server with other products are shown in the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-Upgrade-2.png\" alt=\"MySQL Installer - Select products to Upgrade.\" class=\"wp-image-4957\" width=\"590\" height=\"447\"\/><\/figure>\n\n\n\n<p>As you can see, MySQL server 8.0.17 is already installed and you will need to upgrade this to version 8.0.19.<\/p>\n\n\n\n<p><strong>Step 4 &#8211;<\/strong> Click on the <strong>Next<\/strong> button. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-Upgrade-3.png\" alt=\"MySQL Installer - Apply updates.\" class=\"wp-image-4958\" width=\"590\" height=\"447\"\/><\/figure>\n\n\n\n<p><strong>Step 5 &#8211;<\/strong> Click on the <strong>Execute<\/strong> button to download and upgrade the MySQL server.Once MySQL server with all products is upgraded, you should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/MySQL-Installer-Upgrade-4.png\" alt=\"MySQL Installer - Apply updates confirmation.\" class=\"wp-image-4959\" width=\"590\" height=\"447\"\/><\/figure>\n\n\n\n<p><strong>Step 6 &#8211;<\/strong> Next, click on the <strong>Next<\/strong> button and complete the remaining process to configure the MySQL server.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>In the above guide, we learned how to install and upgrade the MySQL server on Windows server 2016. I hope you can now easily install MySQL server on any fresh Windows server.<\/p>\n\n\n\n<p>For\nmore information about MySQL for Windows, visit the MySQL Windows\ndocumentation at <a href=\"https:\/\/www.mysql.com\/why-mysql\/windows\/\">https:\/\/www.mysql.com\/why-mysql\/windows\/<\/a>.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>MySQL server for Windows is an open source database engine compatible with Windows. Learn in this article how to install MySQL in Windows Server 2016<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":3,"featured_media":4928,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61],"tags":[],"class_list":["post-4927","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Install and Upgrade MySQL in Windows Server 2016 - Globo.Tech<\/title>\n<meta name=\"description\" content=\"MySQL server for Windows is an open source database engine compatible with Windows Server. Learn in this article how to install MySQL in Windows Server 2016\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Install and Upgrade MySQL in Windows Server 2016 - Globo.Tech\" \/>\n<meta property=\"og:description\" content=\"MySQL server for Windows is an open source database engine compatible with Windows Server. Learn in this article how to install MySQL in Windows Server 2016\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/\" \/>\n<meta property=\"og:site_name\" content=\"Globo.Tech\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-25T21:57:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-25T21:57:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/how-to-install-update-mysql-windows-server.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"GloboTech Communications\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"GloboTech Communications\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/\",\"name\":\"How to Install and Upgrade MySQL in Windows Server 2016 - Globo.Tech\",\"isPartOf\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/how-to-install-update-mysql-windows-server.jpg\",\"datePublished\":\"2020-03-25T21:57:05+00:00\",\"dateModified\":\"2020-03-25T21:57:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87\"},\"description\":\"MySQL server for Windows is an open source database engine compatible with Windows Server. Learn in this article how to install MySQL in Windows Server 2016\",\"breadcrumb\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/#primaryimage\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/how-to-install-update-mysql-windows-server.jpg\",\"contentUrl\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/how-to-install-update-mysql-windows-server.jpg\",\"width\":1200,\"height\":628,\"caption\":\"How to install and upgrade MySQL on Windows Server 2016\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.globo.tech\/learning-center\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install and Upgrade MySQL in Windows Server 2016\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#website\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/\",\"name\":\"Globo.Tech\",\"description\":\"Welcome to the Official Globo.Tech Learning Center\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87\",\"name\":\"GloboTech Communications\",\"sameAs\":[\"http:\/\/www.gtcomm.net\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install and Upgrade MySQL in Windows Server 2016 - Globo.Tech","description":"MySQL server for Windows is an open source database engine compatible with Windows Server. Learn in this article how to install MySQL in Windows Server 2016","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:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/","og_locale":"en_US","og_type":"article","og_title":"How to Install and Upgrade MySQL in Windows Server 2016 - Globo.Tech","og_description":"MySQL server for Windows is an open source database engine compatible with Windows Server. Learn in this article how to install MySQL in Windows Server 2016","og_url":"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/","og_site_name":"Globo.Tech","article_published_time":"2020-03-25T21:57:05+00:00","article_modified_time":"2020-03-25T21:57:06+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/how-to-install-update-mysql-windows-server.jpg","type":"image\/jpeg"}],"author":"GloboTech Communications","twitter_misc":{"Written by":"GloboTech Communications","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/","url":"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/","name":"How to Install and Upgrade MySQL in Windows Server 2016 - Globo.Tech","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/how-to-install-update-mysql-windows-server.jpg","datePublished":"2020-03-25T21:57:05+00:00","dateModified":"2020-03-25T21:57:06+00:00","author":{"@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"description":"MySQL server for Windows is an open source database engine compatible with Windows Server. Learn in this article how to install MySQL in Windows Server 2016","breadcrumb":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/#primaryimage","url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/how-to-install-update-mysql-windows-server.jpg","contentUrl":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/how-to-install-update-mysql-windows-server.jpg","width":1200,"height":628,"caption":"How to install and upgrade MySQL on Windows Server 2016"},{"@type":"BreadcrumbList","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-install-and-upgrade-mysql-in-windows-server-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.globo.tech\/learning-center\/"},{"@type":"ListItem","position":2,"name":"How to Install and Upgrade MySQL in Windows Server 2016"}]},{"@type":"WebSite","@id":"https:\/\/www.globo.tech\/learning-center\/#website","url":"https:\/\/www.globo.tech\/learning-center\/","name":"Globo.Tech","description":"Welcome to the Official Globo.Tech Learning Center","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87","name":"GloboTech Communications","sameAs":["http:\/\/www.gtcomm.net"]}]}},"_links":{"self":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/4927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/comments?post=4927"}],"version-history":[{"count":6,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/4927\/revisions"}],"predecessor-version":[{"id":4965,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/4927\/revisions\/4965"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media\/4928"}],"wp:attachment":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media?parent=4927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/categories?post=4927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/tags?post=4927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}