!!! MySQL Database

"mysql" is the name of the command line utility.


“MySQL Workbench” is the gui utility

“root” is the top level user.

mysql  -h  <host>  -u  <USER>  -p<PASSWORD>  <DBNAME>

!! mysql commands

status;

source <filename>

show databases;

use <database>

show tables;

use <DBNAME>;

exit

drop database <dbname>;

create database <dbname>;

describe <table>;

show create table <table>;