Show privileges for table in mysql

Select table and then do:

mysql> USE mytable;
mysql> SHOW GRANTS;
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for [email protected] |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*C35CFFB1DAEDFFF922182562332B1D86A36BC0' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.05 sec)

Create a user and grant all privileges on table to him:
CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'newpassword';
GRANT ALL ON episodestbl.* TO 'someuser'@'localhost';
FLUSH PRIVILEGES;


You are reading this post on Joel G Mathew’s tech blog. Joel's personal blog is the Eyrie, hosted here.