[mythtv-users] problems setting up mysql w/FC1

[match at ece.utah.edu]

I don't have an answer, but I'll share this... After several days of hacking and much 
correspondence between myself and Jarod, I finally gave up trying to get mysql to work 
with mythtv. Finally I wiped the disk and started over. The next (complete) re-install 
worked. 

As far as I can tell, I followed the same steps exactly the second time as I had the first. 
Go figure... maybe there was a hiccup at one of the source sites, maybe one of the 
source sites carries an erroneous package that I just happened to get the first time... 
phases of the moon, I dunno.

I've done so many RedHat and Fedora Core installs that I can nearly do them in my 
sleep, so perhaps the first time around I just didn't pay close enough attention to what I 
was doing. One thing I did the second time around was to examine very closely my 
initial Fedora Core installation, even before installing the kick-start package, and I made 
sure that I had just the right packages installed (and no more) as recommended at the 
beginning of Jarod's write-up... but I THOUGHT that I had those bases covered the first 
time too.

Marvin

On 25 Apr 2004 at 17:01, mike johnson wrote:

> Hello,
> been using the guide on wilsonet..com to setup a mythtv box.  havng a hell 
> of a tme wth mysql.  for those not familiar w/the nstructions on this task, 
> i've included them.
> 
> what i've done.  i've started mysql (and verified that it is indeed 
> running),  set the password, but when i input the line to create the 
> mythconverge database, i get a message saying that it isn't there.?   i'm 
> new to mysql, so input would be a great help.
> 
> thanks
> 
> -------------
> 
> 13. Set up MySQL
> 
> We'll need to enable MySQL to load at startup, set some passwords, and 
> create the MythTV database, which we'll populate shortly. Starting with 
> MythTV 0.12, the population of this database is handled by mythtvsetup, in 
> the next step, and all MythTV add-on module database additions must be done 
> AFTER running mythtvsetup.
> # /sbin/chkconfig mysqld on
> # /sbin/service mysqld start
> 
> Set the mysql root password, replacing ROOT_PWD with your chosen 
> administrator password:
> # mysql -u root mysql
> mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE user='root';
> mysql> FLUSH PRIVILEGES;
> mysql> quit
> 
> Now we create the mythtv database (called mythconverg) to get us started:
> $ mysql -u root -p < /usr/share/doc/mythtv-0.14/database/mc.sql
> (enter the password you just set above when prompted)
> 
> Again, all subsequent database population for MythTV's add-on modules must 
> now be done AFTER running mythtvsetup for the first time.
> 
> Fedora Core contains a mysqladmin ping check in its mysqld init script, 
> which fails after a password is set for the root account. The check will 
> hang for 10 seconds, and then falsely report a failed mysqld startup. To 
> remedy this, edit /etc/init.d/mysqld as root, changing the two lines that 
> read:
> "`/usr/bin/mysqladmin ping 2> /dev/null`"
> 
> To something like this:
> "`/usr/bin/mysqladmin -umysql ping 2> /dev/null`"
> 
> _________________________________________________________________
> >From must-see cities to the best beaches, plan a getaway with the Spring 
> Travel Guide! http://special.msn.com/local/springtravel.armx
> 
> 
>