Archive for the ‘MySQL’ Category

Upgrading to MySQL 8? Think of the default authentication plugin

As explained in a post at the default authentication plugin has been changed from mysql_native_password to caching_sha2_password. And that would certainly break all PHP-based applications because at the time of writing PHP doesn’t support caching_sha2_password. Please, keep an eye on the related request #76243. Once it’s implemented it would be possible to switch to […]

Posted on May 15, 2018 at 10:15 am by sergeyt · Permalink · Leave a comment

“Change master” to the rescue or how to revive MySQL replication

Sometime ago had an issue with MySQL replication that consecutively faulted with two different errors. Initially with this one: Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay […]

Posted on January 10, 2016 at 9:58 pm by sergeyt · Permalink · 2 Comments

mysqldump causes error 2006

Hot on the heels of the recent mysqldump I’ve been running on MySQL 5.5 which ended with the following error: Got error: 2006: MySQL server has gone away when selecting the database Turned out that this error is quite common and there is a quick work around for that – increase max_allowed_packet. In my case […]

Posted on November 22, 2015 at 4:11 pm by sergeyt · Permalink · Leave a comment

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