Cenos7 安装、卸载 MySql5.7

Cenos7 安装、卸载 MySql5.7

1.删除系统已经存在的Mysql

    1.1 查看当前安装Mysql情况
        rpm -qa | grep -i mysql
    1.2 删除当前依赖
        rpm -ev --nodeps [安装的依赖]  删除上次命令查出的依赖 直接替换 []
    1.3 查看Mysql安装的目录
        find / -name mysql
    1.4 删除安装目录
        rm -rf [目录]
    1.5 删除 /etc/my.cnf
        rm -rf /etc/my.cnf
    1.6 再次查看Mysql是否存在
        rpm -qa | grep -i mysql

2.安装Mysql

    2.1 从官网下载tar包
        wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
    2.2 解压
        tar -zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
    2.3 移动到 /usr/local
        mv mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local
    2.4 重命名
        cd /usr/local
        mv mysql-5.7.22-linux-glibc2.12-x86_64 /usr/local mysql
    2.5 创建 /usr/local/mysql/data目录
        mkdir /usr/local/mysql/data
    2.6 新建mysl用户组和用户
        groupadd mysql
        useradd mysql -g mysql
    2.7 将mysql目录的用户权限改为mysql
        chown -R mysql.mysql /usr/local/mysql
    2.8 配置
        /usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data
     ##报错执行
     yum install -y libaio
     yum -y install numactl
        
    2.9 新增 /etc/my.cnf
    ```shell
        [mysqld]
        datadir=/usr/local/mysql/data
        basedir=/usr/local/mysql
        socket=/tmp/mysql.sock
        user=mysql
        port=3306
        character-set-server=utf8
        # 取消密码验证
        skip-grant-tables
        # Disabling symbolic-links is recommended to prevent assorted security risks
        symbolic-links=0
        # skip-grant-tables
        [mysqld_safe]
        log-error=/var/log/mysqld.log
        pid-file=/var/run/mysqld/mysqld.pid
    ```
    2.10 开启服务
        # 将mysql加入服务
        cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql  
        # 开机自启
        chkconfig mysql on
        # 启动mysql
        service mysql start

    2.11 将Mysql命令添加到 /usr/bin
        ln -s /usr/local/mysql/bin/mysql /usr/bin
    2.12 登录mysql设置密码 [设置了忽略密码直接跳过]
        mysql -uroot -p
        >> use mysql;
        # 修改密码
        >> update user set authentication_string=password('123456') where user='root';
        >> exit;
    2.12删除配置中的跳过密码验证
        vi /etc/my.cnf
        注销 # skip-grant-tables
    2.13 重启mysql服务
        service mysql restart
    2.14 登录再次设置密码（不知道为啥如果不再次设置密码就操作不了数据库了）
        mysql -u root -p
        >>ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
        >>exit;
    2.15 允许远程连接   
        mysql -u root -p
        >>use mysql;
        >>update user set host='%' where user = 'root';
        >>flush privileges;
        >>eixt;

参考：怎样从Mysql官网下载mysql.tar.gz版本的安装包