MySQL Database#

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

“MySQL Workbench” is the gui utility

“root” is the top level user.

mysql -u USER -pPASSWORD DBNAME

mysql commands#

status;

show databases;

show tables;

use DBNAME;

exit

drop database ABC;

create database XYZ;

describe TABLE;

show create table TABLE;