MySQL environment to build a detailed tutorial.

Download

1.:

http://www.mysql.com/downloads/

2. Download the graphic

Download the community version and the Community Edition has almost all of the features we want. Only the commercial version of MySQL will provide some advanced solutions.

And these advanced features, we can solve their own.

Select the operating system. There are even source code sources.

Then select the 64-bit, or 32-bit version to download.

installation Process

MySQL5.6.11 Installation Steps (Windows7 64-bit WINDOWS8 64-bit)

1. Download mysql Community Server 5.6.14   2. Unzip the MySQL archive package

Unzip the downloaded MySQL archive into a custom directory.

2. Add Environment Variables

Variable name: mysql_home

Variable value: D:\Program files\MySQL-5.6.14-winx64

This is the custom unzip directory for MySQL.

Add%mysql_home%\bin in Path again

CMD under execute MySQL, see the text as described, description environment variable configuration succeeded!

3. Registering Windows System Services

Registering MySQL as a Windows system service

The operation is as follows:

1) Create a new My.ini file and copy the My.ini file to the C:\Windows directory, the My.ini content is as follows:

[Client]
port=3306
Default-character-set=utf8

[Mysqld]
# Set the installation directory to MySQL
Basedir=d:\program files\mysql-5.6.14-winx64
# Data Directory set to MySQL
Datadir=d:\program Files\mysql-5.6.14-winx64/data
port=3306
Character_set_server=utf8
Sql_mode=no_engine_substitution,strict_trans_tables

2) from the console into the bin directory under the MySQL decompression directory.

3) Enter the Service installation command:

Mysqld.exe-install

If Install/remove of the Service denied! appear

is because Windows 7, 8 and Vista have more restrictive permissions

Go to C:\Window\System32 Find CMD.EXE right-click to select as Administrator, and then go to the corresponding directory to execute the command, everything is OK.

A successful installation will prompt the service to install successfully.

Note: The My-default.ini file is available in the root directory after MySQL decompression, if not, from somewhere else.

The Removal Service command is: mysqld remove

4. Start the MySQL service

Method One:

The Start service command is: net start MySQL

Method Two:

Open the Administration Tools service and locate the MySQL service.

Start the service by right-clicking to start or by tapping on the left-hand boot directly.

5. Change the password of the root account

The default password for the root account is empty when the installation is complete, and you can modify the password to the specified password. Example: 123456

Method One:

C:>mysql–uroot

Mysql>use MySQL;

Mysql>update user SET Password=password ("123456") WHERE user= ' root ';

Mysql>flush privileges; "Attention must not forget this sentence, otherwise the password change cannot take effect"

Mysql>quit

OK now the configuration of the service, it is successful! Then there is the DBMS management tool left.

Database Administration Tools

1. Tools Download

MySQL has a lot of management tools, such as MyAdmin, Navicat and so on.

It is recommended to use Navicat_lite.

：

Http://pan.baidu.com/s/1pJnzVIz

2. installation process

The installation process is exceptionally simple. Next step is all right.

3. Configuration

Connect to the database server first.

The connection name can be easily started! All the rest should know ~

See the dolphin icon below to show the database. Prove the installation was successful!

MySQL environment to build a detailed tutorial.