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

Lan Barnes lan at falleagle.net
Sun Aug 12 15:01:33 UTC 2007


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



More information about the mythtv-users mailing list