实验笔记2——mariadb添加新数据库和新用户

# 创建数据库
create database if not exists db_name
default character set utf8; 

# 创建新用户 
create user if not exists user_name  
identified by 'password123'; 

# 赋予权限 
grant all privileges on db_name.* to user_name;

参考文章:
1.http://c.biancheng.net/view/2413.html
2.https://blog.csdn.net/yegaomin/article/details/79669948

posted @ 2021-06-04 09:56  叶落未落  阅读(162)  评论(0)    收藏  举报