How do I enable this type of command on a mysql server and what is it?
I see it client code:
//$dsn = "mysql://root@localhost/username";
//$dsn = "mysql://[email protected]/pass";
Normally I would expect:
$con=mysql_connect($db,$dbuSER,$dbpass);
Asked
Active
Viewed 1.8k times
4
TheBlackBenzKid
- 26,324
- 41
- 139
- 209
-
1That looks similar to the DSN used in a PDO constructor, but I don't know what API uses that exact format. – Michael Berkowski Feb 08 '12 at 13:56
-
1Since you have access to the code that uses this, locate a connection call and post it. – Michael Berkowski Feb 08 '12 at 13:59
-
It says it is using PEAR - PEAR DB driver - any idea? – TheBlackBenzKid Feb 08 '12 at 14:28
-
2Ok, the PEAR DB module is becoming less common. See the documentation at http://pear.php.net/manual/en/package.database.db.intro-dsn.php – Michael Berkowski Feb 08 '12 at 14:31
-
Why is it less common? Speed? – TheBlackBenzKid Feb 08 '12 at 14:44
-
I would assume because PDO is a more officially supported extension. I've not worked with PEAR::DB in a long time to know its current state. – Michael Berkowski Feb 08 '12 at 14:48
1 Answers
5
In PHP using the PEAR::DB package to open a connection without an external DSN (a "DSN-less connection", i.e., using a Connection String), the code might resemble the following:
require_once("DB.php");
//$dsn = "<driver>://<username>:<password>@<host>:<port>/<database>";
$dsn = "mysql://john:pass@localhost:port/my_db";
$db = DB::connect($dsn);
TheBlackBenzKid
- 26,324
- 41
- 139
- 209