'Can't get my azure sql server up and running
I'm getting crazy over this issue, I hope someone can help me:
I created an Azure Database for MySQL server
Disabled SSL, and allowed all IPs to access
Trying to connect to the server using Server name and Server admin login name
I tried MySQLWorkbench, and CLI mysql -u <Server admin login name> -h <Server name> -P 3306 -p
In both cases it freezes, no error messages, doesn't timeout, no logs on the azure side.
I have literally no idea what's wrong or what to do about it. The database was just created, totally untouched.
Has anyone experiences something similar before?
Thank you!
Solution 1:[1]
With the given information it's not clear what is the exact error while accessing the database, but if you have deployed it properly you can access it easily without any error using both, MySQL Workbench and CLI.
In your example, the sequence of parameter isn't in write format which might giving issue.
Try below format:
mysql -h <server_name>.mysql.database.azure.com -u <admin_name>@<server_name> -p
If using MySQL Workbench, you can refer official document Use MySQL Workbench to connect and query data in Azure Database for MySQL for the same.
This should work.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | UtkarshPal-MT |