Centos 上安装 Docker
sudo yum -y install docker
启动 docker
service docker start
安装 Mysql
docker pull mysql:5.7
运行Mysql
sudo docker run --name pwc-mysql -e MYSQL_ROOT_PASSWORD=123456 -p 3306:3306 -d mysql
配置Mysql
这是远程链接 mysql 连不上，需要进行配置 bind ip
需要进入 docker 的命令行中修改，把 bind-address 改成 0.0.0.0
sudo docker exec -it 342d7aaa66f7 /bin/bash
重启某个镜像
docker restart 342d7aaa66f7
vim /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
#log-error = /var/log/mysql/error.log
# By default we only accept connections from localhost
#bind-address = 127.0.0.1
bind-address = 0.0.0.0
然后再通过远程客户端可以登录mysql 了
Mysql 修改密码
mysql -u root
mysql> SET PASSWORD FOR ('root'@'%') = PASSWORD('password');
Mysql 好用的客户端 mysli
sudo pip install mycli
