The latest version of PHPMYADMIN won’t allow root to login without a password, and you can only login to the phpmyadmin user.
Here’s how you work around it.
sudo mysql -u root
CREATE USER 'set-new-user'@'localhost' IDENTIFIED BY 'set-your-password';
GRANT ALL PRIVILEGES ON *.* TO 'your-suername'@'localhost';
sudo service service mysql restart
If that fails, try this:
sudo mysql -u root
update user set plugin='' where User='root';
I’ve held off updating the blog with the fix for the power cut-out on the Carrera Crossfire-E, I wanted to be sure that I wasn’t just fooling myself and to make sure it stays fixed. 300 miles later and I’ve had zero cut outs.
Way way back in April 2016 when I got this bike and experienced my first power cut I noticed that a zip-tie was around the cable and the frame. But just before going on my holiday to Fort William I gave my baby a damn good clean and service. During the service I removed the rear wheel and chain for a really deep clean, then reattached everything and put on a new zip-tie, a green one.
Just before my holiday to Fort William I emailed SR Suntour and asked if they have an update for 2016 and earlier bikes, to swap the display from KM to Miles, they didn’t and stopped working on updating the firmware some time ago. They did suggest that I contact Halfords and ask if they’ll swap the display to a 2017 model for me as it’s compatible with earlier bikes.
So I went to my local store and they didn’t hesitate to order one, unfortunately they only ordered the display and not the LCD holder, and while the display arrived in time for my hols, the holder didn’t.
But by the time I came back they had arrived and I’ve now got the display and buttons for a 2017 bike and they work perfectly, man it’s so nice to have miles per hour and miles total instead of KM.
So a big thank you to Halfords (Halifax) for sorting this out for me, and free of charge too.