1.我的操作系统

2.官网下载适合自己的版本

https://downloads.mysql.com/archives/community/

3.先删除自带MySQL和MariaDB,不管带没带,先删一遍

rpm -qa | grep mysql
rpm -qa | grep mariadb

然后根据获取的列表一个个删除 (我不会一块删除~) 

yum -y remove 上面出现的列表名

删除mysql相关目录

rm -rf /var/lib/mysql/
rm -rf /usr/lib64/mysql
rm -rf /etc/selinux/targeted/active/modules/100/mysql
rm -rf /etc/selinux/targeted/tmp/modules/100/mysql

删除my.cnf文件

rm -rf /etc/my.cnf

4.安装mysql

tar -xvf mysql-8.3.0-1.el8.aarch64.rpm-bundle.tar

解压后会出现一堆的包,然后按下面的命令安装(不需要全安装)

按顺序安装

rpm -ivh mysql-community-common-8.3.0-1.el8.aarch64.rpm
rpm -ivh mysql-community-client-plugins-8.3.0-1.el8.aarch64.rpm
rpm -ivh mysql-community-libs-8.3.0-1.el8.aarch64.rpm
rpm -ivh mysql-community-client-8.3.0-1.el8.aarch64.rpm
rpm -ivh mysql-community-icu-data-files-8.3.0-1.el8.aarch64.rpm
rpm -ivh mysql-community-server-8.3.0-1.el8.aarch64.rpm
rpm -ivh mysql-community-devel-8.3.0-1.el8.aarch64.rpm

查看是否安装完整

rpm -qa |grep mysql
 
mysql-community-client-8.3.0-1.el8.aarch64
mysql-community-server-8.3.0-1.el8.aarch64
mysql-community-client-plugins-8.3.0-1.el8.aarch64
mysql-community-icu-data-files-8.3.0-1.el8.aarch64
mysql-community-common-8.3.0-1.el8.aarch64
mysql-community-devel-8.3.0-1.el8.aarch64
mysql-community-libs-8.3.0-1.el8.aarch64

修改配置文件

vim /etc/my.cnf

在mysqld后一行补充:

lower_case_table_names=1

7.初始化数据库,需先进mysql安装目录的bin下面

mysqld --initialize --console

8.授权

chown -R mysql:mysql /var/lib/mysql/

9.启动mysql

systemctl status mysqld

激活状态Active显示为active,则表示启动成功

10.查看临时密码,然后复制出来

grep password /var/log/mysqld.log

11.使用上面的初始化密码登录MySQL        

mysql -uroot -p

用初始化密码登录MySQL后只能执行修改密码的操作,其他任何操作都是不可能的,使用以下命令修改密码:

alter user user() identified by 'Miles@123';

12.设置远程连接

CREATE USER 'root'@'%' IDENTIFIED BY '你的密码';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

13.用navcat连接正常,用sqlyong报如下错误时:

登录mysql

mysql -uroot -p

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';

然后在测试连接:

设置mysql开机自启动

查看MySQL服务是否开机自启动,enable表示开启,disable表示禁用

systemctl list-unit-files | grep mysqld.service 

禁用自启动

systemctl disable mysqld.service

启用自启动

systemctl enable mysqld.service

更多推荐