docker安装mysql

BigData-0

已于 2024-08-29 22:34:33 修改

阅读量752

点赞数 19

文章标签： docker mysql adb

于 2023-12-06 23:51:01 首次发布

Author:baiyun ,Email:[email protected]

本文链接：https://blog.csdn.net/JavaBigData/article/details/134843843

版权

文章详细描述了如何在vim中编辑my.cnf文件以设置MySQL的UTF-8MB4字符集，使用docker运行并管理MySQL容器，包括设置环境变量、权限授予和执行常见docker命令。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

docker镜像库

sudo tee /etc/docker/daemon.json <<-'EOF'
{
    "registry-mirrors": [
        "https://do.nark.eu.org",
        "https://dc.j8.work",
        "https://docker.m.daocloud.io",
        "https://dockerproxy.com",
        "https://docker.mirrors.ustc.edu.cn",
        "https://docker.nju.edu.cn"
    ]
}
EOF
重启
sudo systemctl daemon-reload
sudo systemctl restart docker

vim /usr/local/mysql/my.cnf

[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
default-time_zone = '+8:00'
authentication_policy=mysql_native_password
secure_file_priv=
init_connect='SET collation_connection = utf8mb4_0900_ai_ci'
init_connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
collation-server=utf8mb4_0900_ai_ci
skip-character-set-client-handshake
skip-name-resolve

`docker pull mysql:latest`

docker run -p 33063:3306 --privileged=true         \
-v /mysql/data:/var/lib/mysql                       \
-v /mysql/log:/var/log/mysql                        \
-v /mysql/conf:/etc/mysql/conf.d                    \
-e MYSQL_ROOT_PASSWORD=123456 --name=mysql2 -d mysql:latest

远程连接`mysql -uroot -p1234 -P 33063`

docker常用命令

 docker ps -a
docker exec -it mysql-server /bin/bash
docker logs -f mysql
docker stop mysql2
docker rm 00e44768094b f75ae0ba2e96

sql

mysql> grant select,update,insert,delete on *.* to root@^Cdentified by "root";
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.01 sec)
FLUSH PRIVILEGES;