RE: [PLUG] MySQL3 and Fedora Core 3

["ChrisB." <chris@chrisbovasso.com>]

Actually I left out a piece of the puzzle. I tried to run the mysql script
that they offer but I kept getting syntax errors. So I tried to just type in
the commands manually (its only a few lines) and it errors on the line:

'TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY
"mythtv"'

The interesting part is that I know the password fix for MySQL4 is to
correct the password for the users using OLD_PASSWORD('newpasswd') but I am
not running MySQL4. Unless Myth is running a MySQL4 client?

Argh...



-----Original Message-----
From: Joseph Kovach [mailto:joe@singlewire.com] 
Sent: Thursday, February 03, 2005 10:01 AM
To: chris@chrisbovasso.com; Philadelphia Linux User's Group Discussion List
Subject: Re: [PLUG] MySQL3 and Fedora Core 3

Chris B,
did you 'flush privileges' in mysql?
btw i always misspell privileges, so double check when you're typing it
yourself.

Joe




Quoting "ChrisB." <chris@chrisbovasso.com>:

> Everyone,
>
> So I bit the bullet on Tuesday and installed Fedora Core 3 for the first
> time. I have never used a RedHat product before and I was very impressed
at
> how easy it was to install. Apt-get, yum and rpm are truly god sends. I
have
> to admit though that I felt very naked without my trusty ./configure at my
> side.
>
> But I digress, I am trying to build a MythTV box and everything seemed to
go
> fine but I can not connect to the mysql service running. At first I
thought
> it was just a MythTV issue but I was unable to connect to the MySQL
through
> PHP as well. I keep getting the same error (see below) now I know that
> MySQL4 has issues with user password authentication but I am using MySQL3
> still, I read up on FC3 and the SELinux giving MySQL issues, so I disabled
> it but yet the issue persists.
>
> So as great as apt-get, yum and rpm are, it leaves me in the position of
> knowing next to nothing of FC3 inner workings even *after* I have
> successfully installed it. I am not too sure what to try next. Does the
> error strike anyone?
>
> Thanks in advance,
>
>
> Chris.
>
>
> MySQL connection error:
>
>
> FYI: I tried all the obvious things, password is the same, permissions,
etc.
> I can connect to MySQL through the console without an error but when an
> application tries to connect I get basically the same error 'access
denied'.
>
>
> +++++++++++++++++++++++++++
> Unable to connect to database!
> Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user: 'mythtv@localhost' (Using password: YES)
>
> Unable to open database:
> Driver error was:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user: 'mythtv@localhost' (Using password: YES)
> +++++++++++++++++++++++++++
>
>
>
>
>
>
___________________________________________________________________________
> Philadelphia Linux Users Group         --
http://www.phillylinux.org
> Announcements -
http://lists.phillylinux.org/mailman/listinfo/plug-announce
> General Discussion  --
http://lists.phillylinux.org/mailman/listinfo/plug
>




___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug