On Thursday 24 Sep 2015 12:58:32 Roger Munford wrote:
> I am having the perennial problem of connecting remotely to a MySQL
> database. I have no experience of administering MySQL myself and I am
> not confident that the person at the other end has had much either.
> I gave them my (fixed) ip address and received a user name and password
> back. I am using the MSQL workbench and have a couple of remote
> connections which work.
>
> Is there anything here that I may not know about or is there anything
> that I could suggest to my colleague.
What happens if you telnet to port 3306 on the database machine, what
do you get? e.g. "telnet 20.30.40.50 3306"
If you get a simple connection refused, then MySQL may not even be
listening (or it's being blocked by a firewall).
I think MySQL is configured by default to not allow remote connections.
In the my.conf file (/etc/mysql/my.conf on Ubuntu) there is an option
for bind-address which defaults to 127.0.0.1
This means that MySQL isn't even listening for remote connections,
so setting GRANT options for users and databases will have no effect.
If they set this to 0.0.0.0 (listen on all networks), and restart MySQL,
then you may have more luck.
When MySQL is reachable, telnet should give you "Connected to ..." then
a load of garbage (you can't do anything useful over telnet, but it tells
you if MySQL is there or not).
--
Be seeing you, Games: http://www.glendale.org.uk/
Sam. Posts: http://www.google.com/+SamuelPenn
--
Please post to: Hampshire@???
Web Interface:
https://mailman.lug.org.uk/mailman/listinfo/hampshire
LUG URL:
http://www.hantslug.org.uk
--------------------------------------------------------------
