Mysql command line tricks
I couldn’t get just mysql to work on my slicehost, but if I typed the following i was in:
mysql -u username -p # this will then prompt you for the password
Then I typed help for a list of commands
mysql> help
Then I used some of the commands from my this mysql cheat sheet.
I did:
SHOW DATABASES;
There was only the information_schema table so I created a new one.
CREATE DATABASE db_name;
Then I selected that database to view its internals (nothing is in there of course until I run cap deploy:migrations on my app)
USE db_name;
