MySQL 5.7 在 windows 安装方法

来源：互联网发布：淘宝网红鞋店编辑：程序博客网时间：2024/06/04 23:31

原官网下载地址： http://dev.mysql.com/downloads/mysql/

当前安装环境： windows 8.1 + mysql 5.7.13

解压文件到目录：D:\A_Software\mysql-5.7.13-winx64

创建目录：

D:\A_Software\mysql-5.7.13-winx64\log

D:\A_Software\mysql-5.7.13-winx64\data

D:\A_Software\mysql-5.7.13-winx64\data\binlog

以下都在命令行操作

配置文件

> D:\A_Software\mysql-5.7.13-winx64\my.ini[mysqld]basedir = "D:/A_Software/mysql-5.7.13-winx64/"datadir = "D:/A_Software/mysql-5.7.13-winx64/data/"tmpdir  = "D:/A_Software/mysql-5.7.13-winx64/data/"socket  = "D:/A_Software/mysql-5.7.13-winx64/data/mysql.sock"log-error = "D:/A_Software/mysql-5.7.13-winx64/log/mysql_log_err.log"log-bin   = "D:/A_Software/mysql-5.7.13-winx64/data/binlog/mysql_bin.log"secure-file-priv = nullport = 3306server_id = 1autocommit = 1event_scheduler = 1log_slave_updates = 1explicit_defaults_for_timestamp = 1max_connections = 100binlog_format = rowcharacter-set-server = utf8default-storage-engine=innodbtransaction_isolation = read-committedsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER

# 环境变量> set  PATH "%PATH%;D:\A_Software\mysql-5.7.13-winx64\bin;> setx PATH "%PATH%;D:\A_Software\mysql-5.7.13-winx64\bin;# 初始化> mysqld --defaults-file="D:/A_Software/mysql-5.7.13-winx64/my.ini" --initialize --explicit_defaults_for_timestamp  # 添加服务 (移除服务：mysqld remove)> mysqld --install MySQL --defaults-file="D:/A_Software/mysql-5.7.13-winx64/my.ini" # 启动mysql服务（停止：net stop mysql）> net start mysql# 首次访问mysql (须重新设置root密码)> mysql -u rootmysql> alter user 'root'@'localhost'identified by'mysql';mysql> flush privileges;#【另：忘记root密码设置方法】# 停止服务，启动服务（忽略授权表）> net stop mysql> mysqld -nt --skip-grant-tables; # 打开另一个命令行窗口，重新访问mysql> mysql -uroot# 进入mysql更改root密码mysql> select host,user from mysql.user;mysql> update mysql.user set authentication_string=password('mysql') where user='root' and host = 'localhost';mysql> flush privileges;mysql> alter user 'root'@'localhost'identified by'mysql';mysql> flush privileges;mysql> quit;# 关闭服务窗口（mysqld -nt --skip-grant-tables）> net start mysql> mysql -u root -p

0 0