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;

Comments