You are currently browsing articles tagged phpmyadmin.

I ran into issues with the latest phpmyadmin. seems like there is a real bug in 4.9.2 that won’t let cookies work at the moment. I tried a lower version, but had different problems. I’ve been providing some feedback through Issue #15634. In the meantime, I’ve turned to Adminer. It’s a single small php file and worked first time. Given the hours I’ve spent with phpmyadmin and the limited need I have to edit the SQL database, Adminer is my new goto tool


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: , ,

Just experienced my first corrupt database error. All repair attempts failed. Fortunately, I have the WP-DBManager plugin running with periodic full backups. With a previous backup I was able to use the import function in phpMyAdmin to recover my WordPress site back to my last post.

Tags: , ,