首先本人安装的是8.0.18版本,不同版本可能有些出入。
1、首先查看mariadb版本
rpm -qa | grep mariadb
2、卸载mariadb(例如我的是:mariadb-libs-5.5.44-2.el7.centos.x86_64 --nodeps)
rpm -e mariadb-libs-5.5.44-2.el7.centos.x86_64 --nodeps
3、安装wget
yum install wget -y
4、下载(若失效了。手动下载上传)
wget https://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar
5、安装tar工具(有就不需要安装)
yum install tar -y
6、解压
tar -xvf mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar
7、按顺序安装
必须安装(注意顺序)
rpm -ivh mysql-community-common-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.18-1.el7.x86_64.rpm
非必要安装(注意顺序)
rpm -ivh mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compa-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.18-1.el7.x86_64.rpm
8、初始化数据库
mysqld --initialize --console
9、目录授权,否则启动失败
chown -R mysql:mysql /var/lib/mysql/
10、启动msyql服务
systemctl start mysqld
11、查看msyql服务的状态
service mysqld status
12、查看初始化的root密码
grep "password" /var/log/mysqld.log
13、用临时密码登录数据库
mysql -uroot -p
14、修改密码(例如我的是改成123456)
alter user 'root'@'localhost' identified by '123456';
15、更改加密规则
alter user 'root'@'localhost' identified with mysql_native_password by '123456';
16、依次执行下列mysql命令 授权root账户远程连接(改表法)
show databases;
use mysql;
select host, user from user;
update user set host = '%' where user = 'root';
flush privileges;
exit;
17、防火墙添加mysql端口3306 放行
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
18、查看所有被放行的端口
firewall-cmd --list-ports
19、重启:
service mysqld restart
mysql -uroot -p
补充:查看编码
SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';
查看信息
status
PS:发博客,仅仅是当作学习的笔记~