Archive for October, 2015

What unites DEFINER, “show table status” and ERROR 1143 (42000) in MySQL

For the very first time I had seen this error a couple of days ago: mysql> show table status; ERROR 1143 (42000): SELECT command denied to user ”@’some_host_name_here’ for column ‘sid’ in table ‘masking’ What the heck was that?! Turned out that a colleague of mine was doing a cleanup in mysql.user table a day […]

Posted on October 16, 2015 at 9:37 pm by sergeyt · Permalink · Leave a comment
In: MySQL