MySQL Cheat Sheet - Create new user, give user permissions, MySQL Import, MySQL Export

Create Database create database microsoftaccess;

Create User create user ‘chairthrower’@’localhost’ identified by ‘welcome1’;

Grant Permissions grant all on microsoftaccess.* to ‘chairthrower’@’localhost’;

Export mysqldump -u root -p microsoftaccess > microsoftaccess.sql

Import mysql -u root -p microsoftaccess < microsoftaccess.sql