mythtv mysql setup help.
 

Hey, just got a hauppage winNova T-500, and got it up and running, and installed mysql and all the mythtv things from yast packman.

Started with this guide http://www.mythtv.org/wiki/index.php...l_Installation

Then started with this one
http://www.novell.com/coolsolutions/feature/595.html
got to the end of the second on, but only got 2 pages from mythtv set up, language and where or not the front end host will change alot. But when i ran mythtv-setup i got a heap of errors about mysql, and then the set up crashes.

from the first page, this line
mysqladmin -u root password mysqlpassword
worked first time, but since i followed the second guise it no longer works.

I think its that i havnt set up mysql properly.

Any help will be greatly appratiated. Seen mythtv before and it is soo good. Cant wait to get the front end workin on my xbox.

Thanks for your help

Ryan

I'd suggest the following first.

1)scrub your existing MySQL.

2)Install Apache (useful as a server then your web browser can check out a whole slew of stuff a lot more easily than using the command line interface for mysql).

3) Install PHP5. Install most of the sensible modules including MYSQLI (note MYSQLI not MYSQL). Install stuff also like the apache module, bzip, Mysql interface etc etc.

I recommend php as it's very useful and there's a nice easy way to administer MySQL with a great tool phpMyAdmin

4) install MySQL (version 5.0.18) at least.

5) start the Apache, and MySQL services.

6) create a text file in folder /home/username/public_html

<?php phpinfo(); ?>

call this file info.php

7) point your browser at localhost/~username/info.php

This should show you all sorts of info plus the MySQL stuff if it's working

8)Install phpMyAdmin. Should be on the installation CD. If it's not just download it.

9) Now point your browser at localhost/phpMyAdmin
Note the caps are CASE sensitive so type as phpMyAdmin.

This should give you all sorts of stuff on your MySQL server.

10) create user permissions tables or whatever.

11) Now proceed with your multi-media part. I haven't installed that but if you've got setps 1) to 10) working your MySQL server should be fine.

Don't forget to set Root's password on the MySQL database.

Cheers

-K