1、首先下载mysql仓库,直接使用yun install mysql 这个时候不会安装mysql,而是安装maridb数据库,
wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm
2、安装仓库,这个是安装仓库不是安装mysql,还没有到安装MySQL的时候
yum install mysql80-community-release-el8-1.noarch.rpm -y
3、修改vim /etc/yum.repos.d/mysql-community.repo 将文件中Community Server 的 8.0 给成 5.7
[mysql80-community] name=MySQL 8.0 Community Server baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/8/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 或者在这个下面添加下面这几行,将上面的8.0中 enabled=1 给成 0 不安装8.0 [mysql57-community] name=MySQL 5.7 Community Server baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
4、安装MySQL 8.0
yum install mysql-server -y
5、启动mysql服务 :systemctl start mysqld
6、登入mysql: mysql -uroot -p 第一次登入密码为空
7、登入进去以后修改密码:alter user root@localhost identified with mysql_native_password by '这里是密码';
8、使用修改后的密码登入,
9、创建新用户:create user '用户名'@'%' identified with mysql_native_password by '密码';
10、授权用户运城登录:grant all privileges on *.* to '用户'@'%' with grant option;
11、刷新策略:flush privileges;
12、完成了,直接远程登录