1. 数据库软件安装与配置
server 主机安装 mariadb 服务器软件并实现远程登录数据库;
安装:
yum install mariadb-server -y
开启服务:
systemctl start mariadb
systemctl enable mariadb
配置远程登录:
mysql_secure_installation # 设置本地密码
systemctl stop firewalld.service # 关火墙
systemctl disable firewalld.service
mysql -uroot -p # 进入数据库
grant all privileges on *.* to root@'172.25.254.68'
identified by 'westos';
# 允许172.25.254.68使用root用户登陆数据库,密码为westos
<