Centos5.7 mysql rpm和docker 二种方式

一、Centos7.x 安装/完美卸载 mysql5.7（5.7.30）

<!--add by 胡化敏 2020年05月01日22:28:10 email [e-mail] -->

1.下载mysql安装源rpm

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

2.安装数据库

rpm -ivh mysql57-community-release-el7-8.noarch.rpm
yum install mysql-server

3.启动数据库

systemctl start mysqld
#或者
service mysqld start

4.登录数据库

4.1查看安装随机密码

grep "password" /var/log/mysqld.log
#输出
#A temporary password is generated for root@localhost: Hi*rJ->wk8hj

4.2登录修改默认密码,授权远程访问

mysql -uroot -pHi*rJ->wk8hj
#密码规则要复杂 字符数字特殊字符，大小写
alter user user() identified by "您的新密码";
#授权远程访问  你的登录账号建议不要用root
GRANT ALL PRIVILEGES ON *.* TO '你的登录账号'@'%' IDENTIFIED BY '你的新密码' WITH GRANT OPTION;

4.3用远程客户端链接

​ 图1-1

成功如图1-1所示

如果链接不上，看下防火墙3306有没有开，

若果是阿里云或者腾讯云看看安全组端口3306有没有放开

5.Centos7.x 卸载 mysql5.7（5.7.30）

5.1查看已安装模块

rpm -qa|grep -i mysql
#返回已安装：
#mysql57-community-release-el7-8.noarch
#mysql-community-client-5.7.30-1.el7.x86_64
#mysql-community-libs-compat-5.7.30-1.el7.x86_64
#mysql-community-common-5.7.30-1.el7.x86_64
#mysql-community-libs-5.7.30-1.el7.x86_64
#mysql-community-server-5.7.30-1.el7.x86_64

5.2卸载已安装的mysql模块

rpm -e --nodeps mysql57-community-release-el7-8.noarch
rpm -e --nodeps mysql-community-client-5.7.30-1.el7.x86_64
rpm -e --nodeps mysql-community-libs-compat-5.7.30-1.el7.x86_64
rpm -e --nodeps mysql-community-common-5.7.30-1.el7.x86_64
rpm -e --nodeps mysql-community-libs-5.7.30-1.el7.x86_64
rpm -e --nodeps mysql-community-server-5.7.30-1.el7.x86_64

5.3再次检查已安装的模块

5.4清理文件

find / -name mysql
#数据
# /usr/share/mysql
# /var/lib/mysql
# /usr/lib64/mysql
# /etc/selinux/targeted/active/modules/100/mysql
# /etc/selinux/targeted/tmp/modules/100/mysql

5.5删掉输出文件、日志文件

rm -rf /usr/share/mysql
rm -rf /var/lib/mysql
rm -rf /usr/lib64/mysql
rm -rf /etc/selinux/targeted/active/modules/100/mysql
rm -rf /etc/selinux/targeted/tmp/modules/100/mysql
#日志文件
rm -rf /var/log/mysqld.log

二、Docker 快速安装/卸载 mysql5.7

1.前置条件docker环境

自行参考安装centos版本

2.拉取mysql5.7.30镜像

docker pull mysql:5.7.30

3.启动mysql

#先创建目录 /data/mysql5.7.30/conf,/data/mysql5.7.30/logs,/data/mysql5.7.30/data
#MYSQL_ROOT_PASSWORD 填写自己的密码

docker run -p 3309:3306 --name mysql5.7.30 \
-v /data/mysql5.7.30/conf:/etc/mysql \
-v /data/mysql5.7.30/logs:/var/log/mysql \
-v /data/mysql5.7.30/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=xxxxxx \
-d mysql:5.7.30

4.进入容器访问你的mysql

#docker exec -it 容器的名称或者container id  bash
docker exec -it mysql5.7.30 bash
mysql -uroot -p
#输入您的密码

5.查看是否授权远程登录(登录mysql之后的命令 mysql>)

use mysql;
select Host,User from user where User='root';
#输出一下信息
+-----------+------+
| Host      | User |
+-----------+------+
| %         | root |
| localhost | root |
+-----------+------+
#如果 没有 | %         | root | 执行
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的新密码' WITH GRANT OPTION;

6.用远程客户端链接

​ 图1-2

成功如图1-2

如果链接不上，看下防火墙3309有没有开，

若果是阿里云或者腾讯云看看安全组端口3309有没有放开

7.参考文档

https://hub.docker.com/_/mysql

https://github.com/docker-lib...

8.卸载

docker rm -f  mysql5.7.30

9.后会有期之 docker-compose mysql主从，kubernetes(k8s) mysql 主从

转载自：https://mp.weixin.qq.com/s/by...