PDO_MYSQL DSN

(PECL PDO_MYSQL >= 0.1.0)

PDO_MYSQL DSN — Connecting to MySQL databases

说明

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 host or port).
charset: The character set. See the character set concepts documentation for more information.

范例

Example #1 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

注释

Note: Unix only:

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 libmysqlclient then the location of the socket file is at libmysqlclient's compiled in location. If PDO_MYSQL is compiled against mysqlnd a default socket can be set thru the pdo_mysql.default_socket setting.

User Contributed Notes

FireDev 05-Feb-2020 05:32


The best way for me



$bdd= new PDO("mysql:host=localhost;dbname=test_db;charset=UTF8", "username", "password");

$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

divinity76 at gmail dot com 13-Oct-2019 04:07


here is the example i prefer myself, in my opinion, this is almost always "the correct way" to do it:


<?php





$db = new \PDO('mysql:host=localhost;dbname=testdb;charset=utf8mb4', 'username', 'password', array(


    \PDO::ATTR_EMULATE_PREPARES => false,


    \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION


));

yuqiangliu at outlook dot com 23-Apr-2019 09:40


$options = array(

    PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',

); 



SET NAMES utf8 is equivalent to



SET character_set_client = utf8;

SET character_set_results = utf8;

SET character_set_connection = utf8;

rhian 02-Dec-2016 03:13


xwisdom made a mistake in his comment and got it backwards, correction below:



If you are having problems accessing a remote MYSQL database, the solution is to make sure that you add a white-space after "mysql:"



Change this...:

mysql:host=remote;



...to this:

mysql: host=remote;



See original solution here:

http://stackoverflow.com/a/25432156

xwisdom at gmail dot com 07-Dec-2015 11:11


If you are having problems accessing a remote MYSQL database, the solution is to make sure that you remove any white-space after "mysql:" 



Change this...:

mysql: host=remote;



...to this:

mysql:host=remote;



See original solution here:

http://stackoverflow.com/a/25432156

siguza at siguza dot net dot IGNORETHIS 04-Jan-2015 02:24


It should be noted that unix_socket can also be used for named pipes under Windows.



<?php

$pipeName = 'my_awesome_pipe';

$username = 'username';

$password = 'password';

$dbh = new PDO('mysql:unix_socket='.$pipeName, $username, $password);

?>

codeslinger at compsalot dot com 11-Mar-2009 03:00


I have tested this and found that the "dbname" field is optional.  Which is a good thing if you must first create the db.



After creating a db be sure to exec a "use dbname;"  command, or else use fully specified table references.