Opened 3 years ago

Closed 3 years ago

#12844 closed Bug Report - General (Invalid)

Access denied for user 'mythtv'@'localhost'

Reported by: jbeck2@… Owned by:
Priority: minor Milestone: unknown
Component: MythTV - General Version: Unspecified
Severity: medium Keywords:
Cc: Ticket locked: no

Description

As per subject line.

I have tried SEVERAL listed ways to fix this, but:

1). there is no reason for this to EVER happen on an install - this problem has been reported for YEARS. 2). NONE of the reported ways t fix this have worked. 3). why is this STILL a problem???

Since mythtv DOES NOT WORK without this being fixed, it is ANYTHING but MINOR.

Attachments (1)

bug_report (15.7 KB) - added by jbeck2@… 3 years ago.
text file of error message

Download all attachments as: .zip

Change History (2)

Changed 3 years ago by jbeck2@…

Attachment: bug_report added

text file of error message

comment:1 Changed 3 years ago by Jonatan Lindblad

Priority: blockerminor
Resolution: Invalid
Severity: highmedium
Status: newclosed

The error indicates that MySQL does not accept the credentials provided. The following command should fail in the same way:

mysql -umythtv -pWA764MyE -hlocalhost mythconverg

You can try with 192.168.1.80 instead of localhost to see if that works.

Configuration of the MySQL server is however not MythTV's responsibility. If you installed from source it is up to you to configure MySQL, see Build from Source. If MythTV was installed from packages provided by your distribution you might seek support from them, they might have special commands to reconfigure MySQL.

Should you want to try to change the password yourself, the following should work:

mysql -u root -p mysql
mysql> UPDATE user SET Password=PASSWORD('WA764MyE') WHERE user='mythtv';
mysql> FLUSH PRIVILEGES;
mysql> quit

Since this issue does not seem to stem from a fault in MythTV, I will close this ticket. If you have some information that strongly suggests otherwise, you are welcome to reopen the ticket.

Should you open a new ticket in the future, please read the TicketHowTo. You did not specify the MythTV version and changed the severity and priority. Note also that saying that you tried 'several listed ways' to fix it is not very helpful without stating which those ways were.

For further assistance please use the mailing list, IRC, or the forum.

Note: See TracTickets for help on using tickets.