你好呀，我的老朋友！我是老寇，欢迎来到老寇IoT云平台！

ARM64

1.查看系统版本

# 查看Linux版本
cat /etc/os-release
# 查看系统架构（aarch64）
uname -m

2.解压文件

cd /home/a
# 切换管理员账号
sudo su -
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-9.6.0-linux-glibc2.28-aarch64.tar.xz
# 解压
tar -xvf mysql-9.6.0-linux-glibc2.28-aarch64.tar.xz
mv mysql-9.6.0-linux-glibc2.28-aarch64 mysql9
mv mysql9 /usr/local
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
mkdir -p /var/mysql9/data
chown -R mysql:mysql /var/mysql9/data
chown -R mysql:mysql /usr/local/mysql9*

3.初始化Mysql

# 初始化数据库
cd /usr/local/mysql9
# 检查缺失依赖
ldd /usr/local/mysql9/bin/mysqld | grep "not found"
# 升级依赖
apt update
apt install -y libaio1
apt install -y libnuma1
# 查看
ldconfig -p | grep libaio
ldconfig -p | grep libnuma
# 注意修改mysql数据存储和mysql安装位置
bin/mysqld --initialize --user=mysql --lower_case_table_names=1 --basedir=/usr/local/mysql9 --datadir=/var/mysql9/data
# 查看控制台，找到类似这行日志，请保存密码
# [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: SdbVrR/dO3hM

4.配置Mysql

# 使用:wq!强制保存
vim /usr/local/mysql9/cnf/my.cnf

[client]
port = 3306
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
port = 3306

character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
init_connect = 'SET NAMES utf8mb4'

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
# 这里需要修改mysql数据存储位置
datadir = /var/mysql9/data
lower_case_table_names = 1
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

5.开机自启动Mysql

# 使用:wq!强制保存
vim /etc/systemd/system/mysql.service

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

[Service]
Type=simple

User=mysql
Group=mysql

ExecStart=/usr/local/mysql9/bin/mysqld \
    --defaults-file=/usr/local/mysql9/cnf/my.cnf

Restart=on-failure

LimitNOFILE=65535

[Install]
WantedBy=multi-user.target

systemctl daemon-reload
systemctl enable mysql
# 常用命令
systemctl start mysql
systemctl stop mysql
systemctl restart mysql
systemctl status mysql

6.设置Mysql密码和远程访问

# 输入保存的密码
/usr/local/mysql9/bin/mysql -uroot -p
# 创建用户（密码为123456）
CREATE USER 'root'@'%' IDENTIFIED BY '123456';
# 远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
# 刷新
FLUSH PRIVILEGES;

X86_64

1.查看系统版本

# 查看Linux版本
cat /etc/os-release
# 查看系统架构（x86_64）
uname -m

2.解压文件

cd /home/a
# 切换管理员账号
sudo su -
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-9.6.0-linux-glibc2.28-x86_64.tar.xz
# 解压
tar -xvf mysql-9.6.0-linux-glibc2.28-x86_64.tar.xz
mv mysql-9.6.0-linux-glibc2.28-x86_64 mysql9
mv mysql9 /usr/local
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
mkdir -p /var/mysql9/data
chown -R mysql:mysql /var/mysql9/data
chown -R mysql:mysql /usr/local/mysql9*

3.初始化Mysql

# 初始化数据库
cd /usr/local/mysql9
# 检查缺失依赖
ldd /usr/local/mysql9/bin/mysqld | grep "not found"
# 升级依赖
apt update
apt install -y libaio1
apt install -y libnuma1
# 查看
ldconfig -p | grep libaio
ldconfig -p | grep libnuma
# 注意修改mysql数据存储和mysql安装位置
bin/mysqld --initialize --user=mysql --lower_case_table_names=1 --basedir=/usr/local/mysql9 --datadir=/var/mysql9/data
# 查看控制台，找到类似这行日志，请保存密码
# [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: SdbVrR/dO3hM

4.配置Mysql

# 使用:wq!强制保存
vim /usr/local/mysql9/cnf/my.cnf

[client]
port = 3306
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
port = 3306

character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
init_connect = 'SET NAMES utf8mb4'

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
# 这里需要修改mysql数据存储位置
datadir = /var/mysql9/data
lower_case_table_names = 1
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

5.开机自启动Mysql

# 使用:wq!强制保存
vim /etc/systemd/system/mysql.service

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

[Service]
Type=simple

User=mysql
Group=mysql

ExecStart=/usr/local/mysql9/bin/mysqld \
    --defaults-file=/usr/local/mysql9/cnf/my.cnf

Restart=on-failure

LimitNOFILE=65535

[Install]
WantedBy=multi-user.target

systemctl daemon-reload
systemctl enable mysql
# 常用命令
systemctl start mysql
systemctl stop mysql
systemctl restart mysql
systemctl status mysql

6.设置Mysql密码和远程访问

# 输入保存的密码
/usr/local/mysql9/bin/mysql -uroot -p
# 创建用户（密码为123456）
CREATE USER 'root'@'%' IDENTIFIED BY '123456';
# 远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
# 刷新
FLUSH PRIVILEGES;

我是老寇，我们下次再见啦！