CREATE USER 'cake'@'localhost' IDENTIFIED BY 'cake';
GRANT ALL PRIVILEGES ON * . * TO 'cake'@'localhost';


mysql -u username -p database_name < file.sql