CentOs7 安装卸载MySQL

Bertha 。 2021-09-18 09:26 466阅读 0赞

**MySQL安装**  
**一、下载并安装MySQL官方的 Yum Repository**

[root@localhost ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
    [root@localhost ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm
    [root@localhost ~]# yum -y install mysql-community-server

**二、数据库配置：**  
1、启动数据库

systemctl start  mysqld.service

2、查看MySQL运行状态，运行状态如图：

systemctl status mysqld.service

结果展示

[root@localhost ~]# systemctl start  mysqld.service
    [root@localhost ~]# systemctl status mysqld.service
    ● mysqld.service - MySQL Server
       Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
       Active: active (running) since 六 2019-03-02 11:19:53 CST; 6min ago
         Docs: man:mysqld(8)
               http://dev.mysql.com/doc/refman/en/using-systemd.html
      Process: 1317 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
      Process: 998 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
     Main PID: 1320 (mysqld)
       CGroup: /system.slice/mysqld.service
               └─1320 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
    
    3月 02 11:19:40 localhost.localdomain systemd[1]: Starting MySQL Server...
    3月 02 11:19:53 localhost.localdomain systemd[1]: Started MySQL Server.

3、打开`/etc/my.cnf`配置文件，在最后一行添加 skip-grant-tables

mysql -u root -p  // 免密码登录

4、重启数据库

systemctl start  mysqld.service

4、进入mysql 环境中，输入以下命令，更改mysql 登录密码

update mysql.user set authentication_string=password('123456') where user='root';

5、打开 /etc/my.cnf，去掉 skip-grant-tables，再次重启数据库

systemctl start  mysqld.service

6、再次登录时，即可使用新设置的密码

**MySQL 卸载**  
1、rpm查看安装

rpm -qa | grep -i mysql

如图所示：  
![在这里插入图片描述][20190302115036220.png]  
2、rpm 卸载

rpm -e mysql57-community-release-el7-9.noarch
    rpm -e mysql-community-server-5.7.17-1.el7.x86_64
    rpm -e mysql-community-libs-5.7.17-1.el7.x86_64
    rpm -e mysql-community-libs-compat-5.7.17-1.el7.x86_64
    rpm -e mysql-community-common-5.7.17-1.el7.x86_64
    rpm -e mysql-community-client-5.7.17-1.el7.x86_64
    cd /var/lib/  
    rm -rf mysql/

3、清除余项

whereis mysql
    mysql: /usr/bin/mysql /usr/lib64/mysql /usr/local/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
    #删除上面的文件夹
    rm -rf /usr/bin/mysql

4、删除配置

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

5、剩余配置检查

chkconfig --list | grep -i mysql
    chkconfig --del mysqld

6、根据上面的列表，删除 ,如：mysqld

[20190302115036220.png]: /images/20210913/703b5f72270341348b01595d079f614b.png