Reputation: 2230
But unluckily it seems I can't get the layer to work, all I see are my local mysql databases, what am I doing wrong? of course I'm connecting to the correct port.
It seems that I connect to the default mysql server even if I give a non existant port
Upvotes: 2
Views: 1626
Reputation: 186
Another option to force mysql to connect to the specified port and ignore the socket is to specify the --protocol
option explicitly.
I have searchd (SphinxQL) listening on port 9306. To connect:
mysql --port=9306 --protocol=tcp
See: http://dev.mysql.com/doc/refman/5.0/en/connecting.html
Upvotes: 3