linux centos7mysql安装和卸载

安装mysql

• 1.先查看是否已经安装了MySQL
  rpm -qa | grep mysql
  如果什么都没有显示就直接走向第2步，如果显示有过往版本，先去卸载(下方有卸载流程)在进行安装，以免安装失败
  官网最新mysql yum存储库：https://dev.mysql.com/downloads/repo/yum/
• 2.用 wget MySQL Yum 下载mysql5.7安装包命令
  wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
  如果使用命令后提示找不到wget时
  先 yum install wget 然后再执行命令
  wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
  
  显示Complete说明下载成功
• 3.安装mysql服务，依然使用yum 安装
  yum install mysql-community-server
  
  当出现Complete说明安装成功
• 4.启动 MySQL
  systemctl start mysqld
  
  ps查看一下，显示如上图说明启动成功。
• 5.设置开机启动 MySQL
  systemctl enable mysqld
  systemctl daemon-reload
• 6 . 安装mysql后会给root生成一个默认密码 查看默认密码命令
  grep ‘temporary password’ /var/log/mysqld.log
  
• 7 .登录MySQL mysql -u root -pIHuZa#Ux?5Pw(默认密码)
  登录成功
• 8 .修改密码 mysql 设置了密码安全检查插件，你的密码必须包含大小写英文，数字，字符且不小于8位,且必须以英文符号结尾
  set password for ‘root’@‘localhost’=password(‘Sunwukong6!’);

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

• 9 . 开启远程连接，修改root用户权限
  GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘Sunwukong6!’;
• 10 .刷新权限
  flush privileges;

卸载Mysql

rpm方式

• 1.查看安装 rpm -qa | grep -i mysql

[root@izbp1g3h4a24fo2ryurxt0z /]# rpm -qa | grep -i mysql
mysql-community-libs-compat-5.7.28-1.el7.x86_64
mysql57-community-release-el7-8.noarch
mysql-community-libs-5.7.28-1.el7.x86_64
mysql-community-client-5.7.28-1.el7.x86_64
mysql-community-server-5.7.28-1.el7.x86_64
mysql-community-common-5.7.28-1.el7.x86_64

• 2 卸载
  (1)

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

         (2)
进入 cd var/lib,删除mysql

[root@izbp1g3h4a24fo2ryurxt0z /]# cd var/lib

rm -rf mysql
         (3)清除mysql残留
whereis mysql

将这些都手动删除
         (4)删除配置

rm –rf /usr/my.cnf
rm -rf /root/.mysql_sercret