MySQL database with ASP .NET

Question

Hello,

I want to use MySql database with ASP .NET application using DBLINQ. I am following the link -

http://www.primaryobjects.com/CMS/Article100.aspx

But, I am not able to connect MySQL file with ASP .NET application.

What are exact steps to attach MySql file with .NET application?

Thank you

Answer 1

Try different connection string from ConnectionStrings.com

Answer 2

If you have not done this before, I would check first if the user can connect to mysql out of the .NET application with a GUI admin (SQLYog for example - but not phpMyAdmin as it connects as localhost on the server and your app not) from the same machine the application runs. You need the same user in mysql with the right host (or %) if mysql server is not running on the same machine. The user needs also at least SELECT right on the database you will use.