[mythtv-users] 0.28 upgrade issue frontend connection

[Hika van den Hoven]

Hoi Steve,

Saturday, July 16, 2016, 11:30:57 PM, you wrote:

> I thought that was what mythtv.cnf was for, which I've set to my 
> local ip.  I just tried setting mysqld.cnf
> "bind-address=my_ip_address"  and it hasn't worked. 

> I can still manually call up mysql -umyth  -p, but mysql
> -h192.168.1.x -umyth -p gives me ERROR 1045 (28000):  Access denied
> for user 'mythtv'@'my_hostname' (using password: YES). 
> Incidentally, same with the root mysql account. I can connect from
> my secondary backend via the ip address. It just won't accept an
> login via the IP address local to the server.

> Steve

> On Sat, Jul 16, 2016 at 3:27 PM, Steve Greene <sgreene59 at verizon.net> wrote:

> Since upgrading to 0.28 and Mint 18, my local frontend connects to
> "localhost" but not the IP address of the MBE (which is local). 

> mysql -h"my_IP_ADDR" -u myth -p will fail, but mysql -umythtv -p
> will connect. Do I have to add the IP address to one of the tables in mythconverg?

> Thanks in advance for your assistance.

> Steve
>  

Have you setup a user for that location in mysql. You have to setup
the user/password for the locations from where you want to have
access. So localhost or an IP address or % for all machines.

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens