欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

mysql-5.7.16-winx64 安装

程序员文章站 2022-05-27 22:00:25
...

 

官方下载地址:http://dev.mysql.com/downloads/mysql/

我这里下载的是:MySQL Community Server 5.7.16(Windows (x86, 64-bit), ZIP Archive)

win7 系统安装到D盘根目录

 

1、将压缩包解压到D盘根目录

      D:\mysql-5.7.16-winx64

2、修改D:\mysql-5.7.16-winx64\my-default.ini文件

 basedir = D:\mysql-5.7.16-winx64
 datadir = D:\mysql-5.7.16-winx64\data
 port = 3306
 server_id = 1
 tempdir = D:\mysql-5.7.16-winx64\temp


skip-grant-tables
skip-networking

 

完整配置如下:

# 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.

[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 = D:\mysql-5.7.16-winx64
 datadir = D:\mysql-5.7.16-winx64\data
 port = 3306
 server_id = 1
 tempdir = D:\mysql-5.7.16-winx64\temp


# 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 

#修改mysql 配置文件跳过密码验证,密码修改完成后请将他们注释掉
skip-grant-tables
skip-networking

 

3、添加系统变量MYSQL_HOME,变量值为:D:\mysql-5.7.16-winx64

在系统变量path中添加%MYSQL_HOME%\bin;(记得加英文分号)

 

4、安装mysql 服务

以系统管理员身份打开cmd命令行,命令行中切换到D:\mysql-5.7.16-winx64\bin目录,输入:

mysqld --install

 

5、初始化mysql

还是在刚才的命令窗口,输入:

mysqld --initialize

 输入命令后会创建data目录及相关文件

 

6、启动mysql服务

net start MySQL

 

 

7、修改root默认密码

用记事本打开D:\mysql-5.7.16-winx64\data\下后缀位.err 的文件。我这里是WIN-6.err。

查找password,这里v%eKW7DekFrt是随机生成的密码,用于下面登陆使用。

[Note] A temporary password is generated for [email protected]: v%eKW7DekFrt

 

8、执行mysql -uroot -pv%eKW7DekFrt登陆mysql

mysql -uroot -pv%eKW7DekFrt

 

9、输入命令修改密码

SET PASSWORD = PASSWORD('123456');

 

密码设置为123456,exit退出MySQL,然后就可以重新登陆了。

 

 

------------------------------------------------------------------------------------------------------------

在到第6步,启动MySQL服务时候遇到一个问题,服务无法启动,没有错误信息提示。。。

通过下面命令删除,重新安装了一下,然后启动服务ok。

mysqld --remove 删除mysql服务

mysqld --install 安装mysql服务

mysqld --initialize 一定要初始化

net start mysql 启动服务

 

 

 

 

 

 

 

 

 

 

 

相关标签: mysql 安装