Connection string to use mySQL auth_windows
Posted: Fri 08 Apr 2016 21:34
I have a dotNet 4.0 EF6 web application and am testing the possibility of porting the backend DB to mySQL. My application requires that the domain user that is used to authenticate the IIS App Pool be able to read and write to the database. I have successfully used dotConnect to make a connection to the mySQL DB using a standard connection string for a mySQL login. But as I said, I need the domain app pool user to be able to login to mysql. I have installed, enabled and tested the mySQL windows authentication plugin while logged in as the app pool user and it worked fine. So the final step is to update web.config with the correct devart connection string to use Windows authentication. I have looked everywhere but cannot find this information anywhere.
What is the connection string for windows authentication?
What is the connection string for windows authentication?