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
這是遠(yuǎn)程鏈接 mysql 連不上病线,需要進(jìn)行配置 bind ip
需要進(jìn)入 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
然后再通過遠(yuǎn)程客戶端可以登錄mysql 了
Mysql 修改密碼
mysql -u root
mysql> SET PASSWORD FOR ('root'@'%') = PASSWORD('password');
Mysql 好用的客戶端 mysli
sudo pip install mycli