欧拉系统版本

Linux version 4.18.0-147.5.2.1.h579.eulerosv2r10.x86_64 (abuild@szxrtosci10000) (gcc version 7.3.0 (GCC)) #1 SMP Sat Jul 31 09:58:46 UTC 2021

ps：当前版本应该是基于centos 8的，所以下载rpm包的时候，使用基于centos 8 的软件包即可

安装Mysql

下载地址列表：https://dev.mysql.com/downloads/mysql/

创建mysql文件夹，并将下载的文件拷贝到mysql中，并解压出来

按照顺序安装

rpm -ivh mysql-community-common-8.0.28-1.el8.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.28-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.28-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-8.0.28-1.el8.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.28-1.el8.x86_64.rpm
rpm -ivh mysql-community-server-8.0.28-1.el8.x86_64.rpm

安装好后，初始化

mysqld --initialize --user=mysql

自启动

systemctl enable mysqld
systemctl start mysqld

连接，并修改root密码

查看root密码

sudo grep 'temporary password' /var/log/mysqld.log

修改密码

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY '填写密码';

创建用户并授权

CREATE USER 'linewell'@'%' IDENTIFIED BY '填写密码';
grant all privileges on 数据库名称.* to linewell@'%';
flush privileges;

其他

授权所有数据库

grant all privileges on *.* to linewell@'%';

设置root的访问范围

update user set Host='%' where User = 'root';
flush privileges;