Archive for the ‘MySQL’ Category
Upgrading to MySQL 8? Think of the default authentication plugin
As explained in a post at mysqlserverteam.com 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 […]
“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 […]
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 […]
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 […]