Access denied for user: 'mythtv@localhost'

[Red Knuckles]

Trying to get mythtv working in Gutsy beta. I can't get 'mythtv-setup' to run because 'Access denied for user: 'mythtv@localhost'. Here's some info:

$ grep mythtv: /etc/group
mythtv:x:120:red
$ rm ~/.mythtv -rf

and then rebooted and tried again, no luck. I found this link:

https://help.ubuntu.com/community/My...roubleshooting

What are they telling me here:

If you still can't connect, you can change the password. See instructions below with the small change of the instruction. Instead of

UPDATE user SET Password=PASSWORD('<password>') WHERE user='root';
FLUSH PRIVILEGES;

you can set mythtv password to the default (mythtv):

UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
FLUSH PRIVILEGES;

Looks like they're talking about mysql so if I try to reset pw in mysql:

[$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1151
Server version: 5.0.45-Debian_1ubuntu2-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
ERROR 1046 (3D000): No database selected/code]

How can I fix this so I can run 'mythtv-setup'???  ??? ??? ???

[SheeEttin]

Re: Access denied for user: 'mythtv@localhost'

You might want to install the "mysql-admin" package through Adept. It's a GUI for MySQL administration.
(You will need to enable the universe repository if you have not already done so.)

[blodian]

Re: Access denied for user: 'mythtv@localhost'

I thought I had to add this as I could not believe it, MythTV cant read. I have spent hours trying to get MythTV
to work with out success, I would get the above message all the time. The solution in the end was so simply but so odd. MythTV had wrongly entered its own password. In MythTV-setup the password was set as BLEalto5 but when I tried cat /etc/mythtv/mysql.txt the password was given as BLEaito5, entering this got it working. Worth checking if you're having trouble.