[HLUG] How to setup mysql??

[Mark Broadbent]

On 11/04/06, Emon <contact_emon at gawab.com> wrote:
> 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)

Strange that wasn't setup for you.  You might want to file a bug
report with slackware about that (providing it was an official
slackware package).

> 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????

Yep, it looks like it's running.

> 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)
> *****************

The answer being in the last line, have you set-up a mythtv account,
assigned a password and put that password into the mythtv
configuration?

Thanks
Mark


--
Mark Broadbent
Herefordshire LUG Master

* http://www.wetlettuce.com/
* http://www.herefordshire.lug.org.uk/