cant connect to azure mysql server

there are 2 firewalls the client operating system and the azure firewall.   in your machines azure settings you have to open up the firewall there.

@
David Johnson, CD yea i did that mate but its the same issue i might have missed something i guess

I think you will need to modify the config file to change the bind address to allow remote connections to the mysql.

https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql

@Iamthecreator OM no mate didnt work i did all of that and same issue

Note: If you can run phpMyAdmin, then you should already be using your local MariaDB/MySQL config.

There should be no... manual actions for this to work...

In other words, if you can see your database in your database list, then just select the database + access it.

Note: This will only work if you've installed a sensible Distro like Ubuntu with sensible phpMyAdmin packages. If you're using some other Distro or you've installed phpMyAdmin by hand (not from Distro packages), then all bets are off... meaning... how you access databases in this case can be complex.

Start by describing the Distro (looks like Ubuntu in your case), Distro version (lsb_release -a output), along with exactly how you installed phpMyAdmin.

Also mention if your MariaDB/MySQL instance is on the same machine or a different machine.

Tip: Using 3306 will likely fail, as normally you'll use localhost rather than an IP for access, so also mention how you're inputting port 3306 via phpMyAdmin.