On Thu, Jul 12, 2012 at 12:20 PM, Reindl Harald h.reindl@thelounge.netwrote:
Am 12.07.2012 20:15, schrieb Ski Dawg:
Using your string, I can now telnet to port 22222 on localhost (hostA)
and
I get the mysql connection string (from hostB), but it is not able to
make
a mysql connection (using mysql -u user -p -h localhost --port=22222 from hostA), with a test user that I set up to allow connections from
anywhere.
The error that I am getting is: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
learn mysql-basics!
localhost is ALWAYS unix-socket the error message is really clear!
use 127.0.0.1 if you want to use TCP which is what happens with port-forwarding!
Thanks. This worked. I have not ever run across this issue before, so I didn't know that using localhost tied mysql to only a socket connection, but now I do.