Linux配置Mysql

查询自带的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';