2 MySQL Installation

Directory:

1. mysql Installation brief
2. Download Appserv
3. Installing Appserv
4. Connect MySQL using phpMyAdmin
5. Connect MySQL with MySQL Command line Client

1. mysql Installation brief

A simple look at the installation tutorial for MySQL under Win7, the installation of a separate configuration is more cumbersome. The tedious process of installing the configuration is not the focus of learning MySQL, but it is part of the most cost-intensive beginner's learning interest. The above mentioned lamp development model, this guidance will use APPSERV for the rapid installation. It is hoped that the reader will have a basic understanding of the basics of MySQL and then install and configure it separately.

Appserv is a PHP Web station tool combination package, the author will be some network of free station resources repackaged into a single installation program to facilitate beginners to quickly complete the station, Appserv contains software: Apache, Apache Monitor, PHP, MySQL, phpMyAdmin and so on. Using this software allows you to quickly build a complete bottom-level environment.

2. Download Appserv

2.1 Views Link: http://www.appservnetwork.com/index.php

2.2 Click on the link in the Open Web page

　　

3. Installing Appserv

3.1 Double-click the downloaded appserv-win32-2.5.10, select the installation directory

　　

3.2 Default All-selected installation package

　　

3.3 Fill out Apache Server (server name can now be filled in, HTTP port port number default 80 do not change)

　　

3.4 Fill in the password of the root user in MySQL. (This password is very important, always remember)

　　
3.5 Click Install for installation.

　　

3.6 Installation Complete, open Apache and MySQL. Click End.

　　

3.7 Enter localhost in the browser, if the interface appears, the installation is successful.

　　

4. Connect MySQL using phpMyAdmin

4.1 In Liu Browser input localhost/phpmyadmin/, appear the following interface, fill in the root account and password, enter the phpMyAdmin

　　

4.2 View MySQL storage engine. Click the SQL Small button in the left column, for example, enter show engines in the pop-up box; (Don't forget to knock the semicolon). Then click the Execute button to view the MySQL storage engine described above.

　　　　

5. Connect MySQL with MySQL Command line Client

5.1 Enter MySQL in the Start menu and click MySQL Command line Client. Such as.

　　

5.2 Enter the root account password.

　　

5.3 Connection succeeded.

　　

5.4 Enter show engines on the command line; You can also see the MySQL storage engine.

　　　

2 MySQL installation