CentOS7 安装MariaDB

yum install mariadb mariadb-server

1	yum install mariadb mariadb-server

systemctl start mariadb   #启动mariadb
systemctl enable mariadb  #设置开机自启动
mysql_secure_installation #设置root密码等相关
mysql -uroot -p           #测试登录

systemctl start mariadb #启动mariadb

systemctl enable mariadb #设置开机自启动

mysql_secure_installation #设置root密码等相关

mysql -uroot -p #测试登录

创建远程用户

> GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

> flush privileges;

> GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

> flush privileges;