Redash Not Connecting Azure Database for MySQL flexible server

[webliska]

Hello,

I tried to connect my Azure Database for MySQL flexible server in Redash but it's not getting connected.

I get an Internal Server Error when I try to Test Connection:

Any help is appreciated.

Thanks!

[james]

Hello @webliska
I moved this topic into the @redash category and made this a normal post.

---

Does the logs of the apps reveal anything when trying this?
Did you make sure that your Cloudron is allowed to connect to the MySQL instance? I hope your MySQL server is not publicly accessible by everyone?

[webliska]

When I try to connect nc -v mydb.mysql.database.azure.com 3306 from my Cloudron server to the Azure DB, it connects successfully.

I did not find any error's in Logs. Can you help me debug this?

[james]

Hello @webliska
nc only checks the ports' availability.
Unfortunately, I can't provide full support for Azure Database for MySQL.
But, you should check out the following article https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-public

From this page:

Only the IP addresses you allow have permission to access your Azure Database for MySQL Flexible Server instance. By default, no IP addresses are allowed. You can add IP addresses when initially setting up your server or after your server has been created.

The user that tries to connect is also important. Not every MySQL User is allowed to access the server from anywhere.
Also, this page: https://learn.microsoft.com/en-us/azure/mysql/how-to-create-users#create-a-nonadmin-user

Note: on CREATE USER 'username'@'host'.
In many guides for 'host' the value % is used to allow everything, which is considered a bad practice.
A good example is here: https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql#step-2-create-a-remote-mysql-user

Maybe these tips already help you resolve your issue.