首先进入mysql 数据库;
use mysql
创建用户:
create user 'sds'@'localhost' identified by 'asdsdfas';
授予权限:
grant insert,delete,update,select,alter,create,create view,drop,execute,references on *.* to 'sds'@'localhost';
验证是否添加
select * from mysql.user\G
首先进入mysql 数据库;
use mysql
创建用户:
create user 'sds'@'localhost' identified by 'asdsdfas';
授予权限:
grant insert,delete,update,select,alter,create,create view,drop,execute,references on *.* to 'sds'@'localhost';
验证是否添加
select * from mysql.user\G