下载
注意:5.7+版本缺少文件,可从5.6版本里对比添加
安装
将压缩包放在你想安装的目录下, 解压.
我的安装目录为:
“C:\develop\database\MySQL\mysql-5.6.30-winx64”
将解压目录下默认文件 my-default.ini 拷贝一份,改名 my.ini
添加下面的配置信息到 my.ini 保存
[mysqld]
# 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 = .....
#########################################################
[client]
#端口
port=3306
#默认字符集
default-character-set=utf8
[mysqld]
port=3306
character_set_server=utf8
basedir=C:\develop\database\MySQL\mysql-5.6.30-winx64
datadir=C:\develop\database\MySQL\mysql-5.6.30-winx64\data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
C:\develop\database\MySQL\mysql-5.6.30-winx64\bin\mysqld.exe
#########################################################
# 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
添加环境变量
操作如下:
1)右键单击我的电脑->属性->高级系统设置(高级)->环境变量
点击系统变量下的新建按钮
输入变量名:MYSQL_HOME
输入变量值:C:\develop\database\MySQL\mysql-5.6.30-winx64
#即为mysql的自定义解压目录。
2)选择系统变量中的Path
点击编辑按钮
在变量值中添加变量值:%MYSQL_HOME%\bin
注意是在原有变量值后面加上这个变量,用;隔开,不能删除原来的变量值
将mysql注册为windows系统服务
1)从控制台进入到MySQL解压目录下的 bin 目录下:
2)( 系统管理员 )输入服务安装命令:
>mysqld install MySQL
安装成功后会提示服务安装成功。
#若发生1067错误, 级my.ini配置错误
#移除服务命令为:mysqld remove
启动MySQL服务
cmd
>net start mysql
修改root密码
cmd
>mysql -u root
cmd mysql
>SHOW DATABASES;
>USE mysql;
>UPDATE user SET password=PASSWORD("root") WHERE user="root";
>FLUSH PRIVILEGES;
>QUIT
修改完毕,
重新登录
cmd
>mysql -u root -p
cmd password
>root