20170118-CentOS7安装Mariadb

--安装Mariadb --------------------------------------------------

 

1. CentOS 7.0 版本信息查看

cat /etc/redhat-release

 

2. 安装Mariadb

yum install mariadb* -y

 

--设置服务 --------------------------------------------------

 

1. 启动服务

systemctl start mariadb.service

1.停止服务

systemctl stop mariadb

1.重启服务

systemctl restart mariadb

 

2. 自启动服务

systemctl enable mariadb.service

 

3.连接服务（默认密码为空）

mysql -u root -p

 

--远程连接 Mariadb --------------------------------------------------

 

当远程连接提示Host is not allowed to connect to this MySQL server时：

show databases;

use mysql;

show tables;

select host, user,password from user;

update user set host = '%' where user = 'root';

update user set password=PASSWORD("1992jyl521621") where user="root" and host = '%' ;

update user set password=PASSWORD("root") where user="root" and host = '127.0.0.1' ;

FLUSH PRIVILEGES;

exit;

 

修改后需要重启；

 

注意配置阿里云ECS安全组规则；