mysql新建用户授权指定的数据库

CREATE USER  hunan IDENTIFIED BY '123456';    -----创建用户hunan

GRANT ALL PRIVILEGES ON hunan.* TO 'hunan'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;   ----给用户hunan授权连接指定的数据库hunan
FLUSH PRIVILEGES;  -----刷新权限