创建用户

create user username@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 username@localhost;