Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Distributions > SUSE / openSUSE
User Name
SUSE / openSUSE This Forum is for the discussion of Suse Linux.


  Search this Thread
Old 04-04-2007, 04:48 PM   #1
Registered: Oct 2005
Location: Scotland, UK
Distribution: Kubuntu 9.10, ubuntu 8.04.2 server
Posts: 156

Rep: Reputation: 30
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

Then started with this one
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

Old 04-06-2007, 06:10 AM   #2
Registered: Feb 2004
Location: 'Ol Blighty
Distribution: SLED 10, SUSE 10.3
Posts: 722

Rep: Reputation: 32
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.



Last edited by 1kyle; 04-06-2007 at 06:13 AM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
MythTV setup and SUSE carl0ski SUSE / openSUSE 6 09-16-2006 07:00 PM
Need Help to setup MyThtv madman100 Linux - Newbie 2 09-09-2006 04:08 AM
how to setup mysql for mythtv?? jadukor Slackware 9 04-13-2006 01:01 AM
MythTV setup for a MySQL noob sadarax Linux - General 1 03-11-2006 12:31 AM
mythtv mysql database setup help carmat06 Debian 3 09-27-2005 05:41 PM > Forums > Linux Forums > Linux - Distributions > SUSE / openSUSE

All times are GMT -5. The time now is 08:34 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration