[mythtv-users] problems setting up mysql w/FC1
match at ece.utah.edu
match at ece.utah.edu
Mon Apr 26 12:46:39 EDT 2004
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
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
On 25 Apr 2004 at 17:01, mike johnson wrote:
> 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.
> 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
> "`/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
More information about the mythtv-users