源码编译安装MySQL（银河麒麟v10 mips架构）

tar -zxvf mysql-boost-5.7.43.tar.gz
mkdir /opt/softapp/mysql-5.7.43/build
cd /opt/softapp/mysql-5.7.43/build

useradd -M -s /sbin/nologin -r mysql
mkdir -p /usr/local/mysql/data
mkdir -p /var/lib/mysql
touch /var/lib/mysql/mysql.sock
touch /var/lib/mysql/mysql_err.log
touch /var/lib/mysql/mysql.pid
touch /var/lib/mysql/mysql.log

cmake .. \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/etc \
-DMYSQL_DATADIR=/var/lib/mysql \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_SSL=system \
-DWITH_ZLIB=system \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLE_DOWNLOADS=1 \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_BOOST=/opt/softapp/mysql-5.7.43/boost/boost_1_59_0

make
sudo make install

cp  /etc/my.cnf  /etc/my.cnf.bak
>   /etc/my.cnf
vim /etc/my.cnf

[mysql]
default-character-set=utf8

[client]
socket=/var/lib/mysql/mysql.sock

[mysqld]
port=3306
user=mysql
general_log = 1
general_log_file= /var/lib/mysql/mysql.log
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
bind-address = 0.0.0.0
default_storage_engine = InnoDB
character-set-server=utf8
collation-server=utf8_general_ci
lower_case_table_names=1
autocommit=1
symbolic-links=0
skip-networking = 0
log-error=/var/lib/mysql/mysql_err.log
pid-file=/var/lib/mysql/mysql.pid

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

chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /var/lib/mysql

nohup /usr/local/mysql/bin/mysqld_safe --user=mysql &

/usr/local/mysql/bin/mysqladmin -u root -p shutdown

sudo vim /etc/systemd/system/mysqld.service

[Unit]
Description=MySQL Server
After=network.target

[Service]
Type=simple
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --user=mysql
ExecStop=/usr/local/mysql/bin/mysqladmin shutdown -u root -p
Restart=on-failure
PrivateTmp=true

[Install]
WantedBy=multi-user.target

chmod +x /etc/systemd/system/mysqld.service
systemctl enable mysqld.service

systemctl start mysqld

vim ~/.bashrc

# 添加的内容 
# MySQL configure
export PATH=$PATH:/usr/local/mysql/bin

# 生效
source ~/.bashrc

mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_password';
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;