Create a db and a new user create database Database; GRANT ALL PRIVILEGES ON Database.* TO user@localhost IDENTIFIED BY 'pass' WITH GRANT OPTION; FLUSH PRIVILEGES;