Home

MySQL Installation

 

Setting Up MySQL

 

Installing MySQL

MySQL is an environment used to create and manage computer databases for different types of operating systems and platforms. To follow the lessons on this site, you must first install it. You can freely download it from the MySQL web site.

To download MySQL, from its web site, locate and click the Downloads link. Then locate your platform. You will be taken to a page with many options. Unless you clearly know what installation you want, you should select Windows MSI Installer (AMD64 / Intel EM64T) and click Pick a Mirror.

Choose a mirror (server) close to your location. When the dialog box comes up, click Run:

The downloading would start and may last a few minutes. Then a dialog box may notify you about security:

If so, click Run. The installation will start:

Setup

After reading the message, click Next:

Setup

Select the type of installation approach you want. For these lessons, the Typical option should be fine. Click Next:

After reading the dialog box, click Install. After a few seconds or minutes, click Next

Click Next again

Setup

Click Next

Click Finish.

 

Configuring MySQL

After installing MySQL, you will be asked to configure MySQL:

Click Next. You will be asked about the type of configuration you want:

Click Next:

If you want to install MySQL as an actual server, click the second radio button:

Click Next:

Click Next:

Configuration

Click Next:

Configuration

Click Next:

Configuration

Note the selected value of the Port Number. Click Next

Click Next. Click the option include the Bin Directory in the Windows path:

Configuration

Click Next. Type a password for the root. Make sure you can remember that password because you will need it later:

Click Next

Configuration

Click Execute. If you receive an error, open the Control Panel and double-click Firewall. Then click Change Settings. Click the Exceptions tab:

Windows Firewall

Click Add Port. Type a name in the top text box. In the Port number text box, enter the number that was previously selected:

Add a Port

Click OK.

Practical LearningPractical Learning: 

 

 

 
 
 
 
 
   
 

Home Copyright © 2009-2016, FunctionX, Inc. Next