6

Jun/22

MySQL 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/20

Upgrading 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/18

Cannot 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/16

Post 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

22

Feb/16

Migrating From Ubuntu 14.04 To 16.04

Overview I have written migration plans for Ubuntu upgrades before. What makes it different this time is the hybrid Docker containers that I have used in places and the support for virtual IP (VIP) in Digital Ocean, my current hosting … Continue reading

23

Nov/15

MySQL 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

8

Jul/13

Install Tiny, Tiny RSS On Ubuntu 12.04

Overview Since Google announced they were shutting down their Google Reader service it has come to light how dependent I was on a third party. Fortunately, Google allows data to be exported in a variety of formats including standard variants. … Continue reading

24

Jun/13

Installing MySQL Ubuntu

MySQL is very easy to install and the commands work for most versions of Ubuntu. Start a terminal. Update Ubuntu’s repository: sudo apt-get update Install MySQL server: sudo apt-get install mysql-server A prompt will appear asking for the root (admin) … Continue reading