Windows7 64位压缩包安装MySQL5.7.9

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
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 are commonly set, remove the # and set as required.
basedir=C:/webserver/mysql
datadir=C:/webserver/mysql/data
port=6033
# server_id = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
bulk_insert_buffer_size = 16M
innodb_flush_log_at_trx_commit = 0

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

path-to-mysql\bin\mysqld.exe --initialize

path-to-mysql\bin\mysqld.exe --console 或者
path-to-mysql\bin\mysqld.exe --log-error 或者
path-to-mysql\bin\mysqld.exe --standalone

path-to-mysql\bin\mysql -P 6033 -u root -p
# 指定编码的连接
path-to-mysql\bin\mysql.exe -P 6033 -u root -p --default-character-set=utf8

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> SET PASSWORD = PASSWORD('root');

path-to-mysql\bin\mysqladmin.exe -P 6033 -u root -p shutdown

path-to-mysql\bin\mysqld.exe --install MySQL --defaults-file=path-to-it\mysql\my.ini
#移除服务
path-to-mysql\bin\mysqld.exe --remove

net start mysql
net stop mysql

@echo off
net stop memcached
net stop MySQL
net stop Apache2.4

net start memcached
net start Apache2.4
net start MySQL
pause