环境:Win7、mysql 5.7.11
1、进入MySQL的下载页面,选择Community选项,然后选择Download MySQL Community Server 版本;
2、选择64位安装文件;
3、跳转到下载页,不用登录,可以直接点击“No thanks, just start my download.",进行下载;
4、解压到安装的目录下;
5、新建一个my.ini文件和data文件夹,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]
port=3306
default-character-set=utf8
[mysqld]
port=3306
character_set_server=utf8
basedir=D:\program\work\mysql-5.7.11-winx64\
datadir=D:\program\work\mysql-5.7.11-winx64\data\
# 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
sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO
# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
D:\program\work\mysql-5.7.11-winx64\bin\mysqld.exe
6、 添加环境变量
操作如下:
1)右键单击我的电脑->属性->高级系统设置(高级)->环境变量
点击系统变量下的新建按钮
输入变量名:MYSQL_HOME
输入变量值:D:\Program Files\mysql-5.7.9-win32
#即为mysql的自定义解压目录。
2)选择系统变量中的Path
点击编辑按钮
在变量值中添加变量值:;%MYSQL_HOME%\bin
注意是在原有变量值后面加上这个变量,用;隔开,不能删除原来的变量值
7、安装
1)管理员身份进入bin目录
2)mysqld --initialize
3)mysqld install
如果报错,可以到data目录下的sunny-PC.err文件中查看错误原因。
8、修改 root 账号的密码
1. 修改MySQL的配置文件(my.ini),在[mysqld]下添加一行skip-grant-tables
2. mysql 重启后,即可直接用 mysql -u root -p 进入(此时密码为空)
3. mysql> update mysql.user set authentication_string=password('123qaz') where user='root' and Host = 'localhost';
4. mysql> flush privileges;
5. mysql> quit;
6. 将/etc/my.cnf文件还原(删除skip-grant-tables这一行),重新启动 mysql
7. 这个时候可以使用 mysql -u root -p '123qaz' 进入了
8. mysql>SET PASSWORD = PASSWORD('123456'); 设置新密码
注:
在命令行启动mysql命令为: net start mysql
关闭mysql命令为:net stop mysql