mysql-5.7.18-win32-install Win7 32 installation record

1-Download the free install version from www.mysql.com website, zip suffix

2-After decompression, modify the folder name MySQL "Optimize under name, easy to remember", and cut to C root directory

3-Create the empty folder data under the root of the installation, and add the system environment variable path =c:\mysql\bin, and add the system environment variable Mysql_home=c:\mysql "feel useless, not used in path"

4-Build the My.ini file with the following file contents, placed in the MySQL root directory:

#[mysqld] #basedir = "#datadir =" \ "#[windowsmysqlserver] #Server =" "#以下是复制内容, this line does not copy [client]port= 3306default-character-set=utf8# client character type, consistent with the server, it is recommended to utf8[mysqld]port=3306character_set_server=utf8# the service-side character type, Suggest utf8basedir=c:\mysql# datadir=c:\mysql\data# the directory \datasql_mode=no_engine_substitution,strict_trans_ TABLES default-storage-engine=memory[winmysqladmin]server=c:\mysql\bin\mysqld.exe# The directory \bin\mysqld.exe# above is the copy content, This is not a copy.

5-It is said that the following statements must be executed under the bin path, which I executed under the bin path: mysqld--initialize--user=mysql--console

The Data folder appears in MySQL, ' Performance_schema, sys 3 folders, and a few other files

Note: Here is a root account password that must be manually recorded.

6-Register, continue: Mysqld--install

7-Start service: net start MySQL

8-Login: Mysql-u root-p
Prompt for password: Enter password: ******

The following is a successful sign-in example, "Copying from somewhere else":
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is $ to server version:5.0.24a-community-nt

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear thebuffer.

The above is a successful complete configuration, during various errors, such as the service started successfully, but the login is unsuccessful, such as registration success, because there is no 5th step, the service failed to start.

If there is an error, there is no relationship, workaround:

1-Perform first or delete first:

If the service is started: net stop MySQL removal service: mysqld-remove
Empty all files under the Data folder

2-Return to the above success story start with the 5th step, or start at step 1th.

The above is a free installation configuration of a test process record, later interested, can be verified under: whether it must be executed in the Bin directory to be effective!!

mysql-5.7.18-win32-install Win7 32 installation record