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?).
[snip]
Why do you think this? The message clearly tells you that the connection
is being rejected for the user mythtv with the client running on gypsy.
I see no indication that says it is trying to connect to gypsy. The
question is, WHICH machine is rejecting the connection? So how do you
know that the message is coming from gypsy trying to make a connection
to localhost instead of the connection trying to be made to xena and
being rejected there?
A quick check would be to disconnect xena from the network and try the
test again from gypsy and see if you get the same error message.
A better test would be to run a packet sniffer (Wireshark, previously
known as Ethereal) on gypsy to see what is going on in the network.
Gus
--
KPLUG-List@kernel-panic.org
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list