64-bit win7 mysql zip package, win7mysql

64-bit win7 mysql zip package, win7mysql

1) download the zip package and decompress it.

2) Configure environment variables to the bin directory. For example, your own directory is: F: \ mysql \ mysql-5.6.21-winx64 \ mysql-5.6.21-winx64 \ bin

3) create a my. ini directory in the same directory as the my-default.ini

The configuration is as follows:

[Mysql]
# Set the default Character Set of the mysql client
Default-character-set = utf8
[Mysqld]
# Set port 3306
Port = 3306
# Set the installation directory of mysql
Basedir = F: \ mysql\ mysql-5.6.21-winx64 \ mysql-5.6.21-winx64
# Set the directory for storing mysql database data
Datadir = F: \ mysql \ mysql-5.6.21-winx64 \ mysql-5.6.21-winx64 \ data
# Maximum number of connections allowed
Max_connections = 200
# The default character set used by the server is the 8-bit latin1 character set.
Character-set-server = utf8
# The default storage engine used to create a new table
Default-storage-engine = INNODB

The path is subject to your mysql installation directory.

4) install the mysql Service

Find cmd.exe in the path C: \ Windows \ system32and right-click it to run as an administrator. (permissions are strictly differentiated under win 7 and must be set as administrator)
Automatic: mysqld -- install [service name]
Manual: mysqld -- install-manual [service name]

Here I provide the installation method is: mysqld-install MySQL -- defaults-file = "F: \ mysql \ mysql-5.6.21-winx64 \ mysql-5.6.21-winx64 \ my. ini"
Note: You must change "-defaults" to "-- defaults". The mysqld command does not have the-d option, while MYSQL does not parse parameters, if you encounter xxxx-dxxxx,-D will be treated as an option.
Mysql finds c: \ my. ini and c: \ windows \ my. ini by default, and my. ini or my. cnf under the installation directory

5) Start and close the mysql service.

After windows + R, enter net start mysql to start the mysql service.

Enter net stop mysql to stop mysql Service