MySQL Connection Strings

MySQL ODBC connection strings

Open connection to local MySQL database using MySQL ODBC 3.51 Driver:

"Provider=MSDASQL; DRIVER={MySQL ODBC 3.51Driver}; SERVER= localhost; DATABASE=Your_MySQL_Database; UID= Your_Username; PASSWORD=Your_Password; OPTION=3"

MySQL OLE DB & OleDbConnection (.NET framework) connection strings

Open connection to MySQL database:

"Provider=MySQLProv;Data Source=Your_MySQL_Database; User Id=Your_Username; Password=Your_Password;"