====== Command Line MySQL ====== \\ Here are a few useful MySQL commands you can run from the command line, handy if you have installed MySQL and you don't have desktop access or a graphical MySQL manager application. \\ \\ Login to MySQL First we must login \\ //**mysql -u root -p**// --- (the //**root**// part assumes //**root**// is your mysql username) \\ \\ Create a MySQL Database \\ //**CREATE DATABASE new_database;**// --- (don't forget the //**semicolon ;**// it's really important) \\ \\ Show a MySQL Database \\ //**SHOW DATABASES;**// \\ \\ \\