MySQL Upgrade

After the PHP Upgrade I noticed that PHPmyAdmin wasn’t working. After messing around with this a bit I decided to go ahead and upgrade MySQL to 8.0. Things have changed a lot since I did 5.5, but after getting the new installer things went ok. I failed the first time at importing the old database into the new one so bad that I ruin the root login. After an uninstall and clean install I successfully migrated the data with the migration tool. WordPress wasn’t working. After a little digging it looks like the users from the old database didn’t really migrate. So after setting up the WordPress User account again things worked no problem. With that complete, PHPmyAdmin still doesn’t work. Also, Raspberry Pints doesn’t work with the new SHA2 encryption. To help here I reconfigured MySQL for backward compatibility to 5.X. That almost worked, but now I need to go redo all the hacks that I made to get raspberry pints to work the first time.

Tags: , ,

Leave a Reply