mysql 5.7 配置安装

卢艳亮

于 2016-03-22 13:56:52 发布

阅读量370

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/yanlianglu/article/details/50687784

版权

数据库专栏收录该内容

6 篇文章 0 订阅

订阅专栏

环境：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