阿里云安装mysql、MariaDB

systemctl start mariadb  #启动MariaDB

systemctl stop mariadb  #停止MariaDB

systemctl restart mariadb  #重启MariaDB

systemctl enable mariadb  #设置开机启动

# 检查是否存在MariaDB,一般新的CentOS7.x默认存在。
rpm -qa | grep mariadb

# 安装
yum -y install mariadb mariadb-server

# 启动
systemctl start mariadb

# 自启
systemctl enable mariadb

# 密码
mysqladmin -u root password 'root'

# 本机连接
mysql -u root -p

# 支持远程连接

use mysql;

select user,host from user;

grant all  on test.* to root@'ip地址' identified by '密码'; 

flush privileges;

问题
Access denied for user ‘root’@‘localhost’ (using password: YES)

vim /etc/my.cnf

在[mysqld]下方加入skip-grant-tables

# 重启数据库
systemctl restart mariadb

# 无需输入密码直接回车
mysql -uroot -p 

use mysql;

# 修改密码 123位密码
grant all on *.* to root@'localhost' identified by '123';

exit;

# 把之前的skip-grant-tables注释掉
vim /etc/my.cnf 

# 重启数据库
systemctl restart mariadb

https://www.jianshu.com/p/38342db157a5
https://help.aliyun.com/document_detail/59086.html
https://www.shuzhiduo.com/A/mo5k02v2dw/