MySQL Database Connection Strings
MySQL is a relational database management system (RDBMS)
which has more than 11 million installations. The program
runs as a server providing multi-user access to a number of
databases.
MySQL is owned and sponsored by a single for-profit firm, the
Swedish company MySQL AB, now a subsidiary of Sun Microsystems, which holds the copyright to most of the
codebase. The project's source code is available under terms of
the GNU General Public License, as well as under a variety of
proprietary agreements.
"MySQL" is officially pronounced /maɪˌɛskjuːˈɛl/ (My S Q L),
not "My sequel" /maɪˈsiːkwəl/. This adheres to the
official ANSI pronunciation; SEQUEL was an earlier IBM database
language, a predecessor to the SQL language. However, the company does
not take issue with the pronunciation "My sequel" or other local
variations.
Other default schemas include:
- A broad subset of ANSI SQL 99, as well as extensions
- Cross-platform support
- Stored procedures
- Triggers
- Cursors
- Updatable Views
- True VARCHAR support
- INFORMATION_SCHEMA
- Strict mode
- X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using Oracle's InnoDB engine
- Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity, MySQL Archive for storing historical data in little space)
- Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB
- SSL support
- Query caching
- Sub-SELECTs (i.e. nested SELECTs)
- Replication with one master per slave, many slaves per master, no automatic support for multiple masters per slave.
- Full-text indexing and searching using MyISAM engine
- Embedded database library
- Partial Unicode support (UTF-8 sequences longer than 3 bytes are not supported; UCS-2 encoded strings are also limited to the BMP)
- ACID compliance using the InnoDB, BDB and Cluster engines
- Shared-nothing clustering through MySQL Cluster
Variable Legend
| Variable Name | Substitute variable with: |
|---|---|
| Server | Replace with your server host address. |
| DBName | Replace with your database name |
| User | Replace with your database's username |
| Password | Replace with your database's password |
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=DBName; UID=User; PASSWORD=Password; OPTION=3"
MySQL OLE DB & OleDbConnection (.NET framework) connection strings
Open connection to MySQL database:
"Provider=MySQLProv;Data Source=DBName;User Id=User; Password=Password;"