Like the fool I am, whilst messing about with user privileges in phpMyAdmin I managed to delete the root account. Suddenly I found myself with no access to any of my databases
It took a while to figure out how to re-create the root@localhost user, so here’s how I did it.