Search code examples
mysqlmysql-error-1045

Proper permissions for "SHOW TABLE STATUS" in MySQL

I can insert, update, delete, etc. to a table in my MySQL database but I cannot show the table status. Does anyone know which privilege(s) is needed to do this?

Here is my error message:

Access denied for user 'admin459'@'localhost' to database 'sample'
Solution

  • Minimal (select only) privileges is all I need to get table status. What version of mysql?

    grant select on test_dev.districts to td3@localhost identified by 'monkey';

    then:

    mysql -pmonkey  -u td3 TAMS_development -e 'show table status;'

    works.

    what does this return for you?

    show grants for admin459@localhost;