20140220-mysql installation (use Zip to unzip the green installation method)

20140220-mysql the installation (using Zip Unzip the green installation method)

Google input MySQL can directly find the official website. Download the green version.

Select: MySQL Community Server .

If you have already installed the MySQL You can do this first:

( 1 ) Stop MySQL of services: net stop MySQL (no semicolon required)

( 2 ) Removal MySQL of services: mysqld Remove (no semicolon required)

Installation steps

1 , unzip the package, and copy it to the specified location;

2 , add environment variables;

Add the following directory to the environment variable Path Medium: F:\app\mysql-5.6.16-winx64\bin (This step is important);

3 , modify the configuration file;

( 1 mysql One of the my-xx.ini Rename to my.ini ; Span style= "Font-family:times New Roman;" >

( 2 ) Open My.ini , in the file of the [Mysqld] Two additional configuration information is added below.

basedir= Pointing MySQL the directory, DataDir Pointing MySQL the database storage directory.

or write like this.

4 , installing from a command prompt MySQL

( 1 ) Enter bin folder (although you have configured the Path , but it is still recommended to enter during installation MySQL of the bin directory)

Execute command: mysqld Install

Expansion: Input mysqld Remove You can complete the uninstallation.

( 2 ) in the services of the Control Panel, management tools F5 refresh and you can see MySQL the service.

( 3 ) Execute the command net start MySQL Complete the startup service.

Note: If you can't start here, Please be sure to open the bin cmd path, even if you have Span style= "Font-family:times New Roman;" >mysql bin Span style= "font-family: blackbody;" > If the directory is set to an environment variable. That is, cmd go to mysql unzip version of bin

Otherwise, the error message "The specified file cannot be found" is reported.

5 , enter MySQL ;

Use mysql-u root-p Enter the password after the carriage return to enter MySQL , using Show Databases can query MySQL all databases in the.

The new user does not have a password and can enter directly .

6 , view database

show databases;

Note: Write a semicolon here.