Mysql – Unable to connect to thesql on Windows Azure Virtual Machine

azureMySQLremote-access

I created a virtual machine on Windows Azure. In that I installed MySQL. Every thing works fine on the server. I am not able to connect to MySQL remotely.

Steps performed:

Installed MySQL
Created user on it and give it access from % (all ips)
Allowed connection to MySQL (3306) in windows firewall
Created an endpoint in Windows Azure portal.

When I connect using xyz.cloudapp.net , I get an error with code (10060) .

I am not able to connect to any other service as well.

Best Answer

Either you will you use wha codingoutloud suggests or there is an option to purchase a public IP (paid service tho) and assign it to the Instance running MySQL, but i would not go that way only for a single port forwarding.

Related Solutions

Windows – I can’t connect to MySql from another machine

Look at the grants for your user.

In MySQL, grants are defined by the couple login, host. Maybe your user is only allowed to connect from localhost.

A show grants for user@'%'; will show you if you are allowed to connect, or not.

Mysql – Why can’t I remotely connect to MySQL running on the Azure VPS

You need to have Host specific entries in mysql.user table.

mysql> use mysql;
Database changed
mysql> select Host,User,Password from user;
+------------+------+-------------------------------------------+
| Host       | User | Password                                  |
+------------+------+-------------------------------------------+
| localhost  | root | *62395BB52702DE50773EBF629DD4AE90F07FFD94 |
| sgeorge-mn | root |                                           |
| 127.0.0.1  | root | *62395BB52702DE50773EBF629DD4AE90F07FFD94 |
| ::1        | root |                                           |
| localhost  |      |                                           |
| sgeorge-mn |      |                                           |
| localhost  | suku | *EAF5C8242B88A14545BB61062D64CA5207DD1A37 |
+------------+------+-------------------------------------------+
7 rows in set (0.01 sec)

So, follow me to create such a user with permission for remote access.

[ADDED] If you already have such a user, then try to follow the steps mentioned on me

Best Answer

Related Solutions

Windows – I can’t connect to MySql from another machine

Mysql – Why can’t I remotely connect to MySQL running on the Azure VPS

Related Topic