Testing MySQL Database
======================

1. SIMPLE STUFF 
mysql -u root -p		(key in rootpass for password)
exit
	
mysql -u root -p 	(key in rootpass for password)
SELECT VERSION(), CURRENT_DATE;
SHOW DATABASES;
USE test;
Database changed

GRANT ALL PRIVILEGES ON *.* TO monty@localhost
->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
exit

mysql -u monty -p 

Find out about users in MYSQL
==============================
show databases;
use mysql
show tables;
describe user;
select user, password from user;


2. CHANGE PASSWORD
mysql -u root -p
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootpass';
flush privileges;
exit;