[HLUG] How to setup mysql??

[Emon]

Mark Broadbent wrote:

> BTW, Emon did you install mysql from source or from a package?  It
> looks like the installation is bad.
> 

Thanks everyone

Yes I installed from a pkg. This is what I had to do

"chown -R mysql /var/lib/mysql" did the trick!! It was mentioned in the 
Slackware startup script for mysql (I know...; should have looked more 
carefully before complaining :) ...sorry about that)

Looks like mysql starts successfully during bootup

When I do "pstree -p"; this is a small part of what I see

         |-lisa(4256)
         |-mysqld_safe(3927)---mysqld(3951)
         |-nmbd(3955)

So.. does this mean mysql is ok???? If so why do I still get the
following error while trying to run mythtv...

*****************
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-04-12 00:52:03.942 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-04-12 00:52:09.353 Unable to connect to database!
2006-04-12 00:52:09.353 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)
*****************

Thanks again
Emon