MariaDB-常用语法

# 新建用户并赋权超级管理员权限
GRANT ALL PRIVILEGES ON *.* TO 'ethan'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
# 新建数据库和用户并赋予数据库权限
CREATE DATABASE nextcloud;
GRANT ALL PRIVILEGES ON nextcloud.* TO 'nextcloud'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
# 查看当前用户权限
show grants;
# 查看指定用户权限
show grants for 'nextcloud'@'%';
# 修改密码
SET PASSWORD FOR 'nextcloud'@'%' = PASSWORD('123456');