PHPMYADMIN Root reset

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';

FLUSH PRIVILEGES;

exit

sudo service service mysql restart

If that fails, try this:

 
sudo mysql -u root
use mysql;
update user set plugin='' where User='root';
flush privileges;
\q

The dreaded crossfire-e power cut – FIXED!

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.

Continue reading

Thank you Halfords

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 control button too, and while the display arrived in time for my hols, the buttons didn’t.

But by the time I came back they had arrived and I’ve not 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.