ARM环境中编译安装mysql5.7.44数据库

发表于 分类于

ARM环境中编译安装mysql5.7.44数据库

编译环境准备

1
2
3
4
5
6
7
8
9
10
11
12
13
14
yum install -y cmake bison flex libaio-devel numactl-devel openssl-devel gcc gcc-c++ libtirpc-devel ncurses-devel

wget https://github.com/thkukuk/rpcsvc-proto/releases/download/v1.4/rpcsvc-proto-1.4.tar.gz
tar xf rpcsvc-proto-1.4.tar.gz
cd rpcsvc-proto-1.4
./configure
make
make install

下载指定的boost,5.7需要用到1.59.0这个版本，下载地址
https://sourceforge.net/projects/boost/files/boost/1.59.0/

cp boost_1_59_0.tar.gz /tmp/

解压安装包

1
tar xvf mysql-5.7.44.tar.gz

创建并进入编译目录

1
2
3
cd mysql-5.7.44
mkdir build
cd build

配置编译选项

1
2
3
4
5
6
7
8
9
10
11
12
cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
          -DMYSQL_DATADIR=/usr/local/mysql/data \
          -DSYSCONFDIR=/etc/mysql \
          -DWITH_MYISAM_STORAGE_ENGINE=1 \
          -DWITH_INNOBASE_STORAGE_ENGINE=1 \
          -DWITH_MEMORY_STORAGE_ENGINE=1 \
          -DWITH_READLINE=1 \
          -DENABLED_LOCAL_INFILE=1 \
          -DDEFAULT_CHARSET=utf8 \
          -DDEFAULT_COLLATION=utf8_general_ci \
          -DDOWNLOAD_BOOST=1 \
          -DWITH_BOOST=/tmp/

编译mysql

1
make -j$(nproc)

安装mysql

1
sudo make install

初始化数据库

1
sudo /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

初始化完成后有临时root密码，记得复制

配置目录权限(根据实际目录授权即可)

1
sudo chown -R mysql:mysql /var/lib/mysql

安全设置

1
sudo /usr/local/mysql/bin/mysql_secure_installation

启动mysql服务

1
2
cp mysql.server /etc/init.d/mysql.server
/etc/init.d/mysql.server start

修改root密码

1
ALTER USER 'root'@'localhost' IDENTIFIED BY 'XXXxxx';