雪之梦技术驿站
  • Summary
  • Tips
  • 运维部署
    • docker-advance
    • docker + Bark
    • docker + blog
    • docker compose
    • docker + crawlab
    • docker + email
    • docker 环境
    • docker + gitbook
    • docker + gitea
    • docker + gitlab
    • docker + gogs
    • docker + mojo-Weixin
    • docker + mysql
    • docker + nginx
    • docker 操作
    • docker + py12306
    • docker + redis
    • docker + resume
    • docker + springboot
    • docker + wechat-work-message-push-go
  • git
    • git 入门教程
    • base
      • 初识 git
      • 配置 git
      • 安装 git
  • github
    • github 入门教程
  • 晚安
  • markdown
    • README_update
  • todo
    • github 快速入门
    • android studio 快速入门
    • gitignore 快速入门
    • gulp快速入门
    • java 快速入门
    • lodash快速入门
    • maven 快速入门
    • mysql 快速入门
    • nginx 快速入门
    • npm 快速入门
    • nvm快速入门
    • regexper快速入门
    • sublime快速入门
    • svn 快速入门
    • tomcat 快速入门
    • yarn快速入门
  • write
    • 快速上手Mermaid流程图
  • gitbook
    • gitbook-plugin-advanced-emoji
      • LICENSE-IMAGES
      • LICENSE
Powered by GitBook
On this page

Was this helpful?

  1. 运维部署

docker + mysql

https://hub.docker.com/_/mysql/

  • 启动

docker run -p 3306:3306 --name mysql \
-v ~/mysql/conf:/etc/mysql \
-v ~/mysql/logs:/var/log/mysql \
-v ~/mysql/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:5.7.28
docker exec mysql whereis mysql
docker exec mysql ls /etc/mysql
docker cp mysql:/etc/mysql/my.cnf ~/mysql/conf/
  • 链接 mysql

docker exec -it mysql bash
mysql -uroot -p123456
use mysql
select user,authentication_string from user;
update user set authentication_string=''  where user='root';
alter user 'root'@'%' IDENTIFIED BY 'root@alsk1029';
alter user 'root'@'localhost' IDENTIFIED BY 'root@alsk1029';
flush privileges;
host: 127.0.0.1
port: 3306
user: root
password: 123456
  • 修改密码

docker exec -it mysql bash
mysqladmin -uroot -p123456 password 123
Previousdocker + mojo-WeixinNextdocker + nginx

Last updated 8 months ago

Was this helpful?

使用Docker搭建MySQL服务
进入Docker容器中修改mysql密码
docker 安装报错 ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: YES)解决方法