连接数据库
1.下载mariadb
yum install mariadb-server
2.确认下载
查询软件安装位置(linux根据功能不同放在不同的目录下)
[root@s2 ~]# rpm -ql mariadb-server
3.数据库启动
systemctl start mariadb (启动)
systemctl restart mariadb (重启)、
systemctl stop mariadb (关闭)
systemctl enable mariadb (设置开机自启)
systemctl disable mariadb (关闭开机自启)
4.初始化数据库
mysql_secure_installation
privilege 特权
5.进入数据库(测试数据库用户名和密码是否有效)
mysql -u root -p
6.数据库远程访问设置
查看3306端口是否打开
ss -lntp
7.权限设置
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
8.关闭防火墙
firewall-cmd –state (查看防火墙状态)
systemctl stop firewalld.service (手动关闭防火墙,start开启)
systemctl disable firewalld.service (告诉系统以后开机不启动防火墙,enable)
9.测试成功
查看lntp
netstat -lntp
查看进程文件
cd /var/run/mariadb/
ls
cat mariadb.pid
systemctl status mariadb