|Running the MySQL Configuration Wizard|
Gaining in popularity, MySQL Database Server now runs on a wide range of platforms. In this lesson we will focus on Linux, Unix, Windows, and Mac, which combined together account for the majority of installations.
MySQL is installed best from precompiled, ready-to-install binaries - packages. Binaries are available for most operating systems: Linux, Windows, Mac, FreeBSD and other flavors of Unix, and many more.
Operating System Selection
Programs such as Apache and MySQL are natively designed and better optimized for the programming model of Unix/Linux than for Windows, and this provides a significant performance advantage in favor of installing MySQL on Unix/Linux.
Generally, developers mostly prefer machines using MS-Windows OS variants. Nevertheless, if the production deployment is on a Unix/Linux server, it may be better to choose a Unix/Linux platform during the development phase itself. This will help developers acquire useful experience in scripting, access rights and security that will be valuable in later phases of deployment, administration and maintenance.
Certain system functions on Unix/Linux make programming more attractive than Windows. For example, unlike Windows, Unix/Linux provides out-of-the-box interfaces for such tasks as remote copying or sending an e-mail via scripts. Several packages, such as Cygwin and MKS, are available on Windows and offer a Unix-like environments, commands and shells to build reusable scripts for Unix.
Downloading and Installing MySQL On Windows
To download and install MySQL on Windows, please follow these steps:
- Go to the Downloads page on MySQL website.
- On the next screen, download your desired installer executable from the MySQL Community Server and save it to a folder on your system.
- Open the downloaded zip file, and execute the installer (.msi) file. Proceed with the extraction. If you're installing from a Windows system, be sure that you're logged into an account with administrative privileges. Select a folder to extract the zip folder.
- The extraction process completes.
- Extraction will show you the setup file in the folder where you saved it.
- Once the opening screen appears, click Next to see a screen for choosing the type of installation.
- Choose Typical installation then click Next. This will install all the required components for working in My SQL. The Ready to Install Program window opens. The current settings are displayed.
- Set up is now ready to begin installing the selected components. Click Install. The installation of My SQL begins. When the installation is complete, a Sign-Up dialog box opens.
- Click Skip Signup and then click Next. The Wizard Completes. MySQL is now installed on your machine.