Follow the steps outlined in Myth(TV)ology Section 12. Here is the list of commands to run. Use a real password rather than ROOT_PWD.
# /sbin/chkconfig mysqld on # /sbin/service mysqld start # mysql -u root mysql
At the SQL prompt type in the following (hit enter at the end of each line, after the ;)
mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
Now, change back to user 'mythtv' to populate the database thus:
$ mysql -u root -p < /usr/share/doc/mythtv-0.16/database/mc.sql
At that last enter the ROOT_PWD you just created. If everything worked you will receive the following error message:
ERROR 1064 at line 4: You have an error in your SQL syntax near 'TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv"' at line 1
If you receive a different error message then something is wrong.