mysql 安裝過程記錄

mysql 本地rpm包安裝

1.首先解除安裝centos7中自帶的mariadb
    rpm -qa|grep mariadb //查詢出來已安裝的mariadb
    rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64 //解除安裝mariadb,檔案名為上述指令查詢出來的檔案
2.解除安裝舊版本的Mysql
    rpm -qa | grep -i mysql //查找
    rpm -e  mysql80-community-release-el7-3.noarch //删除
3.删除mysql分散的檔案夾
    whereis mysql                             //查出相應的mysql檔案夾，也可以用find / -name *mysql*                   
    rm -rf /use/lib/mysql      //删除

    find / -name mysql
    rm -rf /etc/selinux/targeted/active/modules/100/mysql
4.安裝（下載下傳好的rpm包本地安裝）
    1. 解壓 mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar
        tar -xvf mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

            mysql-community-client-8.0.19-1.el7.x86_64.rpm
        mysql-community-common-8.0.19-1.el7.x86_64.rpm
        mysql-community-devel-8.0.19-1.el7.x86_64.rpm
        mysql-community-embedded-compat-8.0.19-1.el7.x86_64.rpm
        mysql-community-libs-8.0.19-1.el7.x86_64.rpm
        mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm
        mysql-community-server-8.0.19-1.el7.x86_64.rpm
        mysql-community-test-8.0.19-1.el7.x86_64.rpm
    2. 按照下面的順序安裝        
        rpm -ivh mysql-community-common-8.0.19-1.el7.x86_64.rpm
        rpm -ivh mysql-community-libs-8.0.19-1.el7.x86_64.rpm
        rpm -ivh mysql-community-client-8.0.19-1.el7.x86_64.rpm
        rpm -ivh mysql-community-server-8.0.19-1.el7.x86_64.rpm 

5.初始化執行個體
    1.修改配置檔案 /etc/my.cnf

    [mysqld]
    datadir=/data/mysql/3307/data
    2.建立 /data/mysql/3307 目錄, 修改權限 chown mysql.mysql  /data/mysql/3307

    3.初始化 
        mysqld --initialize --user=mysql   
        其中 --user=mysql 指 用mysql使用者進行初始化
    4.啟動
        mysqld --user=mysql &
    5.連接配接
        mysql -uroot  -p
        密碼在log-error中找
    6修改root的密碼
        ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

        create user 'root'@'%' identified by 'root';
        grant all privileges on *.* to 'root'@'%' with grant option;
        flush privileges;            
    現在可以遠端登入了。