查询自带的mariadb
rpm -qa | grep mariadb
强制删除
rpm -e mariadb-connector-c-config-3.1.11-2.el8_3.noarch --nodeps
安装mysql
yum -y install mysql-server
初始化mysql
mysqld --initialize
授权防火墙
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
systemctl enable mysqld
查询数据库的初始化密码
cat /var/log/mysqld.log | grep password
修改mysql密码
alter user 'root'@'localhost' identified with mysql_native_password by 'rooths';
重新登录数据库
mysql -uroot -p
开启远程登录
create user 'root'@'%' identified with mysql_native_password by 'rooths';
让远程连接生效
grant all privileges on *.* to 'root'@'%' with grant option;
重载
flush privileges;
开放3306端口
fire-cmd --zone=public --add-port=3306/tcp --permanent
systemctl restart firewalld.service
firewall-cmd --reload
mysql安装默认使用的是美国的时区,北京时间比美国时间晚8个小时,所以设置数据库时区
set global time_zone='+8:00';