Mysql 5.6 installation-free configuration in win7 64-bit system, win7mysql

Mysql 5.6 installation-free configuration in win7 64-bit system, win7mysql

1. Download the official zip package and decompress it to the local directory.

2. Modify the my. ini file copy default. ini and

[Client] port = 3306default-character-set = utf8 # client character type, which must be consistent with the server. We recommend utf8 [mysqld] port = 3306character_set_server = utf8 # server character type. We recommend utf8basedir = D: \ MySQL Server 5.6 # decompress the root directory datadir = C: \ MySQL Server 5.6 \ data # decompress the root directory \ datadefault-storage-engine = INNODBsql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES [WinMySQLAdmin] D: \ MySQL Server 5.6 \ bin \ mysqld.exe # extract the root directory \ bin \ mysqld.exe

2. Install mysql to change the password

Run the cmd command in the bin directory.

A: mysqld -- nistall registers for 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: At the beginning, the error 1067 may occur due to the following reasons: First, check whether the downloaded version is correct (64-bit/32-bit system), and then my. the path basedir in ini must be correctly configured. In addition, when entering the cmd window, do you use the Administrator permission to open it? (this is easy to forget, but it is very important)