Proper permissions for "SHOW TABLE STATUS" in MySQL

mysql mysql-error-1045
H. Ferrence picture H. Ferrence · Nov 18, 2010 · Viewed 8.3k times · Source

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'

Answer

Wayne Walker picture Wayne Walker · Jul 28, 2011

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;

Related questions

Access denied for user 'root@localhost' (using password:NO)

I'm new to MySQL, I'm trying to run WordPress in my Windows desktop and it needs MySQL. I install everything with Web Platform Installer which is provided by Microsoft. I never set a root password for MySQL and in the …

Read More
Access denied for user 'test'@'localhost' (using password: YES) except root user

I am facing problem with mysql non root/admin user, I am following the below steps for creating user and its privileges, correct me if i am doing wrong, i am installing mysql on RHEL 5.7 64bit, packages are mentioned below, …

Read More
Access denied for user 'root'@'localhost' while attempting to grant privileges. How do I grant privileges?

I've looked at a number of similar questions and so I'm demonstrating that I've checked the basics. Though of course, that doesn't mean I haven't missed something totally obvious. :-) My question is: why am I denied access on a …

Read More