So I can't connect to my azure MySQL database to install umbraco. The umbraco files are already on my azure web app. When I try the same settings to test db connection in Visual studio, it works fine.
Picture from my site on azure, shows I can't connect to MySQL db
Picture from Visual studio showing that the same settings work fine
I tried copying the custom string from azure and pasting it in the umbraco install but that doesnt work either.
If you're asking if both screenshots are from the same machine, then yes.
The database was freshly created in azure, I dont think theres data in it, but even if there was it should still be able to connect and start installing
It should yes, but I have seen it before. Not sure off the top of my head what it could be. All the connection string are the same. While you can connect to the database do you have permissions to create, update, delete. Could you run some SQL in an app to test this is visual studio. I figure that user does not have the correct permissions?
I went to connect with my server so I had find the solution as below:
Choose the last option "Custom connection string" from Database
Type.
Write Server=your mysql server name; Port=3306(default of
MySql); Database=your database name;Uid=your server
username;Pwd=your server password in connection string box.
Click on Continue.
It will accept the above steps and continue for the next installations.
Can't connect to MySQL DB through Umbraco Install
So I can't connect to my azure MySQL database to install umbraco. The umbraco files are already on my azure web app. When I try the same settings to test db connection in Visual studio, it works fine.
Picture from my site on azure, shows I can't connect to MySQL db
Picture from Visual studio showing that the same settings work fine
I tried copying the custom string from azure and pasting it in the umbraco install but that doesnt work either.
Hi where are you connecting from in the Screen Shot? The same machine?
Could you try an random database name?
I wonder if it because the database is already in use of has data in it?
If you're asking if both screenshots are from the same machine, then yes.
The database was freshly created in azure, I dont think theres data in it, but even if there was it should still be able to connect and start installing
It should yes, but I have seen it before. Not sure off the top of my head what it could be. All the connection string are the same. While you can connect to the database do you have permissions to create, update, delete. Could you run some SQL in an app to test this is visual studio. I figure that user does not have the correct permissions?
Hello,
Please refer the below links. It will helps you :
https://uskinned.net/guides/how-to-install-umbraco-7-on-azure/
https://msdn.microsoft.com/en-us/hh551143.aspx
Regards, Pradip
Hi All,
I had facing the same issue..
I went to connect with my server so I had find the solution as below:
Choose the last option "Custom connection string" from Database Type.
Write
Server=your mysql server name; Port=3306(default of MySql); Database=your database name;Uid=your server username;Pwd=your server passwordin connection string box.Click on Continue.
It will accept the above steps and continue for the next installations.
Regards,
Vighnesh
is working on a reply...