# 搜索的作用: 显示可安装程序包
yum search mariadb
#安装
yum install -y mariadb mariadb-server
#启动服务 3306 端口
systemctl start mariadb
systemctl stop mariadb
#查看端口号是否被占用
netstat -nap | grep 3306
#登录数据库 mysql -u root -p # 按两下回车,跳过密码
# 显示所有数据库
show databases;
# 使用数据库
use mysql;
#配置密码
update user set password=password('123456') where user='root';
#激活密码
flush privileges;
#退出
quit;
#设置开机自动启动
systemctl enable mariadb
#关闭开机启动
systemctl disable mariadb
#如果主机连接Linux数据库失败
#执行两条命令 添加两个用户
MariaDB [mysql]> grant all privileges on *.* to root@"%" identified by "123456"; MariaDB [mysql]> grant all privileges on *.* to root@"127.0.0.1" identified by "123456"; MariaDB [mysql]> flush privileges;
重启