[mythtv-users] Can only connect to mysql as localhost

Lan Barnes lan at falleagle.net
Sun Aug 12 15:11:51 UTC 2007


Please know I am now trying to

1. delete all mythtv entries of privilege in mysql.user and

2. reenter one reasonable rule as described here

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

I'll report back.

On Sun, August 12, 2007 8:01 am, Lan Barnes wrote:
> Added both to the my.cnf in the FE/BE server, not the FE clients (I
> figured the "restart" instruction indicated that).
>
> Results interleaved
>
> On Sun, August 12, 2007 7:43 am, David Campbell wrote:
>> Lan Barnes wrote:
>>> stuff
>>
>> add
>>
>> port = 3306 to /etc/my.cnf under [mysqld]
>>
>> restart mysql
>>
>
> Restarted but failed. This on the client:
>
> [lbarnes at gypsy ~]$ mysql -h xena -u mythtv -p mythconverg
> Enter password:
> ERROR 1045 (28000): Access denied for user 'mythtv'@'gypsy' (using
> password: YES)
>
> So the client (gypsy) is still looking for a local connection even though
> the "-h xena" flag is in the command and xena is in /etc/hosts (my home
> network is too small to justify DNS -- is that a problem here?).
>
> Remembering that one client box (hendriena) is connecting just fine, and
> the BE (xena) and another client (gypsy) are failing to connect to the IP
> address, I say again that I suspect the server mysqld is doing the right
> thing, but something about the config of these machines is telling client
> programs, local or distant, to go local only.
>
>> If that fails to amke the service available from the other server also
>> add
>>
>> bind-address            = mainipofserver
>>
>> and restart again
>>
>
> This just timed out on the restart and had to be commented out:
>
> [root at xena lbarnes]# /sbin/service mysqld restart
> Stopping MySQL:                                            [  OK  ]
> Timeout error occurred trying to start MySQL Daemon.
> Starting MySQL:                                            [FAILED]
>
>
>> Dave
>>
>
> Just to be complete, I'll try those lines in gypsy's my.cnf. FWIW, mysqld
> is not running on gypsy, so there can be no restart.
>
> --
> Lan Barnes
>
> SCM Analyst              Linux Guy
> Tcl/Tk Enthusiast        Biodiesel Brewer
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>


-- 
Lan Barnes

SCM Analyst              Linux Guy
Tcl/Tk Enthusiast        Biodiesel Brewer



More information about the mythtv-users mailing list