[mythtv-users] Mythtv - database; MySQL good - Myth Lost -

Jeremy Thompson aimhigh_af at hotmail.com
Mon Oct 3 15:19:44 UTC 2005


ALL,
  I got MySQL running at startup, point to the mythconverg database.  Here 
is my.cnf:


Here is my.cnf:
[quote]
[mysqld]
datadir=/var/lib/mysql/mythconverg
socket=/var/lib/mysql/mysql.sock
skip-innodb

[mysql.server]
user=mysql
basedir=/var/lib
key_buffer = 16M
table_cache = 128
sort_buffer_size = 2M
myisam_sort_buffer_size = 8M
query_cache_size = 16M

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[/quote]

I also had to change my startup script in rc.d to point to this database.  
It's running now

However now Mythtv can't find the database -

mythtv log display
[quote]
2005-10-02 12:44:27.991 Unable to connect to database!
2005-10-02 12:44:27.992 Driver error was [1/1049]:
QMYSQL3: Unable to connect
Database error was:
Unknown database 'mythconverg'
[/quote]

mysql log dispaly
[quote]
/usr/libexec/mysqld: ready for connections
[/quote]

It sends me to database config each time.  Root and password are correct.  I 
have tried each of the entries in my hosts table

hosts table
[quote]
127.0.0.1	mythtv	localhost.localdomain	localhost
[/quote]

I have used the IP, mythtv, and localhost, not loca...doman,  in the 
database config.  Same
error as above.

At a bit of a loss.

JT




More information about the mythtv-users mailing list