mac book m1 arm mysql下载,ARM架构下面安装mysql5.7.

下载地址为：https://obs.cn-north-4.myhuaweicloud.com/obs-mirror-ftp4/database/mysql-5.7.27-aarch64.tar.gz

1. 添加mysql用户组和mysql用户，用于隔离mysql进程

[root@arm ~]# groupadd -r mysql && useradd -r -g mysql -s /sbin/nologin -M mysql

2.安装依赖库

[root@arm ~]# yum install -y libaio*

3. 下载解压Mysql

[root@arm ~]# wget https://obs.cn-north-4.myhuaweicloud.com/obs-mirror-ftp4/database/mysql-5.7.27-aarch64.tar.gz

[root@arm ~]# tar -xvf mysql-5.7.27-aarch64.tar.gz -C /usr/local/

4.配置Mysql

[root@arm ~]# mv /usr/local/mysql-5.7.27-aarch64 /usr/local/mysql

[root@arm ~]# mkdir -p /usr/local/mysql/logs

[root@arm ~]# chown -R mysql:mysql /usr/local/mysql

[root@arm ~]# ln -sf /usr/local/mysql/my.cnf /etc/my.cnf

[root@arm ~]# cp -rf /usr/local/mysql/extra/lib* /usr/lib/

# 设置开机启动

[root@arm ~]# cp -rf /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

[root@arm ~]# chmod +x /etc/init.d/mysqld

[root@arm ~]# systemctl enable mysqld

5. 添加环境变量

[root@ecs-arm ~]# vi /etc/profile

export MYSQL_HOME=/usr/local/mysql

export PATH=$PATH:$MYSQL_HOME/bin

[root@ecs-arm ~]# source /etc/profile

6. 初始化启动mysql

无密码初始化登录

-------------------------------

[root@ecs-arm ~]# mkdir /usr/local/mysql/data

[root@ecs-arm ~]# chown -R mysql:mysql /usr/local/mysql/data

[root@ecs-arm ~]# mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

[root@ecs-arm ~]# systemctl start mysqld

[root@ecs-arm ~]# systemctl status mysqld

7 设置数据库root的密码

[root@ecs-arm ~]# mysql_secure_installation

8  登陆mysql

[root@ecs-arm ~]#/usr/local/mysql/bin/mysql -u root -p

9 修改密码为toot

grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;

如果遇到如下问题：

“

输入语句 “ SHOW VARIABLES LIKE 'validate_password%'; ” 进行查看初始密码策略，

首先需要设置密码的验证强度等级，设置 validate_password_policy 的全局参数为 LOW 即可，

输入设值语句 “ set global validate_password_policy=LOW; ” 进行设值

当前密码长度为 8 ，如果不介意的话就不用修改了，按照通用的来讲，设置为 6 位的密码，设置 validate_password_length 的全局参数为 4 即可，

输入设值语句 “ set global validate_password_length=4; ” 进行设值，

然后重新设置root密码：

grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;

保存设置：

Flush privileges;

7,使用navicat，连接，用户名密码都为root,端口号为3306.

hive beeline连接时 User: xxxx is not allowed to impersonate xxxx

[main]: WARN jdbc.HiveConnection: Failed to connect to hadoop102:10000
Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: xxxx is not allowed to impersonate xxxx (state=08S01,code=0)
Beeline version 3.1.2 by Apache Hive
 

解决方案：

修改hive-site.xml

修改或添加如下配置

<property>
    <name>hive.server2.enable.doAs</name>
    <value>false</value>
  </property>
 

重新启动，再次连接就ok了

————————————————
版权声明：本文为CSDN博主「java路飞」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/qq_33129875/article/details/125363217