[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