Mythtv and mysql, strange error

Ossar · 12-12-2004, 03:59 PM

You ahve probably guessed what I'm trying to accomplish. When running mythtv-setup I get the following error:

Code:

Unable to connect to database!
Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@192.168.0.10' (Using password: YES)

Unable to open database:
Driver error was:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@192.168.0.10' (Using password: YES)

But when connecting to the database manually:

Code:

mysql -umythtv mythconverg

It works fine!

So how do I turn of password checking in mythtv-setup, or what password does the default mythtv user have?

digitalb0y · 12-18-2004, 09:55 PM

it looks like you did not create the file .my.cnf in the /root directory which contains your password? (replacing new-password with the password you created.

Code:

[client]
password = new-password