Copyright 1997-2010 the PHP Documentation Group.
PDO_MYSQL DSNConnecting to MySQL databases
Description
The PDO_MYSQL Data Source Name (DSN) is composed of the following elements:
- DSN prefix
The DSN prefix is
mysql:.-
host The hostname on which the database server resides.
-
port The port number where the database server is listening.
-
dbname The name of the database.
-
unix_socket The MySQL Unix socket (shouldn't be used with
hostorport).-
charset Currently ignored.
Examples
Example 22.155. PDO_MYSQL DSN examples
The following example shows a PDO_MYSQL DSN for connecting to MySQL databases:
mysql:host=localhost;dbname=testdb
More complete examples:
mysql:host=localhost;port=3307;dbname=testdb
mysql:unix_socket=/tmp/mysql.sock;dbname=testdb
Notes
When the host name is set to
"localhost", then the connection to
the server is made thru a domain socket. If PDO_MYSQL is
compiled against libmysql then the location of the socket file
is at libmysql's compiled in location. If PDO_MYSQL is
compiled against mysqlnd a default socket can be set thru the
pdo_mysql.default_socket setting.