Installing & Configuring MySQL

excellent BASIC MYSQL CONFIGURATION

(typical) LOCATION OF mySQL CONFIG FILE [=my.cnf]
= /etc/mysql/my.cnf

LOG ON TO MYSQL CONSOLE
> mysql - u user -p

drop database syntax

How to change the mysql database location

LIST DATABASES
> mysqlshow -u root -p

CREATE DATABASE
1
2
3

SHUTDOWN SERVER
mysqladmin -u root -p shutdown

---

Information Schema Tables [official mysql ref]

The schema 'information_schema' contains the meta-data for the db server

TO QUERY ALL TABLES CONTAINED IN DB test
> select *
> from information_schema.tables
> where table_schema = 'test';