create database db_name; create user 'username'@'localhost' identified by 'password'; grant all on db_name.* to 'username'@'localhost';