麒麟V10操作系统安装mysql8
mysql8下载
https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-8.0/
选择mysql-8.0.28-1.el7.aarch64.rpm-bundle.tar
解压
tar -xvf mysql-8.0.28-1.el7.aarch64.rpm-bundle.tar
查询之前是否有安装过,并且将其卸载,防止我们后续安装冲突
rpm -qa | grep mariadb
如果有记录则卸载
卸载yum remove mariadb-libs-5.5.68-1.el7.aarch64
接下来按序安装解压出来的包(按照如下顺序安装)
如果安装不上,则后面加上--nodeps --force强制安装
rpm -ivh mysql-community-common-8.0.28-1.el7.aarch64.rpm
rpm -ivh mysql-community-client-plugins-8.0.28-1.el7.aarch64.rpm
rpm -ivh mysql-community-libs-8.0.28-1.el7.aarch64.rpm
rpm -ivh mysql-community-client-8.0.28-1.el7.aarch64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.28-1.el7.aarch64.rpm
rpm -ivh mysql-community-server-8.0.28-1.el7.aarch64.rpm
初始化数据库
mysqld --initialize --console
新系统会按如下错误:
报错mysqld: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory
原因是缺少银河麒麟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
#后面就是启动数据库和数据库配置
安装的mysql路径在/var/lib/mysql下
给该目录赋权
chown -R mysql:mysql /var/lib/mysql/
chown -R mysql:mysql /var/log/mysqld.log
启动mysql
systemctl start mysqld
# 设置mysql为开机自启,如不需要可跳过,但是每次启动虚拟机都需要再启动mysql
systemctl enable mysqld
查看mysql状态
systemctl status mysqld
查看自动生成的密码
cat /var/log/mysqld.log | grep root
root@localhost: %d=&.mXaa5H)
用这个密码登陆mysql (可以直接复制登陆)
mysql -u root -p
重置密码
alter user 'root'@'localhost' identified by '123456';
将root账号的连接host设置为全部,否则只能本地连接
use mysql;
update user set host = "%" where user='root';
# 刷新权限
flush privileges;