How To Use Mysql Server On Windows

How to Install MySQL on Windows

If yous're using a Windows-based server to host your content, you may be using Microsoft'south database server product, Microsoft SQL Server (MSSQL). However, licensing restrictions can make using MSSQL difficult, particularly for pocket-size businesses. Microsoft offers a gratuitous version of MSSQL called MSSQL Express that volition be suitable for many users, but this version does have limitations on database size and memory usage. If you need a more robust database solution but want to effort something with a lower toll (like a free, open-source database server), you could try running MySQL database server on Windows.

MySQL is a standard part of the typical Linux server build (or LAMP stack) but is also available for use on Windows operating systems. Depending on your needs, you could fully develop your database in MySQL. Many popular Content Management Systems (CMS) also use MySQL past default, so using MySQL to manage those applications may exist beneficial. MySQL and MSSQL tin exist run on the same server simultaneously, and so you lot're free to use both or to experiment as needed. We volition look at how to set up MySQL server on Windows.

Installation

MySQL server installation on your Windows server is as uncomplicated equally downloading an MSI Installer package and clicking through a few options.

Download the MySQL Installer from dev.mysql.com. The two download options are a web-community version and a full version. The web-community version will but download the server, by default, but you can select other applications (like Workbench) as desired. The full installer will download the server and all the recommended additional applications. (Yous'll also be asked to create a user business relationship, merely y'all skip this part by scrolling down to the bottom and clicking "No thanks, just beginning my download".)
Run the installer that you downloaded from its location on your server, by and large by double-clicking.

Note

You can use this aforementioned MSI Installer to upgrade currently installed versions of MySQL as well! As is typical, the first step is accepting the license agreement, then click Next.

three. Next, determine which MySQL server installation blazon y'all would similar to employ:

Developer Default: this is the full installation of MySQL Server and the other tools needed for development. If you are edifice your database from the ground up or will exist managing the information directly in the database, you'll want to use this setup type.

Server Only: if you simply need MySQL Server installed for use with a CMS or other application and volition not be managing the database directly, you tin install just the server (you can always install boosted tools later).

Custom: this setup type volition allow you to customize every part of the installation from the server version to whichever additional tools you select.

setup type

four. Install the server example and whichever additional products you selected. Then begin the configuration process by selecting the availability level (most users will use the default, standalone version).

5. Complete the configuration process by post-obit the on-screen instructions. You'll want to make sure to install MySQL as a Service so that Windows can automatically start the service later a reboot or can restart the service if it fails. For additional, step-by-pace instructions, see MySQL Server Configuration with MySQL Installer.

Have other thoughts or questions? Our Sales and Support teams are available 24 hours by phone or e-mail to assist. Achieve out to usa by opening a back up ticket at back up@liquidweb.com, giving us a telephone call at 1-800-580-4985 or, open a chat with us and we'll be happy to answer any questions you may have!