YOU ARE HERE:Build Your Own MythTVSetting Up MySQL
Build Your Own MythTV
Installing Fedora 7
Adding Repositories
Installing Custom Kernel
Installing Nvidia Video Drivers
Automatic Login in Fedora
Installing MythTV From svn
Setting Up MySQL
Australian MythTV Database
Fetching the Australian Programming Guide
Making the Leadtek DTV-1000T Remote Work in Linux
Installing & Configuring LIRC
Changing Foxtel Channels from Mythtv
Getting Pay TV to Work With MythTV
Asus M2NPV-VM Problem

Setting Up MySQL

MySQL should have been installed when you selected the packages. Now you just need to start it and make it start automatically everytime the computer starts. To do so:

#chkconfig --levels 235 mysqld on
#/etc/rc.d/init.d/mysqld start

Now check that networking is enabled. Run:

#netstat -tap

You should see a line like this:

tcp 0 0 *:mysql *:* LISTEN 2721/mysqld

If it does not, edit /etc/my.cnf and comment out the option skip-networking:

#skip-networking

Now, assing a password for the root user in MySQL, and replace the user root with the user mysql. I'm using the password mythtv.

#mysqladmin -h localhost -u root password mythtv
# mysql -uroot -pmythtv mysql
mysql> UPDATE user SET user='mythtv' WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit