How To Install Mysql Client In Windows

How to Install MySQL on Windows

If you're using a Windows-based server to host your content, you may be using Microsoft'due south database server production, Microsoft SQL Server (MSSQL). Withal, licensing restrictions can make using MSSQL hard, especially for pocket-sized businesses. Microsoft offers a free version of MSSQL called MSSQL Limited that will be suitable for many users, but this version does have limitations on database size and retention usage. If yous demand a more robust database solution but want to try something with a lower cost (similar a costless, open up-source database server), yous could effort running MySQL database server on Windows.

MySQL is a standard part of the typical Linux server build (or LAMP stack) merely is too 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 utilise MySQL past default, so using MySQL to manage those applications may exist beneficial. MySQL and MSSQL can be run on the same server simultaneously, and then you're gratuitous to utilise both or to experiment as needed. We will look at how to set upwards MySQL server on Windows.

Installation

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

Download the MySQL Installer from dev.mysql.com. The two download options are a spider web-community version and a full version. The web-community version will merely 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. (You'll besides be asked to create a user account, simply you skip this part past scrolling down to the lesser and clicking "No thanks, just get-go my download".)
Run the installer that you downloaded from its location on your server, generally past double-clicking.

Note

You can utilize this same MSI Installer to upgrade currently installed versions of MySQL as well! Equally is typical, the starting time stride is accepting the license agreement, so click Next.

3. Next, determine which MySQL server installation type y'all would like to utilise:

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

Server Only: if you lot just need MySQL Server installed for use with a CMS or other awarding and will not be managing the database direct, you lot can install just the server (you can always install additional tools afterwards).

Custom: this setup type will allow you to customize every function of the installation from the server version to whichever boosted tools yous select.

setup type

4. Install the server case and whichever additional products you selected. And then begin the configuration process by selecting the availability level (nigh users volition utilize the default, standalone version).

v. Complete the configuration process by post-obit the on-screen instructions. Yous'll want to make sure to install MySQL as a Service so that Windows tin automatically get-go the service after a reboot or tin restart the service if information technology fails. For additional, step-by-step 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. Reach out to us past opening a back up ticket at support@liquidweb.com, giving united states of america a call at 1-800-580-4985 or, open a conversation with united states of america and nosotros'll be happy to answer any questions yous may have!