[mythtv-users] Database problem?

[list at onnow.net]

You should leave the mythtv username and passwd as they were.
The mysql database is called mythconverg

Your system is not able to make a mysql connection is what all that  
erroring is telling you.

Remove mythTV from the troubleshooting.....

on the command line do these things:
ps -ef |grep mysql ( you should see mysql running )

Then type this  ( exactly as shown )
mysql mythconverg -u mythtv -pmythtv

You should get a mysql> prompt.  Then you know you are able to connect  
to mysql.

Post any errors and you will get help here.


Mark

Quoting Peter Crighton <mythtv at p-cright.demon.co.uk>:

> I'm nearly there installing MythTv:
>
> Mandrake 2006 (3 CD free version) installed.
> Mythtv installed using the instructions in the documentation
>
> When I run myth-setup, there are a lot of errors displayed of the
> form:
>
>
> time/date Database not open while trying to load setting: *****
> time/date Unable to connect to database!
> time/date No error type from QSqlError? Strange...
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> time/date DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError? Strange...
>
>
>
> **** - lots of different values (whole section repeated for each
> value)
>
>
> A graphical selection is then displayed to select the language and
> after that Database Configuration 1/2:
>
> Myth could not connect to the database. Please verify your database
>
> Host name: mythtv
> Database: mythconverg
> User:
> Password:
> Database type: Mysql
>
> Initially user/password were mythtv/mythtv. I have tried both my
> normal user and the root user with their respective passwords with no
> luck.
>
> When I click Next and then Finish it goes back to the $ prompt. with
> the final line being Failed to init  MythContext, exiting.
>
>
> The database is (I think) installed properly: If I enter "mysql -u
> root" then I can enter "use mythconverg" and the database is changed.
>
> I have changed the security to "no security" as per the HOWTO section
> 6.2 instructions, but if I simply run "mysql -u peter" then access is
> denied to using the database
>
>
> Grateful for suggestions for the way forward.
> --
>
> Peter Crighton
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>