无法从Docker实例连接到MYSQL
我是Docker
的新手,并使用以下命令将mysql
从 docker hub 中拉出了
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
使用以下命令进入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