[plug] mythtv errors

[Craig Ringer]

On Tue, 2005-07-05 at 14:02 +0800, Daniel J. Axtens wrote:
> On 7/4/05, Caleb Duggan <caleb.duggan at gmail.com> wrote:
> > when i try to run mythtv, it flashes up with some blue screen for a
> > fraction of a second and in the console, it says the following:
> > 
> >         2005-07-04 21:16:20.480 Switching to square mode ()
> >         2005-07-04 21:16:20.484 Unable to connect to database!
> >         2005-07-04 21:16:20.487 Driver error was [1/1045]:
> >         QMYSQL3: Unable to connect
> >         Database error was:
> >         Access denied for user: 'mythtv at localhost' (Using password: YES)
> > 
> >         couldn't open db
> >         2005-07-04 21:16:20.488 Switching to square mode (blue)
> 
> While I don't know anything specifically about mythtv, it would seem
> that the MySQL server is not allowing you to connect under the
> username mythtv at localhost. Is the username and password correct? Is
> the server you are connecting to set up properly?

Try using:

mysql --host=localhost --user=mythtv mythtv --password

... and see if you can connect with that. I've guessed that the database
name is `mythtv' - if it's not, change it in the command line above.

If you can't, you need to fix your MySQL authentication setup before
continuing. This can be ... er ... interesting. You might want to get
familiar with the CREATE USER and GRANT commands, or use some MySQL
management GUI.

--
Craig Ringer