[mythtv-users] Newbie questions- MySQL, Debian etch, and recording TV

Stephen Sassman sassman1 at gmail.com
Mon Jan 29 16:14:07 UTC 2007


Hi Mike,

I am using debian etch. You  can use the mysql version from the apt
repositories:

apt-get install mysql-server-5.0 mysql-client-5.0

Then you want to get rid of the mysql accounts that have blank
username (note that the '' is actually two single quotes and not one
double quote) (this is described in the mysql documentation here:
http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html):

mysql -u root

mysql> DELETE FROM mysql.user WHERE User = '';
mysql> FLUSH PRIVILEGES;

Then you want to set the password for the root account which initially
has blank password (insert you hostname and password where
appropriate):

mysql -u root

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');

Finally you want to create a database for mythtv and set up the
username and password that will access it (as described here:
http://dev.mysql.com/doc/refman/5.1/en/adding-users.html):

mysql -u root

mysql> CREATE DATABASE mythconverg
mysql> GRANT ALL PRIVILEGES ON mythconverg.* TO 'username'@'localhost'
    ->     IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON mythconverg.* TO 'username'@'%'
    ->     IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

Now you can put the username and password to access the database into
mythtv-setup and your ready to go! Hope that helps. Its been a while,
so hope I didn't leave anything out.


More information about the mythtv-users mailing list