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
$ rm ~/.mythtv -rf
and then rebooted and tried again, no luck. I found this link:
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';
you can set mythtv password to the default (mythtv):
UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
Looks like they're talking about mysql so if I try to reset pw in mysql:
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
How can I fix this so I can run 'mythtv-setup'???