January 31, 2012

Resetting MySQL root password from the CLI

Seems like I always end up searching for this so I thought I would add it to my site for easy reference.

Stop MySQL
```
sudo /etc/init.d/mysql stop
```
Start MySQL with the following command
```
sudo mysqld --skip-grant-tables &
```
Login to MySQL as root with out a password
```
mysql -u root mysql
```

Replace PASSWORD with the new password of your choice.

UPDATE user SET Password=PASSWORD('PASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;

January 3, 2012

Centralized XBMC library

Problem: I have multiple AppleTV’s running XBMC on them all reading from the same central server. The issue was that the thumbnails might be on one and not the other, also watching TV series its hard to keep track of which episode I am on since I watch from multiple locations.

Solution: Doing some reading you can actually make all of the XBMC instances store data to a central server running MySQL. Why would you want to do that? Well there are a few reasons, besides having everything in sync across the board it also gives you the ability to resume playback from where you left off in another room.

Continue reading →