SELECT * FROM USER_PRIVILEGES

SELECT CURRENT_USER(),USER()

SHOW GRANTS FOR CURRENT_USER()
show grants for 'moreorg_jma'@'localhost'


SELECT * FROM `information_schema`.`SCHEMA_PRIVILEGES`; 

SELECT * FROM TABLES WHERE TABLE_TYPE = 'VIEW'
SELECT * FROM VIEWS

SELECT * FROM TABLE_PRIVILEGES

RENAME USER 'jeffrey'@'localhost' TO 'jeff'@'127.0.0.1';

show databases;

show databases;

describe [table name];

mysql> use mysql;
 mysql> INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password'));
 mysql> flush privileges; 

UPDATE [table name] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user';