mysql下载64位win10_64位win10安装mysql-5.6.37-winx64

一、安装准备

mysql-5.6.37-winx64下载

二、安装mysql

1.解压mysql-5.7.11-win32.zip 到 c:\mysql-5.7.11-win32

2.设置环境变量 MYSQL_HOME=c:\mysql-5.7.11-win32, path=%MYSQL_HOME%\bin

3.关键一步是my.ini的设置，我的是

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/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.

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

# 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

basedir = D:\\software\\mysql-5.6.37-winx64\\

datadir = D:\\software\\mysql-5.6.37-winx64\data\\

port = 3306

server_id = 1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

general-log=0

general_log_file="mysql_general.log"

slow-query-log=1

slow_query_log_file="mysql_slow_query.log"

long_query_time=10

log-error="mysql_error_log.err"

default-storage-engine=INNODB

max_connections=1024

query_cache_size=128M

key_buffer_size=128M

innodb_flush_log_at_trx_commit=1

innodb_thread_concurrency=128

innodb_autoextend_increment=128M

tmp_table_size=128M

# 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

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

character-set-server=utf8

innodb_flush_method=normal

4. 管理员身份进入cmd(以下都是)

5.mysqld --install MySQL --defaults-file=D:\software\mysql-5.6.37-winx64\my.ini 安装mysql服务

6.mysqld --initialize 这是生成data目录及初始化数据

7.启动服务net start mysql 或在服务中启动

9. mysql -uroot -p登录mysql

输入初始密码连接进入mysql数据库后，修改密码如下：

set password=password('123456');

flush privileges;

退出再次登录，使用新密码就行了：

mysql -uroot -p123456