List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:March 14 1999 10:49am
Subject:problem with $dbh = DBI->Connect($data_source, $username, $auth)
View as plain text  
System Administrator a.k.a. The Root of the Problem writes:
 > I am have a problem with the above syntax 

Hello!

What is the problem exactly..? What is the error message you get?
You should use mysqlbug and please read the section 
"how to report bugs / problems" from the manual.

See server-cfg file which comes with MySQL distribution
and how the connection is done there.

You can do:

$dbh =
DBI->connect(DBI:mysql:$opt_db:$opt_host:port=$opt_port:mysql_socket=$opt_mysql_socket",
$opt_user,$opt_password, { PrintError => 0})

There you have:

$opt_db			== the database to use.
$opt_host		== hostname to use
$opt_port		== tcp port to use, normally 3306
$opt_mysql_socket	== unix socket to use, normally /tmp/mysql.sock

But you can use, for example, just

$dbh = DBI->connect(DBI:mysql:$opt_db) || die $DBI::errstr;

if you want to.

 > and that we have databases in the 
 > /var root directory that are being created.
 > 
 > 1) How do we contril where the db is created?

Please see mysqld --help, and you'll find that you can control
this with option -h (or: --datadir=path)

 > 2) When I call mysql, the database appears,
 > but when I use something like wdbi's mysqlfdf,
 > the programme cannot connect to an
 > active mysql; why?

See above and please read the MySQL manual, everything is
described there.

Regards,

Jani

-- 
+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___       ==  mysql@stripped         |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen             |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       mailto: jani@stripped      |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki                 |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+
Thread
problem with $dbh = DBI->Connect($data_source, $username, $auth)System Administrator a.k.a. The Root of the Problem13 Mar
  • problem with $dbh = DBI->Connect($data_source, $username, $auth)Jani Tolonen14 Mar