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'
To GRANT ALL privileges to a user , allowing that user full control over a specific database , use the following syntax: mysql> GRANT ALL PRIVILEGES ON database_name. * TO 'username'@'localhost';
With a GLOBAL modifier, the statement displays the global status values. A global status variable may represent status for some aspect of the server itself (for example, Aborted_connects ), or the aggregated status over all connections to MySQL (for example, Bytes_received and Bytes_sent ).
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;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With