Win7 installing the MySQL method

Recently in the Win7 system installed the MySQL client database, now finishing steps for everyone to learn to communicate!

First, download MySQL Install package

Installation package Name: Mysql-5.6.12-win32.zip

: http://dev.mysql.com/downloads/mysql/

(NET disk sharing: Https://yunpan.cn/ckRxP5HBQ58ak access password d8e0)

Second, installation MySQL

2.1 Modifying a configuration file My.ini (Put this file in the installed directory)

Copy the Mysql-5.6.12-win32.zip extract to the D:\

Modify the configuration file under the D:\mysql-5.6.12-win32.zip directory My.ini as follows:

# for advice The Change settings see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# * * * Don't EDIT this FILE. It's a template which 'll be copied to the# ***defaultLocation during install, and would be replacedifyou#***upgrade to a newer version of MySQL. [Client]default-character-Set=Utf8[mysql]default-character-Set=Utf8[mysqld]character-Set-server=utf8# Remove Leading # andSetTo the amount of RAM forThe most important data# cacheinchMysql. Start at -% of Total RAM forDedicated server,Else Ten%. # innodb_buffer_pool_size=128m# Remove Leading # to turn on a very important data integrity option:logging# changes to the binary log between backups.# log_bin# These is commonlySet, remove the # andSet  asrequired. Basedir= d:/mysql-5.6. --winx64 DataDir= d:/mysql-5.6. --winx64/data# Port=.... # server_id=... # Remove leading # toSetOptions mainly useful forreporting servers.# The server defaults is faster fortransactions and fast selects.# Adjust sizes asneeded, experiment to find the optimal values.# join_buffer_size=128m# sort_buffer_size=2m# read_rnd_buffer_size=2M Sql_mode=no_engine_substitution,strict_trans_tables

2.2 installation MySQL

Start cmd as administrator, switch to directory D:/mysql-5.6.12-win32/bin

After installing Mysql:mysqld.exe--install (cmd, if the report is rejected, you need to run CMD with administrator privileges and then execute the command)

Third, start MySQL Service

3.1 Start MySQL Service

Start cmd as administrator, switch to directory D:/mysql-5.6.12-win32/bin

Start MySQL service: net start MySQL

(If you want to run instructions directly in the cmd command without going into the bin directory, you need to add the path to the environment variable,

）

PS: The system default mysql is self-booting, modified to manually start the method:

Go to the "service" of this machine and modify it to start manually.

Iv. Execution of Orders

4.1 Login MySQL

Mysql-u root-p

Enter the password (the password is empty, directly enter), you can log in.

Change the root password to 123456:

mysql> use mysql;database changedmysql> UPDATE user SET password=password ("123456") WHERE user= ' root ';

4.2 Execution MySQL Command

Five, uninstall MySQL

4.1 Stop MySQL Service

net stop MySQL

4.2 Uninstall MySQL

Mysqld.exe--remove

Install the MySQL method under Win7