Grant Privileges:
-----------------
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'pryan'@'localhost'
IDENTIFIED BY 'pryan';



CREATE USER 'pryan'@'%' IDENTIFIED BY '***';
GRANT USAGE ON * . * TO 'pryan'@'%' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;


REVOKE ALL PRIVILEGES ON * . * FROM 'pryan'@'%';

REVOKE GRANT OPTION ON * . * FROM 'pryan'@'%';

GRANT SELECT ,
INSERT ,
UPDATE ,
DELETE ,
FILE ON * . * TO 'pryan'@'%' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;



mysqladmin --user=root --pass=rod2cop8ja GRANT FILE ON * . * TO 'pryan'@'%' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
mysql --user=root --pass=rod2cop8ja