windows 安装mysql5.7.15

一、下载mysql-5.7.15-winx64.zip
         http://dev.mysql.com/downloads/mysql/

二、解压到安装目录
        D:\mysql-5.7.15-winx64
建立目录
         D:\mysql-5.7.15-winx64\data

三、配置my.ini

[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 = .....

# datadir = .....

# port = .....

# server_id = .....

basedir = D:/mysql-5.7.15-winx64

datadir = D:/mysql-5.7.15-winx64/data

port = 3306

max_connections = 200

character-set-server = utf8

default-storage-engine = INNODB

# 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 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

四、初始化
        D:\mysql-5.7.15-winx64\bin>mysqld --initialize
        D: \ mysql-5.7.15-winx64\bin >mysqld install

        \>net start mysql

五、初始化密码
        D:\Servers\mysql-5.7.15-winx64\data\xxx.err
       A temporary password is generated for root@localhost:  uvoo!T?js2Ur  

       \> mysql -uroot -p uvoo!T?js2Ur
       mysql>set password=password('root'); 

六、设置可远程访问
     mysql>use mysql;
     mysql>update user set host='%' where user='root';
     mysql>flush privileges;

     设置windows防火墙，开放3306
 

七、远程访问验证
      # ./mysql -uroot -proot -h192.168.1.102

八、初始密码找不到怎么办

     \>net stop mysql

      D:\mysql-5.7.15-winx64\bin>mysqld_safe --skip-grant-tables

     D:\mysql-5.7.15-winx64\bin>mysql -uroot

   

     mysql>use mysql;

     mysql>update user set authentication_string=password('root') where user='root';