宁波网站建设公司推荐哪家_网站设计建设有限公司_公关公司的主要业务_百度总部电话

操作系统 麒麟 ARM 4.02  安装版本是 mysql-5.7.27-aarch64.tar.gz    高版本的安装不了，需要升级gcc等。

附送：mysql下载地址

1.将文件解压到/usr/local/目录下
tar -xvf  mysql-8.0.37-linux-glibc2.28-x86_64.tar.gz-C /usr/local

2.切换到/usr/local/目录，将mysql-8.0.37-linux-glibc2.28-x86_64重命名为mysql 
cd /usr/local
mv mysql-8.0.37-linux-glibc2.28-x86_64 mysql

3.切换到/usr/local/mysql目录，创建data文件夹，mysql用户组以及用户，重新设置mysql文件夹的文件所有者和文件关联组，修改文件夹权限 
切换到/usr/local/mysql目录，创建data文件夹

cd /usr/local/mysql

mkdir -p data 

 mysql用户组以及用户，重新设置mysql文件夹的文件所有者和文件关联组

groupadd mysql

useradd -r -g mysql mysql

 修改文件夹权限

cd /usr/local/

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

chmod -R 755 /usr/local/mysql

4.在/etc/目录下创建my.cnf文件，编辑内容如下 ：
[mysqld]
server_id=1001
datadir=/usr/local/mysql/data
basedir=/usr/local/mysql
socket=/usr/local/mysql/data/mysql.sock
user=mysql
port=3306
character-set-server=utf8
symbolic-links=0
[mysqld safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
port=3306
socket=/usr/local/mysql/data/mysql.sock

 5.初始化MySQL，保存生成的初始的初始密码
cd /usr/local/mysql/bin
./mysqld  --user=mysql  --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql  --initialize

root@Kylin:/usr/local/mysql/bin# !158
./mysqld --user=mysql --datadir=/usr/local/mysql/data/ --basedir=/usr/local/mysql --initialize
2025-01-03T06:04:34.885503Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2025-01-03T06:04:35.251853Z 0 [Warning] InnoDB: New log files created, LSN=45790
2025-01-03T06:04:35.320173Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2025-01-03T06:04:35.384587Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 9b8f49af-c998-11ef-9da0-00238135d21f.
2025-01-03T06:04:35.387325Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2025-01-03T06:04:35.388406Z 1 [Note] A temporary password is generated for root@localhost: ;apYDf;h6H8O

6.开启服务，设置开机自启动 
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld 
/usr/lib/systemd/systemd-sysv-install enable mysqld

7.添加环境变量，在/etc/profile文件末尾添加如下内容 
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin

如图：

8.生效 环境变量
source /etc/profile

9.开启MySQL服务，查看状态 
systemctl start mysqld
systemctl status mysqld

 10.登录数据库修改密码
mysql -uroot -p
alter user 'root'@'localhost' identified by 'root';
 

11.设置允许远程连接 
create user 'root'@'%' identified by 'root';  -- 创建用户
grant all privileges on *.* to 'root'@'%' ;   -- 授权
flush privileges;                             -- 刷新权限