docker容器中安装mysql,安装记录
linux下离线安装mysql
网上找教程,再mysql的解压目录bin下,执行./mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/ --initialize报错,参考https://blog.csdn.net/m0_37886429/article/details/78844358
再执行mysqld,安装成功
启动mysql报错service找不到
参考https://www.jianshu.com/p/9f125940a9e9
解决方案:yum list | grep initscripts
yum install initscripts -y
启动mysql
进入mysql目录/usr/local/mysql/support-files,执行./mysql.server start
修改密码
alter user ‘root’@‘localhost’ identified by ‘123456’;
容器中的3306端口映射
容器中ip a 查看网卡的IP,得到是:172.17.0.2
宿主机上映射端口:iptables -t nat -I DOCKER ! -i docker_gwbridge -p tcp -m tcp --dport 33306 -j DNAT --to-destination 172.17.0.2:3306
本地连不上mysql
解决方案: