--- title: 'How to install and configure MySQL on Windows Server | Zomro' description: 'MySQL is a database server distributed free of charge and available for installation on almost all server operating systems.' image: 'https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629001223-2.jpg' --- ![opened image]() * [Zomro](https://zomro.com/) * [FAQ](https://zomro.com/blog/faq/) * How to install and configure MySQL on Windows Server # How to install and configure MySQL on Windows Server 29-06-2023 Before starting the installation, download the installation file. To do this, on the [MySQL Community Downloads](http://dev.mysql.com/downloads/mysql/) page, select the operating system version (Microsoft Windows) and click "Go to Download Page" ![How to install and configure MySQL on Windows Server - 1](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629001223-2.jpg) The developer offers two versions of the installer. mysql-installer-web-community is used to automatically download the installer. We are interested in the full version of the mysql-installer-community installer. Please note that only the 32-bit version is offered for download, but it works successfully on 64-bit systems ![How to install and configure MySQL on Windows Server - 2](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629001652-3.jpg) In the window that opens, you can refuse registration or authorization ![How to install and configure MySQL on Windows Server - 3](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629001917-4.jpg) After downloading the installation program, run it. In the first window, the installer prompts you to select MySQL installation options. The Full option will install all available components, and this can be useful if you need to get familiar with the possibilities of working and managing MySQL. But if MySQL needs to be used only for creating and managing databases from the DBMS command line, then it is enough to select Server Only, which we will do. ![How to install and configure MySQL on Windows Server - 4](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629004558-1.jpg) and click Execute ![How to install and configure MySQL on Windows Server - 5](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629004647-2.jpg) After finishing installation ![How to install and configure MySQL on Windows Server - 6](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629004859-3.jpg) click Next, Next again, after which the initial MySQL setup will begin In the network settings window, you can change the connection port, for example, for security reasons. But these settings, if necessary, can be done later. For now, we leave everything unchanged. ![How to install and configure MySQL on Windows Server - 7](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629005151-4.jpg) We agree with the installer's recommendations and leave the requirement of complex passwords ![How to install and configure MySQL on Windows Server - 8](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629005354-5.jpg) Create a complex MySQL server root password. This password will be used to access server management from the command line (in our case). At the same stage, you can create users, but not yet required. Users can be managed at any time after installation. ![How to install and configure MySQL on Windows Server - 9](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629005743-6.jpg) In the installation settings as a service, do not change anything and click Next (twice) ![How to install and configure MySQL on Windows Server - 10](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629010016-7.jpg) And we start applying the settings (click Execute) ![How to install and configure MySQL on Windows Server - 11](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629010209-8.jpg) After that - Finish ![How to install and configure MySQL on Windows Server - 12](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629010636-1.jpg) ![How to install and configure MySQL on Windows Server - 13](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629010747-2.jpg) The installation and initial configuration of the MySQL database server is now complete. We have installed MySQL as a Server Only service. In this option, server management is available only from the CLI (command line), without a graphical interface. Now let's check the availability of the server and find out the version of MySQL. To do this, in the Start menu - MySQL, run Command Line Client ![How to install and configure MySQL on Windows Server - 14](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629011235-3.jpg) Enter the password and start MySQL server command mode ![How to install and configure MySQL on Windows Server - 15](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/a55%40server-panel.net/2023/06/28/image-20230629011615-4.jpg) In this article, we learned how to install the MySQL database server on Windows Server 2012-2019 as a service in Server Only mode. The specified settings are enough to create a database, for example, for the site of the selected CMS. Similar articles: [Installing the Pterodactyl Control Panel (Ubuntu)](https://zomro.com/blog/faq/358-installing-the-pterodactyl-control-panel-ubuntu) [Configuring Firewall with IPTables Ubuntu 20.04](https://zomro.com/blog/faq/361-configuring-firewall-with-iptables-ubuntu-2004) [Backups with site transfer on VestaCP/HestiaCP servers via mount](https://zomro.com/blog/faq/385-backups-with-site-transfer-on-vestacphestiacp-servers-via-mount) [How to install updates on Windows Server 2012, Windows Server 2016, and Windows Server 2019](https://zomro.com/blog/faq/242-kak-ustanovit-obnovlenija-na-windows-server-2012-2016-2019) [Why you need to disable UDP for RDP connections to Windows Server](https://zomro.com/blog/faq/427-otklyuchenie-udp-dlya-rdp-podklyuchenij-k-windows-server) [ Dedicated servers from €88.80/mon ](/dedicated-servers)