LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Ubuntu (https://www.linuxquestions.org/questions/ubuntu-63/)
-   -   Access denied for user: 'mythtv@localhost' (https://www.linuxquestions.org/questions/ubuntu-63/access-denied-for-user-mythtv%40localhost-589255/)

Red Knuckles 10-03-2007 09:04 PM

Access denied for user: 'mythtv@localhost'
 
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:

Code:

$ 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

Code:

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

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

Code:

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:

Code:

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

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

pljvaldez 10-04-2007 03:12 PM

Looks like you forgot to specify the database when you logged into mysql. Try
Code:

mysql -u root mythconverg
Then update the mythtv user's password.


All times are GMT -5. The time now is 02:53 AM.