--安装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安全组规则;