#命令行进去
#删除本机自带的mariadb(也可使用自带yum、apt卸载,注意卸载干净不然会报错,服务器一般是yum,终端是apt,总之就是删干净,默认账号密码我没查到)
rpm -e mariadb-libs-5.5.64-1.el7.aarch64 --nodeps
#下载mysql-8.0.27安装包
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.27-1.el7.aarch64.rpm-bundle.tar
#解压安装包,并依次安装,顺序别错
tar xvf mysql-8.0.27-1.el7.aarch64.rpm-bundle.tar
rpm -ivh mysql-community-common-8.0.27-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.27-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-libs-compat-8.0.27-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.27-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-client-plugins-8.0.27-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.27-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-devel-8.0.27-1.el7.aarch64.rpm --nodeps --force
rpm -ivh mysql-community-embedded-compat-8.0.27-1.el7.aarch64.rpm --nodeps --force
#初始化数据库,初始化失败可能会提示缺少包,缺少下载以下的包
mysqld --initialize;
#下载缺少银河麒麟V10缺少的包并安装(银河麒麟基本都缺这个包,且官方镜像没有)
wget https://mirrors.sohu.com/centos/8/AppStream/aarch64/os/Packages/compat-openssl10-1.0.2o-3.el8.aarch64.rpm
rpm -ivh compat-openssl10-1.0.2o-3.el8.aarch64.rpm
#给对应文件夹授权
chmod -R 777 /var/lib/mysql
#后面就是启动数据库和数据库配置
systemctl start mysqld
/

compat-openssl10-1.0.2o-3.el8.aarch64.rpm用wget就行。
/

开启远程登录

1.登录MySQL执行以下命令

mysql>use mysql;#选择MySQL用户表
mysql>update user set host = '%' where user = 'root';#把本地登录localhost改为%
mysql>select host, user, plugin from user;#查询修改是否成功

这里需要修改才可以远程访问

update user set plugin = 'mysql_native_password' where user = 'root';

修改修改后再修改一下密码

mysql> use mysql; #选择用户表
mysql> update user set authentication_string='' where user='root';#将字段置为空
mysql> flush privileges ;
ALTER user 'root'@'%' IDENTIFIED BY '123456';#把root和%的修改密码改为123456
mysql> quit;

执行ALTER user ‘root’@’%’ IDENTIFIED BY '123456’主要是把%的密码改为123456

原文链接:https://blog.csdn.net/m0_46683544/article/details/121807771

原文链接:https://blog.csdn.net/weixin_42429578/article/details/125486570

 

Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐