Log into the itunix.ccm.edu server via putty, and then access mySQL using the following command:


sudo mysql -u root


To see a listing of all mySQL databases:  show databases;


To see a list of all users and hostnames:  SELECT user,host FROM mysql.user;


To see what a user is granted:   show grants for 'username'@'host';    CCM examples below:


show grants for 'haase.benjamin'@'localhost';

show grants for 'haase.benjamin'@'192.168.0.254';





NOTE:  Don't forget the trailing semicolon