Centos7 安装/卸载mysql 5.7
目录:
1.安装
2.卸载
1.安装:
注:
卸载MariaDB
[root@cluster03 logs]# rpm -qa | grep mariadb
mariadb-libs-5.5.64-1.el7.x86_64
[root@cluster03 logs]# rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64
step1:下载mysql源安装包:
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
step2:安装mysql源:
yum localinstall mysql57-community-release-el7-8.noarch.rpm
- 执行完成后会在/etc/yum.repos.d/目录下生成两个repo文件
- mysql-community.repo
- mysql-community-source.repo
[root@cluster02 yum.repos.d]#yum localinstall mysql57-community-release-el7-8.noarch.rpm
[root@cluster02 installPage]# cd /etc/yum.repos.d/
[root@cluster02 yum.repos.d]# ll
total 16
-rw-r--r-- 1 root root 675 Mar 1 21:37 CentOS-Base.repo
-rw-r--r-- 1 root root 230 Mar 1 21:37 epel.repo
-rw-r--r-- 1 root root 1222 Mar 23 2016 mysql-community.repo
-rw-r--r-- 1 root root 1236 Mar 23 2016 mysql-community-source.repo
step3:检测是否安装完成:
yum repolist enabled | grep "mysql.*-community.*"
step4:安装mysql:
yum install mysql-community-server
step5:启动mysql服务:
systemctl restart mysqld
step6:查看mysql初始密码:
- 如果过去不到临时密码:
- rm -rf /var/lib/mysql 删除原来安装过的mysql残留的数据
- systemctl start mysqld 重启
- 重新获取
grep 'A temporary password' /var/log/mysqld.log
step7:登录:
mysqladmin -u root -p'获取的密码'
step8:更改mysql密码: 报错
- 原因:密码设置时必须包含大小写字母、特殊符号、数字,并且长度大于8位
mysql> set password = '123456' ;
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+-------+
| Variable_name | Value |
+--------------------------------------+-------+
| validate_password_check_user_name | OFF |
| validate_password_dictionary_file | |
| validate_password_length | 8 |
| validate_password_mixed_case_count | 1 |
| validate_password_number_count | 1 |
| validate_password_policy | MEDIUM|
| validate_password_special_char_count | 1 |
+--------------------------------------+-------+
7 rows in set (0.03 sec)
step9:修改密码强度校验等级
- set global validate_password_policy=LOW;
mysql> set global validate_password_policy=LOW;
Query OK, 0 rows affected (0.00 sec)
mysql> set password='123456';
Query OK, 0 rows affected (0.00 sec)
step10:开启远程登录,授权root远程登录
- GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘远程登录免密’ WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)
step11:命令立即执行生效
- flush privileges;
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
step12:设置开启启动mysql服务:
- systemctl enable mysqld 开机自启
- systemctl disable mysqld 取消开机自启
[root@cluster01 yum.repos.d]# systemctl enable mysqld
2.卸载
step1: 查看mysql 安装
- rpm -qa|grep -i mysql
[root@cluster01 yum.repos.d]# rpm -qa|grep -i mysql
mysql-community-common-5.7.29-1.el7.x86_64
mysql-community-client-5.7.29-1.el7.x86_64
mysql57-community-release-el7-8.noarch
mysql-community-libs-5.7.29-1.el7.x86_64
mysql-community-server-5.7.29-1.el7.x86_64
step2: 卸载mysql
- rpm -ev --nodeps
- 卸载前要先关闭mysql 服务
[root@cluster01 yum.repos.d]# rpm -ev --nodeps mysql-community-common-5.7.29-1.el7.x86_64
[root@cluster01 yum.repos.d]# rpm -ev --nodeps mysql-community-client-5.7.29-1.el7.x86_64
[root@cluster01 yum.repos.d]# rpm -ev --nodeps mysql57-community-release-el7-8.noarch
[root@cluster01 yum.repos.d]# rpm -ev --nodeps mysql-community-libs-5.7.29-1.el7.x86_64
[root@cluster01 yum.repos.d]# rpm -ev --nodeps mysql-community-server-5.7.29-1.el7.x86_64
step3: 再次查看
[root@cluster01 yum.repos.d]# rpm -qa|grep -i mysql
step5: 删除与mysql 相关的文件
- find / -name mysql
[root@cluster01 yum.repos.d]# find / -name mysql
/usr/share/mysql
/usr/lib64/mysql
[root@cluster01 yum.repos.d]# rm -rf /usr/share/mysql
[root@cluster01 yum.repos.d]# rm -rf /usr/lib64/mysql
[root@cluster01 yum.repos.d]# find / -name mysql
[root@cluster01 yum.repos.d]#