mariadb安装配置

1. 创建/etc/yum.repos.d/MariaDB.repo文件

添加如下：

[mariadb]
name = MariaDB
baseurl = https://mirrors.ustc.edu.cn/mariadb/yum/10.2/centos7-amd64
gpgkey=https://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1

2. 使用yum来安装

 yum install MariaDB-server MariaDB-client

3. 启动服务

service mysql start

4. 设置ROOT密码

mysqladmin -u root password 123456

5. 登陆mysql

mysql -uroot -p123456

6. 授权root远程登录

root可从任何IP登陆，注意修改密码:'123456' 

添加用户：

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;