Wednesday, January 19, 2011

Using MySQL for MediaTomb

1. Create a MySQL user

$ mysql -u root -p
mysql> create user 'mediatomb'@'localhost' identified by 'secret';
mysql> create user 'mediatomb'@'%' identified by 'secret';
mysql> grant all on mediatomb.* to 'mediatomb'@'localhost';
mysql> grant all on mediatomb.* to 'mediatomb'@'%';
mysql> quit

$ mysql -u mediatomb -p
mysql> create database mediatomb;
mysql> quit

$ mysql mediatomb -u mediatomb -p < /usr/share/mediatomb/mysql.sql

$ sudo /etc/init.d/mediatomb restart

3 comments:

  1. This worked a treat and was exactly what i was looking for.

    ReplyDelete
  2. Thanks for this post, very useful. I had to switch from SQLite to MySQL because a corruption occurred in SQLite database... seems very unreliable.

    ReplyDelete
  3. Thanks,

    You save me a lot of time.

    ReplyDelete