由于鯤鵬的流行趨勢，嘗試基于arm的mysql安裝
網(wǎng)上很多教程缺斤少兩，總是差點(diǎn)意思，親測后總結(jié)一下內(nèi)容
此教程僅適用于mysql5版本贡定，大于mysql5版本不確保正確
下載地址為：https://obs.cn-north-4.myhuaweicloud.com/obs-mirror-ftp4/database/mysql-5.7.27-aarch64.tar.gz
1. 添加mysql用戶組和mysql用戶汹粤，用于隔離mysql進(jìn)程
[root@arm ~]# groupadd -r mysql && useradd -r -g mysql -s /sbin/nologin -M mysql
2.安裝依賴庫
[root@arm ~]# yum install -y libaio*
3. 下載解壓Mysql
[root@arm ~]# wget https://obs.cn-north-4.myhuaweicloud.com/obs-mirror-ftp4/database/mysql-5.7.27-aarch64.tar.gz
[root@arm ~]# tar xvf mysql-5.7.27-aarch64.tar.gz -C /usr/local/
4.配置Mysql
[root@arm ~]# mv /usr/local/mysql-5.7.27-aarch64 /usr/local/mysql
[root@arm ~]# mkdir -p /usr/local/mysql/logs
[root@arm ~]# chown -R mysql:mysql /usr/local/mysql
[root@arm ~]# ln -sf /usr/local/mysql/my.cnf /etc/my.cnf
[root@arm ~]# cp -rf /usr/local/mysql/extra/lib* /usr/lib64/
[root@arm ~]# mv /usr/lib64/libstdc++.so.6 /usr/lib64/libstdc++.so.6.old
[root@arm ~]# ln -s /usr/lib64/libstdc++.so.6.0.24 /usr/lib64/libstdc++.so.6
# 設(shè)置開機(jī)啟動
[root@arm ~]# cp -rf /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@arm ~]# chmod +x /etc/init.d/mysqld
[root@arm ~]# systemctl enable mysqld
5. 添加環(huán)境變量
[root@ecs-arm ~]# vi /etc/profile
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
[root@ecs-arm ~]# source /etc/profile
隨機(jī)密碼初始化登錄
# "–initialize"生成隨機(jī)密碼，在這里存儲在/usr/local/mysql/logs/mysql-error.log
[root@ecs-arm ~]# mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
[root@ecs-arm ~]# systemctl start mysqld
[root@ecs-arm ~]# systemctl status mysqld
# 查看隨機(jī)密碼
[root@ecs-arm ~]# cat /usr/local/mysql/logs/mysql-error.log | grep password
6.登錄mysql修改密碼(需要輸入隨機(jī)密碼)
[root@localhost /]#? mysql -u root -p
Enter password:
mysql>set password for root@localhost = password('NiDeMiMaPassWord'); ----注意最結(jié)束符分號一定要寫
7.開放遠(yuǎn)程連接
mysql>use mysql;
msyql>update user set user.Host='%' where user.User='root';
mysql>flush privileges;
————————————————
版權(quán)聲明：本文為CSDN博主「Gina虞」的原創(chuàng)文章背苦，遵循CC 4.0 BY-SA版權(quán)協(xié)議钳降，轉(zhuǎn)載請附上原文出處鏈接及本聲明铲觉。
原文鏈接：https://blog.csdn.net/weixin_34342860/article/details/113270975
