How to connect to MySQL in C# using default credentials -


i trying connect mysql database c# using default credentials. able connect following code. argument used here 1 suggested mysql.

    connecttomysql(@"server=my_server;userid=my_id;password=my_password;database=my_database");      public static mysqlconnection connecttomysql(string connectioninfo)     {         try         {             //instantiate connection             mysqlconnection mysqlconn = new mysqlconnection(connectioninfo);              //open , close mysql connection make sure works. can re-opened later             mysqlconn.open();             mysqlconn.close();              //return connection             return mysqlconn;         }         catch (exception e)         {             // print off error message , return null connection             //throw exception, log error             string n = environment.newline;             file.appendalltext("\\logfile.txt", "failed connect mysql." + n + e.tostring() + n + n);             throw new exception ("failed connect mysql. ");         }     } 

now have working, want create argument using

system.net.credentialcache.defaultcredentials 

to generate password , username. problem there doesn't seem way default credentials string format. realize prompt user enter credentials, doesn't work application i'm programming. working in visual studios express 2013 creating windows form application. don't have connect using system.net.credentialcache.defaultcredentials, open other solutions.


Comments