[mythtv-users] Remote frontend access denied

[Bill Meek]

On 11/21/19 12:42 PM, Don Brett wrote:
> 
>  >> */etc/mysql/mysql.conf.d/mysqld.cnf*
>  >> # removed 11/17/2019
>  >> #bind-address           = 127.0.0.1
>  >>
>  >> # trying this 11/18/2019...didn't help
>  >> #bind-address           = 0.0.0.0
>  >>
>  >> */etc/mysql/mysql.conf.d/mythtv.cnf*

Yes, mysql is the correct database. See if the encrypted authentication
strings are the same:

     SELECT Host,User,authentication_string FROM user WHERE User='mythtv';

(replace authentication_string with Password if you get a 'Unknown column'
  response)

You can see the encrypted password with this: SELECT PASSWORD('mythtv');

Maybe: https://stackoverflow.com/questions/12877458/mysql-error-1133-cant-find-any-matching-row-in-the-user-table
would help.

-- 
Bill