第一种:
create user 'username'@'localhost' identified by 'password';
create database devdb;
grant all privileges on devdb.* to 'username'@'password';
第二种:
create database devdb;
GRANT ALL PRIVILEGES ON devdb.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;