[mythtv-users] Update: root user created, but unusable: errors 1044 and 1045.

[John Pilkington]

On 14/01/2021 22:05, A. F. Cano wrote:
> On Thu, Jan 14, 2021 at 02:31:28PM -0500, A. F. Cano wrote:
>> Hello everyone,
>>
>> Latest update: Now mysql is totally inaccessible, so the mythtv server doesn't
>> even start.  I left all the details of how I got to this point for
>> completeness.
> 
> That is still the case, I did manage to create the root user but I can't
> do anything with it.  At least I can start mysql -u root but nothing
> else works.  I also re-created the mythtv user.   Even flush privileges
> doesn't work.  Obviously just re-creating the root user wasn't enough,
> how do I give it the privileges it needs?
> 
> Thanks.
> 
> Augustine

I'm far from being a DB guru and I'm reluctant to jump in here, but last 
July I had DB access problems which seemed to arise after an upgrade 
from trying to follow conflicting sets of instructions relating to 
'root'   With guidance from Bill Meek I was able to recover and it's 
just possible that you might find it helpful too.  It's here, in the 
last couple of posts in this thread - and FWIW it was a Fedora box.  I 
think the real meat is at "Here's the entire set of commands:"

https://lists.archive.carbon60.com/mythtv/users/632838#632838

John P