Tuesday, May 14, 2013

Resettting your mySQL root password

When you need to reset your root password for your mySQL server, proceed this way:

# sudo /etc/init.d/mysql stop
# sudo mysqld_safe --skip-grant-tables &
# sudo mysql -u root

on the mySQL console:

mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit

# sudo /etc/init.d/mysql stop
# sudo /etc/init.d/mysql start

To confirm you indeed have access to mySQL with the new password:

# mysql -u root -p

Thursday, May 2, 2013

Clementine - Finally a great Linux music player

I'm currently exploring clementine v1.0.1, a Linux music player. The first impressions are really good. It picked up most of my music collection (although it took a while, but it is a LONG collection...) but I got better organization than all other players I have tried.

A lot of the reviews I read said a lot of great things about last.fm and similar services integration but I'm not a customer of those platforms, so I can't really comment on that. I can tell you, however, that the "internet services" tab is quite comprehensive: Jamendo, last.fm, grooveshark, magnatune, sky.fm and somafm - a lot of them I really never heard about.

Internet services tab

The album art for most of my collection was downloaded without problems, and the ones that were not downloaded were afterwards when you go tot he album covert option and select download missing cover art. There's quite a few that are not correct, but nothing that a little time to kill won't fix. Very happy with this point too.

cover manager window

Another thing that seems to be above average is file meta data management. By that I mean the sometimes tedious task of making sure that the album artist is the same on all your files because media organizers tend to think Korn is a completely different artist to KoRn. Bulk metadata change is a breeze with clementine and in no time you will have your albums/ artists organized in a very OCD-pleasing way - just the way I like it!

Bulk metadata edit made easy!

Integration with my HTC sensation mobile phone is a breeze. It sees it as a removable disk, which is nothing special, but the interaction with the phone and your music library is pretty good in my opinion.

Media player integration

Then there's the song information tab, that shows you - you guessed it - song information: how many people listened to that song on last.fm and how many times was played (note that that information shows up even if you are playing files from your personal collection). It shows you lyrics and artist info. All this is obviously pulled from online resources such as wikipedia and wikilyrics. Some of the more obscure bands and artists in my collection were not found, but I think only me and another 3 people have ever heard of them, so that's understandable.

the lyrics tab - all obviously pulled off the web on demand. So far accuracy has been great!

Another cool thing is the fade-in fade-out feature that you can hear when you skip songs or when you stop the player. For sure this is a feature other players also have but it's yet another point for clementine. On the topic of cool features, I also like the equalizer visualization at the bottom of the window - it's very responsive and you can change the visualization that mostly suits you. Again, for sure you can find this in other programs, but I particularly like it in clementine.

Like I wrote in the beginning of this review, I really like it and I will keep using it. If you are looking for a robust music player, try clementine.