安装mariadb以及允许远程访问

yum -y install mariadb-server mariadb

systemctl start mariadb

mysql

select * from mysql.user\G

grant all on *.* to 'root'@'%' identified by '123456'

update mysql.user set Grant_priv='Y' where Host='%'

delete from mysql.user where Host<>'%' or User<>'root'

quit

systemctl restart mariadb