MySQL创建用户并授权

MySQL创建用户并授权SQL:

create user user@localhost
    identified by 'password';

grant alter, 
alter routine, 
create, 
create routine, 
create temporary tables,
create view, 
delete, 
drop, 
event, 
execute, 
grant option, 
index, 
insert, 
lock tables, 
references, 
select, 
show view, 
trigger, 
update on databasename.* to user@localhost;