maridb数据库

发表于 更新于 分类于 

1
2
设置字符集为utf-8
创建用户赋予权限

maridb数据库常用命令

1) 设置字符集为utf-8

set global character_set_database = ‘utf8’;
set global character_set_server = ‘utf8’;

2) 创建用户赋予权限

CREATE USER ‘xxx‘@’%’ IDENTIFIED BY ‘xxx’;
grant all privileges on . to xxx@’%’ identified by ‘xxx’;

CREATE USER ‘nacos‘@’%’ IDENTIFIED BY ‘nacos’;
grant all privileges on . to nacos@’%’ identified by ‘nacos’;