切换到mysql目录
cd /mnt/mysql
创建MySQL数据挂载目录
mkdir data
mkdir config
创建mysql yaml文件
touch mysql.yml
编辑yaml文件
vi mysql.yml
添加如下内容
version: '2'
services: mysql
container_name: mysql8
image: mysql:8.0.26
ports:
- "3306:3306"
restart: always
environment:
- MYSQL_ROOT_PASSWORD: 123456
volumes:
- "/mnt/mysql/data:/var/lib/mysql"
- "/mnt/mysql/config:/etc/mysql/conf.d"
使用docker compose创建并运行mysql容器
docker-compose -f mysql.yml up -d
查看容器id
docker ps
进入容器内部
docker exec -it 容器id sh
连接到MySQL
mysql -uroot -p123456
修改root账号的密码
alter user 'root'@'%' identified with mysql_native_password by '123456';
alter user 'localhost'@'%' identified with mysql_native_password by '123456';
flush privileges;
使用source执行sql文件乱码问题解决方案1
查看数据库编码
show variables like '%char%';
如以下配置不是utf-8,则都设置为utf-8
set character_set_client=utf8mb4;
set character_set_connection=utf8mb4;
set character_set_database=utf8mb4;
set character_set_results=utf8mb4;
set character_set_server=utf8mb4;
使用source执行sql文件乱码问题解决方案2
docker ps -- 查看容器
docker exec -it 容器id sh -- 进入容器内部
docker cp 容器id:/etc/mysql/my.cnf /mnt/mysql/config -- 复制容器内部的配置文件
vi /mnt/mysql/config/my.cnf
[mysqld]
character_set_server = utf8
init_connect='SET NAMES utf8'
[mysql]
default-character-set = utf8
[mysql.server]
default-character-set = utf8
[mysqld_safe]
default-character-set = utf8
[client]
default-character-set = utf8
数据库连接工具无法连接问题
use mysql;
update user set host = '%' where user = 'root';
flush privileges;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;