6

Jun/22

MySQL caching_sha2_password: the specified module could not be found.

Filed Under Database at 6th June 2022 0:01 by

Upgrading from MySQL 5.x to 8 has caused an error with existing accounts. The fix is to set the authentication to use. More details can be found here. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be … Continue reading →

7

Sep/20

Upgrading MySQL Running In Docker (Compose)

Filed Under Container, Database at 7th September 2020 0:01 by

Overview I wanted to try and upgrade my MySQL database from 5.7 to 8.0 however I have containerised my database install. What I thought was a immutable container would be a simple burn and switch turned out to be a … Continue reading →

7

May/18

Cannot load from mysql.proc. The table is probably corrupted

Filed Under Database at 7th May 2018 0:01 by

I was trying to update accounts in MySQL and got the following error message: Cannot load from mysql.proc. The table is probably corrupted A little bit scary if my data was corrupted. Turns out there is an upgrade command which … Continue reading →

5

Dec/16

Post MySQL Install

Filed Under Database at 5th December 2016 0:01 by

After installing MySQL you can run the below command to secure your install: sudo mysql_secure_installation The script will ask a bunch of questions and act accordingly so it is only as secure as you want it to be but it … Continue reading →

18

Jun/16

Ubuntu 16.04 Migration Update

Filed Under Infrastructure, Linux at 18th June 2016 14:45 by

A quick update to my migration process. I had all the servers running 16.04 and it was OK except for the stability. Setting up and moving things were simple enough. I did encounter issues with my symlinked .bashrc which I … Continue reading →

23

Nov/15

MySQL Workbench Error Code 7

Filed Under Database at 23rd November 2015 0:01 by

Overview On Windows, I was getting the following error trying to take a database dump to file: mysqldump: [ERROR] unknown variable ‘delayed-insert=FALSE’ Operation failed with exitcode 7 At the time I was using Workbench 6.3.5. Temporary Fix Edit the file … Continue reading →

29

Sep/14

MySQL Server 5.6 512MB RAM

Filed Under Linux at 29th September 2014 0:01 by

Overview Ubuntu 14.04 added MySQL 5.6 to the official repository but it turns out installing it on anything less than 1GB RAM is pretty difficult. Disable Service Startup It is necessary to disable service startup after an install to prevent … Continue reading →

14

Apr/14

TTRSS – Your access level is insufficient to run this script

Filed Under Software at 14th April 2014 0:01 by

After upgrading from 1.9 to 1.11 I had got the error message “Your access level is insufficient to run this script” when trying to log in. The problem was TTRSS needed to run some upgrade script but if you log … Continue reading →