This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 59%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Hello,
I'm using a web API for a project where I'm working on, the problem is, when i try to connect to the MySQL In app I get this error:
One or more errors occurred. (An attempt was made to access a socket in a way forbidden by its access permissions.)
I got the connection string from the MYSQLCONNSTR_localdb.ini file.
It looks like this: Database=localdb;Data Source=127.0.0.1;User Id=azure;Password=password
I am using the MySql.Data package to connect.
I'm pretty new to azure, this is just something I need to do for my project. I hope I could get some help. Thanks in advance!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
that connect string is for a local MySql server (same server as the website). If you deploy to azure, MySql will not be on the same server, nor will it be able to access your local MySql.
You will need to create a MySql instance in azure, and use its connect string.
Yes thats what I want, The local one, I'm using a free student account, if I add a mysql instance, it's kind of really expensive. I'm already hosting the web app, and the MySQL in app is already set up with the localdb table. I have set up as start page that it tries to connect to the connection string when you go to the base url, that is where I get the error.
Check here: https://polyrushapi.azurewebsites.net
not sure what you are saying. MySql is service that is installed. on your dev box, you installed asp.net core and MySql. unless you are using an azure virtual machine, you need a MySql instance for you website to access. to access the MySql on you dev box, you would need to install virtual vpn routing software so an azure website could connect to you dev box. this is probably more expensive than a MySql instance.
with your student account, you could also use a serverless managed Azure Sqlserver instance. this is probably cheaper.