mysql创建用户并赋予权限

create database db_name;

create user 'zhangsan'@'localhost'  identified by '123456';

grant all on db_name.* to 'zhangsan'@'localhost';