[sql]mysql部署
docker
docker run \
-itd \
-p 3306:3306 \
--restart always \
-e MYSQL_ROOT_PASSWORD=root \
-e TZ=Asia/Shanghai \
-v ${HOME}/mysql:/var/lib/mysql \
--name mysql57 \
mysql:5.7 \
--character-set-server=utf8mb4 \
--collation-server=utf8mb4_unicode_ci \
--character-set-client-handshake=FALSE
docker run -it --rm mysql:5.7 mysql -h172.17.0.2 -uroot -proot
win
- [下载mysql-5.7.30-winx64.zip](https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.30-winx64.zip)
https://dev.mysql.com/downloads/mysql/
- 配置文件
my.ini
[mysqld]
default-storage-engine = innodb
innodb_file_per_table = 1
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init-connect = 'SET NAMES utf8mb4'
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[mysqld]
#设置3306端口
port = 3306
# 设置mysql的安装目录
basedir = D:\dev\mysql-5.7.30-winx64
# 设置mysql数据库的数据的存放目录
datadir = D:\dev\mysql-5.7.30-winx64\data
# 允许最大连接数
max_connections = 200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server = utf8mb4
# 创建新表时将使用的默认存储引擎
default-storage-engine = INNODB
default-time_zone = '+8:00'
- 安装
添加winpath
mysqld install
mysqld --initialize-insecure --user=mysql
net start mysql
- 改root密码
mysql -uroot -p
set password for root@localhost = password('root');