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>;