CentOS7系統(tǒng)使用RPM安裝MySQL8.0

  1. 下載mysql的安裝包
    訪問mysql網站或者直接打開下載鏈接選擇需要的mysql版本下載,這里選擇mysql 8.0.20,如圖:

    也可以直接使用下面的命令下載:

    #下載mysql
    wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
    
  2. 安裝mysql

    #查看系統(tǒng)發(fā)行版本號
    cat /etc/redhat-release
    CentOS Linux release 7.8.2003 (Core)
    
    #解壓安裝包
    tar -zxvf mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
    #解壓后文件如下
    mysql-community-client-8.0.20-1.el7.x86_64.rpm
    mysql-community-common-8.0.20-1.el7.x86_64.rpm
    mysql-community-devel-8.0.20-1.el7.x86_64.rpm
    mysql-community-embedded-compat-8.0.20-1.el7.x86_64.rpm
    mysql-community-libs-8.0.20-1.el7.x86_64.rpm
    mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm
    mysql-community-server-8.0.20-1.el7.x86_64.rpm
    mysql-community-test-8.0.20-1.el7.x86_64.rpm
    #這里安裝client、common、devel、libs、server即可
    
    #使用rpm通過如下命令安裝所需軟件包
    rpm -ivh mysql-community-common-8.0.20-1.el7.x86_64.rpm
    rpm -ivh mysql-community-libs-8.0.20-1.el7.x86_64.rpm
    rpm -ivh mysql-community-client-8.0.20-1.el7.x86_64.rpm
    rpm -ivh mysql-community-server-8.0.20-1.el7.x86_64.rpm
    rpm -ivh mysql-community-devel-8.0.20-1.el7.x86_64.rpm
    
  3. 初始化并啟動mysql

    #初始化數據庫
    mysqld --initialize
    #設置mysql數據目錄所有者
    chown -R mysql:mysql /var/lib/mysql
    #開啟mysql服務
    systemctl start mysqld
    
  4. 登錄mysql并設置權限

    #查看mysql初始登錄密碼
    cat /var/log/mysqld.log | grep password
    2021-03-01T07:22:44.370984Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: wMrb1f_iqkKz
    
    #登錄mysql
    mysql -uroot -p
    
    #修改密碼
    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密碼';
    
    #遠程訪問授權
    create user 'root'@'%' identified with mysql_native_password by '密碼';
    grant all privileges on *.* to 'root'@'%' with grant option;
    flush privileges;
    
  5. 可視化工具兼容
    MySQL 8.0 和以前的版本加密規(guī)則不一樣,而現在的可視化工具只支持舊的加密方式,具體原因點這里,使用如下命令修改加密規(guī)則:

    ALTER USER 'root'@'localhost' IDENTIFIED BY '密碼' PASSWORD EXPIRE NEVER;
    flush privileges;
    
最后編輯于
?著作權歸作者所有,轉載或內容合作請聯系作者
【社區(qū)內容提示】社區(qū)部分內容疑似由AI輔助生成,瀏覽時請結合常識與多方信息審慎甄別。
平臺聲明:文章內容(如有圖片或視頻亦包括在內)由作者上傳并發(fā)布,文章內容僅代表作者本人觀點,簡書系信息發(fā)布平臺,僅提供信息存儲服務。

相關閱讀更多精彩內容

友情鏈接更多精彩內容