ARM64架構(gòu)下面安裝mysql5.7.22
MySQL下載地址為：
https://obs.cn-north-4.myhuaweicloud.com/obs-mirror-ftp4/database/mysql-5.7.27-aarch64.tar.gz
1. 添加mysql用戶組和mysql用戶，用于隔離mysql進(jìn)程
groupadd -r mysql && useradd -r -g mysql -s /sbin/nologin -M mysql
2.安裝依賴庫
yum install -y libaio*
3. 下載解壓Mysql
wget https://obs.cn-north-4.myhuaweicloud.com/obs-mirror-ftp4/database/mysql-5.7.27-aarch64.tar.gz
tar xvf mysql-5.7.27-aarch64.tar.gz -C /usr/local/
4.配置Mysql
mv /usr/local/mysql-5.7.27-aarch64 /usr/local/mysql
mkdir -p /usr/local/mysql/logs
chown -R mysql:mysql /usr/local/mysql
ln -sf /usr/local/mysql/my.cnf /etc/my.cnf
cp -rf /usr/local/mysql/extra/lib* /usr/lib64/
mv /usr/lib64/libstdc++.so.6 /usr/lib64/libstdc++.so.6.old
ln -s /usr/lib64/libstdc++.so.6.0.24 /usr/lib64/libstdc++.so.6
設(shè)置開機(jī)啟動
cp -rf /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
systemctl enable mysqld（報錯不影響）
5. 添加環(huán)境變量
vim /etc/profile
添加下面兩行代碼：
export MYSQL_HOME=/usr/local/mysql
export PATH=MYSQL_HOME/bin
source /etc/profile
- 初始化啟動mysql
開啟mysql
systemctl start mysqld
查看狀態(tài)
systemctl status mysqld
這里表示mysql已經(jīng)安裝成功了。
無密碼初始化登錄
mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
建立軟鏈接
ln -s /usr/local/mysql/bin/mysql /usr/bin
修改密碼
使用：mysql -u root 進(jìn)行登錄
mysql> use mysql;
Database changed
mysql> select User from user; #此處為查詢用戶命令
+-----------+
| User |
+-----------+
| ******* |
| mysql.sys |
| root |
+-----------+
3 rows in set (0.00 sec)
mysql> update user set password=password("*******") where user="*******"; #修改密碼報錯
ERROR 1054 (42S22): Unknown column 'password' in 'field list'
mysql> update mysql.user set authentication_string=password('*******') where user='*******'; #修改密碼成功
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> flush privileges; #立即生效
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
n>mysql -u ******* -p #以該用戶登錄成功.
Enter password: ********
…………………………
mysql>
導(dǎo)入數(shù)據(jù)
把上傳上去的sql導(dǎo)入到數(shù)據(jù)庫中
按照下面的三個步驟，快速導(dǎo)入這個sql文件
復(fù)制代碼代碼如下:
mysql>use yourdatabasename;
mysql>set names utf8;
mysql>source /tmp/database.sql;
然后屏幕上就會不斷的滾，最后提示導(dǎo)入成功。
最后，記得將database.sql刪除
