win7 安装mysql 5.7.9记录
--------------------------------------------------------------------------
1. 将配置文件my.ini配置好，放到c:/windows目录下 （echo %windir%),然后执行安装mysql默认数据库的操作：
D:\tools\mysql-5.7.9-winx64\bin>mysqld --initialize-insecure --user=mysql
2. 将mysql安装成windows中的服务：
D:\tools\mysql-5.7.9-winx64\bin>mysqld install
Service successfully installed.
3. 然后在services.msc中启动mysql服务。
4.允许root访问，并且设置了root在192.168.0.101访问过来的密码，并且赋予root授予其他用户权限的权利。（权限传递 使用这个子句时将允许用户将其权限分配给他人）
mysql> grant all on *.* to "root"@"192.168.0.101" identified by "root" WITH GRA
NT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
5. 官方的windows安装文档：
http://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html Troubleshooting a Microsoft Windows MySQL Server Installation
Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
http://dba.stackexchange.com/questions/24403/change-existing-datadir-path
###-------------my.ini----------------------######
####################配置文件开始###################
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[client]
default-character-set=utf8
[mysqld]
port=3306
basedir ="D:/tools/mysql-5.7.9-winx64"
datadir ="D:/tools/mysql-5.7.9-winx64/data"
tmpdir ="D:/tools/mysql-5.7.9-winx64/data"
socket ="D:/tools/mysql-5.7.9-winx64/mysql.sock"
log-error="D:/tools/mysql-5.7.9-winx64/data/mysql_error.log"
#server_id = 2
#skip-locking
max_connections=100
table_open_cache=256
query_cache_size=1M
tmp_table_size=32M
thread_cache_size=8
default-storage-engine=MYISAM
innodb_data_home_dir="D:/tools/mysql-5.7.9-winx64/data/"
innodb_flush_log_at_trx_commit =1
innodb_log_buffer_size=128M
innodb_buffer_pool_size=128M
innodb_log_file_size=10M
innodb_thread_concurrency=16
innodb-autoextend-increment=1000
join_buffer_size = 128M
sort_buffer_size = 32M
read_rnd_buffer_size = 32M
max_allowed_packet = 32M
explicit_defaults_for_timestamp=true
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
####################配置文件结束###################
########D:\tools\mysql-5.7.9-winx64\bin>mysqld --defaults-file="D:\tools\mysql-5.7.9-winx64\my.ini" --console --skip-grant-tables#####################
###-------------my.ini end----------------------######
附：安装过程中的日志、操作信息（备忘）
mysqld install MySQL --defaults-file="D:/tools/mysql-5.7.9-winx64/my.ini"
D:\tools\mysql-5.7.9-winx64\bin>mysqld --defaults-file="D:\tools\mysql-5.7.9-winx64\my.ini" --console --skip-grant-tables
UPDATE user SET Password=PASSWORD("root") where USER="root";
mysql> UPDATE user SET Password=PASSWORD("root") where USER="root";
ERROR 1046 (3D000): No database selected
mysql> use information_schema;
Database changed
mysql> UPDATE user SET Password=PASSWORD("root") where USER="root";
ERROR 1109 (42S02): Unknown table 'user' in information_schema
mysql>
mysqladmin shutdown
http://dba.stackexchange.com/questions/24403/change-existing-datadir-path
http://www.cnblogs.com/lundy/archive/2010/05/07/1729510.html https://bugs.mysql.com/bug.php?id=65413 Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
http://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html Troubleshooting a Microsoft Windows MySQL Server Installation
D:\tools\mysql-5.7.9-winx64\bin>mysqld --initialize-insecure --user=mysql
2015-11-12T15:34:20.701016Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'E
RROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will
be merged with strict mode in a future release.
2015-11-12T15:34:20.701016Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not s
et.
2015-11-12T15:34:20.709016Z 0 [ERROR] --initialize specified but the data direct
ory has files in it. Aborting.
2015-11-12T15:34:20.710016Z 0 [ERROR] Aborting
