无法从 Docker 实例连接到 MYSQL

Unable to connect to MYSQL from Docker Instance(无法从 Docker 实例连接到 MYSQL)
本文介绍了无法从 Docker 实例连接到 MYSQL的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我是 Docker 的新手,并使用以下命令从 docker hub 拉取了 mysql

I'm new to Docker and pulled the mysql from the docker hub using following command

docker pull mysql

现在,使用以下命令启动 mysql 实例.

Now, started mysql instance using following commands.

docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password -d mysql/mysql-server:latest
Unable to find image 'mysql/mysql-server:latest' locally
latest: Pulling from mysql/mysql-server

e64f6e679e1a: Pull complete
799d60100a25: Pull complete
85ce9d0534d0: Pull complete
d3565df0a804: Pull complete
Digest: sha256:59a5854dca16488305aee60c8dea4d88b68d816aee627de022b19d9bead48d04
Status: Downloaded newer image for mysql/mysql-server:latest
1be4f5dde2fb4e1d99e23ee2de5e3b663c7c2d0fabe7ef459cf87385071a2e0d

现在,我已经检查了所有服务的启动和运行情况.

Now, I've checked what all services are up and running.

docker ps
CONTAINER ID        IMAGE                       COMMAND                  CREATED             STATUS                   PORTS                               NAMES
1be4f5dde2fb        mysql/mysql-server:latest   "/entrypoint.sh mysql"   3 minutes ago       Up 3 minutes (healthy)   0.0.0.0:3306->3306/tcp, 33060/tcp   mysql
e7d9e3713f5c        ubuntu                      "/bin/bash"              6 days ago          Up 6 days                                                    angry_hodgkin

现在我执行以下命令无法连接到mysql -

and now I execute the following commands and unable to connect to mysql -

mysql -h127.0.0.1 -ppassword -uroot
-bash: mysql: command not found

Docker 版本..

Docker version..

docker --version
Docker version 1.12.3, build 6b644ec

现在,我遇到了错误 - EDIT-1

docker exec -it 1be4f5dde2fb bash
bash-4.2# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
bash-4.2# sudo mysql
bash: sudo: command not found

https://hub.docker.com/r/mysql/mysql-server/

推荐答案

使用以下命令进入docker容器

Get in the docker container using the following command

docker exec -it mysql bash

然后您可以通过执行以下命令轻松连接到 MySQL

You can then easily connect to MySQL, by executing the following command

mysql -uroot -p

如果您尝试从主机连接,则必须安装 mysql 客户端.在mac上,命令如下

If you are trying to connect from the host machine, then you will have to install the mysql client. On mac, the command is as follows

brew install mysql

这篇关于无法从 Docker 实例连接到 MYSQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Hibernate reactive No Vert.x context active in aws rds(AWS RDS中的休眠反应性非Vert.x上下文处于活动状态)
Bulk insert with mysql2 and NodeJs throws 500(使用mysql2和NodeJS的大容量插入抛出500)
Flask + PyMySQL giving error no attribute #39;settimeout#39;(FlASK+PyMySQL给出错误,没有属性#39;setTimeout#39;)
auto_increment column for a group of rows?(一组行的AUTO_INCREMENT列?)
Sort by ID DESC(按ID代码排序)
SQL/MySQL: split a quantity value into multiple rows by date(SQL/MySQL:按日期将数量值拆分为多行)