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: [EMAIL PROTECTED] ~]$ 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: [EMAIL PROTECTED] 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 -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
