在Arm架构ubuntu上源码安装MYSQL 稳定版
此方法在千里通arm架构linux小主机测试通过,理论上支持所有Arm架构linux,无需担心各种依赖问题等
#卸载系统里的mysql
apt-get remove --purge mysql* -y
groupadd -r mysql && useradd -r -g mysql -s /sbin/nologin -M mysql
#安装mysql依赖包
apt install -y libaio* libncurses5
#下载编译好的mysql5.7
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/
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
mkdir /usr/lib64
cp -rf /usr/local/mysql/extra/lib* /usr/lib64/
ln -s /usr/lib64/libstdc++.so.6.0.24 /usr/lib64/libstdc++.so.6
cat << EOF > /etc/my.cnf
[mysql]
default-character-set=utf8mb4
[client]
socket=/tmp/mysql.sock
[mysqld]
user=mysql
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
pid-file=/usr/local/mysql/data/mysql.pid
log-error=/usr/local/mysql/data/mysql.err
character-set-server=utf8mb4
collation-server=utf8mb4_bin
port = 3306
EOF
vim /etc/profile
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
source /etc/profile
上面有一些linux基础应该看懂的吧
#初始化mysql
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --explicit_defaults_for_timestamp=true
如果不显示密码 也可以vim /usr/local/mysql/data/mysql.err找到
这个命令执行完之后,会生成一个临时密码,在data文件夹下(路径/usr/local/mysql/data/mysql.err),冒号后面的就是密码
#启动服务尝试登录
cd /usr/local/mysql/support-files
./mysql.server start
mysql -uroot -p // 登录,此时会让你输入密码,输入刚才的临时密码
能登录成功说明配置OK

#开机启动
vim /lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
systemctl enable mysqld.service
systemctl start mysqld.service
