一创建用户并设定密码
create user xiaozhang identified by 'abc123';
二给新建用户授予相应的数据库及操作数据库的权限
grant select,insert,update,delete on test1.* to xiaozhang;
一创建用户并设定密码
create user xiaozhang identified by 'abc123';
二给新建用户授予相应的数据库及操作数据库的权限
grant select,insert,update,delete on test1.* to xiaozhang;