LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Suse/Novell
User Name
Password
Suse/Novell This Forum is for the discussion of Suse Linux.

Notices

Reply
 
Search this Thread
Old 04-04-2007, 05:48 PM   #1
cormack
Member
 
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 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
 
Old 04-06-2007, 07:10 AM   #2
1kyle
Member
 
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.

Cheers

-K

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


Reply


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/Novell 6 09-16-2006 08:00 PM
Need Help to setup MyThtv madman100 Linux - Newbie 2 09-09-2006 05:08 AM
how to setup mysql for mythtv?? jadukor Slackware 9 04-13-2006 02:01 AM
MythTV setup for a MySQL noob sadarax Linux - General 1 03-11-2006 01:31 AM
mythtv mysql database setup help carmat06 Debian 3 09-27-2005 06:41 PM


All times are GMT -5. The time now is 10:06 PM.

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