MySQL的 安装、配置、卸载

[root@master ~]# wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
[root@master ~]# yum -y install mysql57-community-release-el7-9.noarch.rpm
[root@master ~]# cd /etc/yum.repos.d/
[root@master ~]# yum -y install mysql-server

[root@master ~]# systemctil start mysqld

[root@master ~]# grep 'passowrd' /var/log/mysql.log
 
--显示的 root@localhost: ***就是初始化的数据库登录密码

[root@master ~]# mysql -uroot -p
[root@master ~]# password:

mysql> set password for 用户名@localhost = password('新密码');

mysql> show variables like 'validate_password%';

mysql> set global validate_password_policy=LOW;

mysql> set global validate_password_length=6;

mysql> set password for 'root'@'localhost' = password('bigdata');

mysql> grant all privileges on *.* to 'root'@'%' identified by 'bigdata' with grant option;mysql> flush privileges;

[root@master ~]# rpm -qa |grep -i mysql
mysql57-community-release-el7-9.noarch
mysql-community-client-5.7.32-1.el7.x86_64
mysql-community-libs-5.7.32-1.el7.x86_64
mysql-community-libs-compat-5.7.32-1.el7.x86_64
mysql-community-common-5.7.32-1.el7.x86_64
mysql-community-server-5.7.32-1.el7.x86_64

[root@master ~]# yum remove mysql57-community-release-el7-9.noarch
[root@master ~]# yum remove mysql-community-client-5.7.32-1.el7.x86_64
[root@master ~]# yum remove mysql-community-libs-5.7.32-1.el7.x86_64
[root@master ~]# yum remove mysql-community-libs-compat-5.7.32-1.el7.x86_64
[root@master ~]# yum remove mysql-community-common-5.7.32-1.el7.x86_64
[root@master ~]# yum remove mysql-community-server-5.7.32-1.el7.x86_64

[root@master ~]# find / -name mysql
/etc/selinux/targeted/active/modules/100/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/share/mysql

[root@master ~]# rm -rf /etc/selinux/targeted/active/modules/100/mysql
[root@master ~]# rm -rf /var/lib/mysql
[root@master ~]# rm -rf /var/lib/mysql/mysql
[root@master ~]# rm -rf /usr/share/mysql

[root@master ~]# rm -rf /var/log/mysqld.log
--如果不删除这个文件，会导致新安装的mysql无法生存新密码，造成无法登陆mysql