9de7bb31d0644e7393039222babfed10

上次記錄了docker安裝MySQL8， 本次演示安裝包的方式安裝MySQL8.

銀河麒麟v10sp2/sp1 鯤鵬服務器

#移除老版本mysql包yum remove mariadb#安裝8.x軟件包yum -y localinstall mysql-community-{server,client,common,libs,client-plugins,devel,icu-data-files}-8.0.31-1.el8.aarch64.rpmsystemctl --now enable mysqld#記錄下臨時產生的root密碼 ，登錄修改管理員密碼grep 'temporary password' /var/log/mysqld.log mysql -u root -p`grep 'temporary password' /var/log/mysqld.log|tail -1 |awk '{print $NF}'`set password='Root_1qaz'; 

redhat9安裝8.0.x

#關閉selinuxsed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config ; setenforce 0#安裝8.x軟件包yum -y localinstall mysql-community-{server,client,common,libs,devel,icu-data-files,client-plugins}-8.0.31-1.el9.x86_64.rpmsystemctl --now enable mysqld#記錄下臨時產生的root密碼 ，登錄修改管理員密碼grep 'temporary password' /var/log/mysqld.log mysql -u root -p`grep 'temporary password' /var/log/mysqld.log|tail -1 |awk '{print $NF}'`set password='Root_1qaz';

CentOS8/7安裝8.0.x

#關閉selinuxsed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config ; setenforce 0#移除老版本mysql包yum -y remove mariadb-libs#安裝8.x軟件包yum -y localinstall mysql-community-{server,client,common,libs,devel,libs-compat}-8.0.18-1.el*.x86_64.rpmsystemctl --now enable mysqld#記錄下臨時產生的root密碼 ，登錄修改管理員密碼grep 'temporary password' /var/log/mysqld.logmysql -u root -p`grep 'temporary password' /var/log/mysqld.log|tail -1 |awk '{print $NF}'`set password='Root_1qaz';

Oracle6.6 rpm 安裝8.0.18

#關閉selinuxsed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config ; setenforce 0#移除老版本mysql包yum -y remove mysql-libs-5.1.73#安裝8.x軟件包yum -y localinstall mysql-community-{server,client,common,libs,devel,libs-compat}-8.0.18-1.el6.x86_64.rpmservice mysqld start ; chkconfig mysqld on#記錄下臨時產生的root密碼 ，登錄修改管理員密碼grep 'temporary password' /var/log/mysqld.log mysql -u root -p`grep 'temporary password' /var/log/mysqld.log|tail -1 |awk '{print $NF}'`set password='Root_1qaz';

ubuntu18.04 安裝8.0.18

#安裝8.x軟件包 安裝過程中會提示輸入管理員密碼apt install ./mysql-{common,client,community-client-core,community-client,community-server-core,community-server,}_8.0.18-1ubuntu18.04_amd64.deb ./{libmysqlclient-dev,libmysqlclient21}_${v_p_a}.deb #安裝過程中會提示輸入密碼和選擇加密方式systemctl restart mysqlufw allow 3306 #允許3306端口通過防火墻

windows64 安裝8.0.18

#解壓 mysql-8.0.18-winx64.zip 到 C:\Program Files\MySQL,添加 C:\Program Files\MySQL\bin到path變量#新建 C:\Program Files\MySQL\my.ini 如下[mysqld]port=3306basedir=C:\Program Files\MySQLdatadir=C:\Program Files\MySQL\Datamax_connections=200max_connect_errors=10character-set-server=utf8mb4default-storage-engine=INNODBdefault_authentication_plugin=mysql_native_password[mysql]default-character-set=utf8mb4[client]port=3306default-character-set=utf8mb4#初始化MySQL,以管理員身份運行CMD進入mysql的bin目錄,執行mysqld --initialize --console #記錄下臨時產生的root密碼 #如果出現丟失 msvcp140.dll 需要安裝 mvc++2015-2019\VC_redist.x64.exe#安裝和啟動MySQL服務mysqld --install #修改服務的注冊表,HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\MySQL\ImagePath默認為 "C:\Program Files\MySQL\MySQL Server 8.0\mysqld" MySQL 修改 為 "C:\Program Files\MySQL\bin\mysqld" MySQL#啟動服務#啟動注意事項: 如果出現3523錯誤,檢查 my.ini 配置,在linux下末尾是不是有^M#建議:打開記事本新建一個空白文件粘貼內容并以 ansi 保存為 my.ini 不要先新建文件并在文件基礎上編輯#建議:設置操作系統顯示擴展名,曾經浪費很多時間,以為建立了 my.ini,其實建立的是 my.ini.txtnet start mysql#修改密碼,建議此處同時創建 root@'%'set password='Root_1qaz';FLUSH PRIVILEGES;#允許3306端口通過防火墻netsh advfirewall firewall add rule name="mysql" dir=in protocol=tcp localport=3306 action=allow

至此，軟件包安裝MySQL8就完成了。謝謝， 關注防丟失。9de7bb31d0644e7393039222babfed10