Win7 64-bit system MySQL 5.6 free-installed version configuration

1. Download the official Zip package to extract to the local directory

2. Modify the My.ini file copy Default.ini and modify

[client]port=3306default-character-set=utf8# client character type, consistent with server, recommended utf8[mysqld]port=3306character_set_server=utf8# Service-side character type, it is recommended that Utf8basedir=d:\mysql\mysql server 5.6# the directory datadir=c:\mysql\mysql server 5.6\data# solution directory \ Datadefault-storage-engine=innodbsql_mode=no_engine_substitution,strict_trans_tables[winmysqladmin]d:\mysql\ MySQL Server 5.6\bin\mysqld.exe #解压根目录 \bin\mysqld.exe

2. Install MySQL service change password

CMD command to the bin directory to execute

A:) mysqld--nistall to register the MySQL service.

B:) net start MySQL

C:) Remove MySQL

D:) c:>mysql-uroot

mysql> UPDATE user SET Password=password ("111111") WHERE user= ' root ';
　 mysql> FLUSH privileges;
　 Mysql> QUIT

Note: There are several reasons why there will always be 1067 errors at first:First Look at the download version is correct (64-bit/32-bit system), then there is my.ini inside the path basedir must be configured correctly, Another time to enter the CMD window is not open with the privileges of the administrator (this is easy to forget but very important)

Win7 64-bit system MySQL 5.6 free-installed version configuration