mac M1上安装mysql镜像--platform linux/x86_64

最新推荐文章于 2024-12-06 19:13:56 发布

原创最新推荐文章于 2024-12-06 19:13:56 发布 · 1.6k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #macos #linux

mysql 专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了如何使用Docker拉取并运行MySQL镜像，配置环境变量，设置端口映射，以及为用户tanli创建权限。重点展示了如何使用docker run命令和SQL脚本来管理数据库用户和权限。

docker pull mysql --platform linux/x86_64

docker run -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:latest

docker cp mysql:/etc/mysql /Users/tanli/Downloads/docker

#!/bin/sh
docker run
-p 3306:3306
–name mysql
–privileged=true
–restart unless-stopped
-v /Users/tanli/Downloads/docker/mysql:/etc/mysql
-v /Users/tanli/Downloads/docker/mysql/logs:/logs
-v /Users/tanli/Downloads/docker/mysql/data:/var/lib/mysql
-v /etc/localtime:/etc/localtime
-e MYSQL_ROOT_PASSWORD=123456
-d mysql:latest

CREATE USER tanli@127.0.0.1 IDENTIFIED WITH mysql_native_password BY ‘123456’;

GRANT Alter, Alter Routine, Create, Create Routine, Create Temporary Tables, Create User, Create View, Delete, Drop, Event, Execute, File, Grant Option, Index, Insert, Lock Tables, Process, References, Reload, Replication Client, Replication Slave, Select, Show Databases, Show View, Shutdown, Super, Trigger, Update ON . TO tanli@127.0.0.1;