Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an AZURE virtual machine with a MySQL server installed on it running ubuntu 13.04. I am trying to remote connect to the MySQL server however get the simple error "Can't connect to MySQL server on {IP}"

I have already done the follow:

* commented out the bind-address within the /etc/mysql/my.cnf
* commented out skip-external-locking within the same my.cnf
* "ufw allow mysql"
* "iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT"
* setup an AZURE endpoint for mysql
* "sudo netstat -lpn | grep 3306" does indeed show mysql LISTENING
* "GRANT ALL ON *.* TO remote@'%' IDENTIFIED BY 'password';
* "GRANT ALL ON *.* TO remote@'localhost' IDENTIFIED BY 'password';
* "/etc/init.d/mysql restart"
* I can connect via SSH tunneling, but not without it
* I have spun up an identical ubuntu 13.04 server on rackspace and SUCCESSFULLY connected using the same procedures outlined here.

NONE of the above works on my azure server however. I thought the creation of an endpoint would work, but no luck. Any help please? Is there something I'm missing entirely?

enter image description here

share|improve this question
    
What is the error you receive when connecting to the MySQL server? – Michael Hampton Oct 31 '13 at 0:21
    
ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (60) – Rees Oct 31 '13 at 1:01
    
Try disabling Direct Server return. – proteus Apr 10 '14 at 19:44
    
Here is official manual for Azure VM: manual – Nikolay Bronskiy Feb 23 '15 at 0:57

The 'official manual' quoted above didnt work for me and seems to set up a ssh tunnel to accomplish this... even after following the guide it still didnt work.

Heres my working solution

For a Ubuntu Azure VM see:

https://azure.microsoft.com/en-us/documentation/articles/virtual-machines-linux-create-lamp-stack/

Specifically the section "Allow remote access to MySQL"

Comment out:

 bind-address = 127.0.0.1 

located at /etc/mysql/my.cnf

run

 sudo service mysql restart

and my remote connections worked --- just make sure port 3306 is open in the azure server portal for your vm!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.