一、卸载
卸载链接:
https://www.cnblogs.com/zhaochenguang/p/11465738.html
测试mysql是否有安装过其他版本
yum list installed mysql*
三步卸载
yum remove mysql-community-client mysql-community-common mysql-community-libs mysql-community-libs-compat mysql-community-server mysql57-community-release
rm -rf /var/lib/mysql
rm /etc/my.cnf
二、yum安装
安装链接:
https://www.cnblogs.com/rose0705/articles/9484511.html
rpm -aq |grep mysql
显示使用yum已经安装的mysql
yum list installed | grep mysql
切换到安装目录
cd /usr/local/mysql
下载
wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
rpm -qpl mysql80-community-release-el7-1.noarch.rpm
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
yum list installed | grep mysql
yum repolist all | grep mysql
yum repolist enabled | grep mysql
yum install mysql-community-server
y
关闭防火墙
- 安装mysql 提供的yum源
- 修改yum源的配置信息,确定安装那个版本
确认修改有效: - yum repolist enabled | grep “mysql.-community.”
- 安装mysql社区
- yum install mysql-community-server`
查看临时密码
grep 'temporary password' /var/log/mysqld.log
启动mysql
service mysqld start
登录
mysql -u root -p
输入临时密码
登陆后修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123QWEasd!'
退出
exit;
重新登录
三、docker安装
docker 命令
systemctl start docker
拉去镜像
docker pull mysql:8.0
确保3306端口关闭
停掉宿主机的mysqld
创建容器
docker run -d --name dockermysql -p3306:3306 -v /usr/local/docker/data:/var/lib/mysql
-e MYSQL_ROOT_PASSWORD=12345 mysql:8.0 --lower_case_table_names=1
查看容器的详细信息
docker inspect dockermysql
查看容器运行日志
docker logs dockermsyql
使用宿主机mysql连接容器的mysqld
mysql -uroot -p12345 -h172.17.0.2 (第一个容器的默认ip)
进入容器中
docker exec -it dockermysql /bin/bash
docker stop dockermysql
docker start dockermysql
附图: