9de7bb31d0644e7393039222babfed10

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

銀河麒麟v10sp2/sp1 鯤鵬服務(wù)器

#移除老版本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#記錄下臨時(shí)產(chǎn)生的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

#關(guān)閉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#記錄下臨時(shí)產(chǎn)生的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

#關(guān)閉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#記錄下臨時(shí)產(chǎn)生的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

#關(guān)閉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#記錄下臨時(shí)產(chǎn)生的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,以管理員身份運(yùn)行CMD進(jìn)入mysql的bin目錄,執(zhí)行mysqld --initialize --console #記錄下臨時(shí)產(chǎn)生的root密碼 #如果出現(xiàn)丟失 msvcp140.dll 需要安裝 mvc++2015-2019\VC_redist.x64.exe#安裝和啟動MySQL服務(wù)mysqld --install #修改服務(wù)的注冊表,HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\MySQL\ImagePath默認(rèn)為 "C:\Program Files\MySQL\MySQL Server 8.0\mysqld" MySQL 修改 為 "C:\Program Files\MySQL\bin\mysqld" MySQL#啟動服務(wù)#啟動注意事項(xiàng): 如果出現(xiàn)3523錯(cuò)誤,檢查 my.ini 配置,在linux下末尾是不是有^M#建議:打開記事本新建一個(gè)空白文件粘貼內(nèi)容并以 ansi 保存為 my.ini 不要先新建文件并在文件基礎(chǔ)上編輯#建議:設(shè)置操作系統(tǒng)顯示擴(kuò)展名,曾經(jīng)浪費(fèi)很多時(shí)間,以為建立了 my.ini,其實(shí)建立的是 my.ini.txtnet start mysql#修改密碼,建議此處同時(shí)創(chuàng)建 root@'%'set password='Root_1qaz';FLUSH PRIVILEGES;#允許3306端口通過防火墻netsh advfirewall firewall add rule name="mysql" dir=in protocol=tcp localport=3306 action=allow

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