windows安装mysql

安装包下载

• 下载地址：https://dev.mysql.com/downloads/mysql/

• Mysql国内镜像：http://mirrors.sohu.com/mysql/MySQL-8.0/

下载完成后，选择一个磁盘内放置并解压。

设置环境变量

1. 变量名：MYSQL_HOME
2. 变量值：E:\mysql5.7.23
3. path里添加：%MYSQL_HOME%\bin

初始化设置

创建data Uploads文件夹

my.init文件

[mysqld]
port=3306
character_set_server=utf8
basedir=E:\mysql5.7.23
datadir=E:\mysql5.7.23\data
server-id=1
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
lower_case_table_names=1
innodb_file_per_table = 1
log_timestamps=SYSTEM

log-error   = error.log
slow_query_log = 1
slow_query_log_file = slow.log
long_query_time = 5
log-bin = binlog
binlog_format = row
expire_logs_days = 15
log_bin_trust_function_creators = 1
secure-file-priv=E:\mysql5.7.23\Uploads

[client]   
default-character-set=utf8

---

阅读全文 »