创建用户分配权限

CREATE USER ‘bill‘@‘%‘ IDENTIFIED BY ‘passpass‘;

 grant all privileges on *.* to bill@localhost identified by ‘passpass‘ with grant option;

Access denied for user 'bill'@'localhost' (using password: YES)