Thank you very much "dvikan"! I sincerely appreciate it.
When you say "First make a password", are you referring to the password that I would type in when I do this "ssh root@IP-ADDRESS-HERE"? If so, I already have a password for that. Should I just go straight to: mysql -u root mysql -p
And just to use my own data here, would this be right:
mysql -u root mysql -p
CREATE DATABASE wpdb01;
CREATE USER 'wpdb01'@'localhost' IDENTIFIED BY 'blahblah';
GRANT ALL PRIVILEGES ON wpdb01.* TO 'wpdb01'@'localhost';
I have the username and database as the same name here and the password as "blahblah".