openeuler安装mariadb数据库

yum cleanall
yum makecache

yum install mariadb-server

systemctl enable --now mariadb.service   启动服务
systemctl status mariadb.service         查看状态

mysql_secure_installation
初始化Mysql根据自己需求填y|n

alter user root@localhost identified by 'lee';#修改root用户
CREATE USER lee@'%' identified by 'lee';#增加用户
CREATE DATABASE bbs;#创建数据库
GRANT ALL ON bbs.* TO lee@'%';#为lee用户增加对bbs权限
SHOW GRANTS FOR lee@'%';#查看权限
show grants for lee@'%"#数据库里面没有大小写区分
select user,host from mysql.user;#查看用户表