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

create database XYZ;

describe TABLE;

show create table TABLE;