centos7.6数据库mariadb的安装

1.yum安装mariadb

[root@iZbp1f0336jwbproguysvxZ ~]# yum -y install mariadb-server

2.设计开机自启动，启动mariadb

[root@iZbp1f0336jwbproguysvxZ ~]#systemctl enable mariadb.service
[root@iZbp1f0336jwbproguysvxZ ~]# systemctl start mariadb.service

3.设置root登录密码，登录mariadb

[root@iZbp1f0336jwbproguysvxZ ~]# mysqladmin -uroot password 'dolphin2019'
[root@iZbp1f0336jwbproguysvxZ ~]# mysql -uroot -pdolphin2019

4.授权远程用户登录，刷新权限

MariaDB [(none)]> grant all privileges on *.* to 'dolphin'@'%' identified by '12345678';
MariaDB [(none)]> flush privileges;

5.远程连接成功