Show Menu

Essential MySQL Cheat Sheet (DRAFT) by

Essential MySQL Cheet Sheet For Beginners

This is a draft cheat sheet. It is a work in progress and is not finished yet.

MySQL Data Types

This is a live content block, but has not yet been populated. Please check back soon.

Mysql Essensial Commands

login into shell
mysql -u user -p
show all databases
show databases;
delete a database
drop database db_name;
select a db to work with it
use db_name;
show a database tables
show tables;
delete a table
drop table tbl_name;
change/set a user password
set password for user@host = password('password');