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: > > [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 > > _______________________________________________ > mythtv-users mailing list > [EMAIL PROTECTED] > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users > -- Lan Barnes SCM Analyst Linux Guy Tcl/Tk Enthusiast Biodiesel Brewer -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
