Start MySQL as root (you need a root password to do this):
a. Enter:
>mysql -u root -p
b. Enter your password, then <RETURN>
Create OLD database called ‘old’:
>create database old;
Add user to Mysql named ‘old’ with password ‘old’:
b. While logged into MySQL as root, enter:
>CREATE USER 'old'@'localhost‘ IDENTIFIED BY ‘old’;
Give ‘old’ user permission to work with ‘old’ database:
>GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON old.* TO 'old'@'localhost‘;
Exit MySQL:
>quit;
Make sure ‘old’ user works:
a. Enter:
>mysql -u old -p
b. Enter ‘old’ as password, then <RETURN>
c. View databases:
>show databases;
d. After the above command, you should see a table of databases (probably just two will be in there) and one will be called ‘old’