6
Jun/22MySQL caching_sha2_password: the specified module could not be found.
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/20Upgrading MySQL Running In Docker (Compose)
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/18Cannot load from mysql.proc. The table is probably corrupted
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/16Post MySQL Install
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/16Ubuntu 16.04 Migration Update
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/15MySQL Workbench Error Code 7
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/14MySQL Server 5.6 512MB RAM
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/14TTRSS – Your access level is insufficient to run this script
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