Tag: USE

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'…