Re: how to test a connection with mysql db

Hello, here are some things to check :

1) are you sure the mysql server is running? try to connect using the 'mysql' command.

2) double-check your parameters, hostname, port, username and password.

3) try with a simple snippet of code.

4) if it still doesn't work, post your code here.

here's the simplest exemple:

my $dbh = DBI->connect("DBI:mysql:database='database':host=localhost:p
+ort=3307,'root','password') or die "can't connect: $!";
[download]

Comment on Re: how to test a connection with mysql db Download Code

Replies are listed 'Best First'.
Re^2: how to test a connection with mysql db by Anonymous Monk on Jul 22, 2005 at 07:09 UTC
But what about: how do I know if my connection is still OK ? Is there a command to test the connection ? or what is the best way to test this ? Thanks Luca	[reply]
Re^3: how to test a connection with mysql db by wazoox (Prior) on Jul 22, 2005 at 07:17 UTC
You shouldn't have to worry that much about the connection; simply test the return value of each DBI statement, if it fails, then it MAY be because the connection's lost. `$dbh->something() or .... # put your error management code here`	[reply] [d/l]
Re^4: how to test a connection with mysql db by Anonymous Monk on Jul 22, 2005 at 07:42 UTC
What if the sql statement is wrong, than it also fails! Is there a difference between both ? Luca	[reply]
Re^5: how to test a connection with mysql db by wazoox (Prior) on Jul 22, 2005 at 09:34 UTC
Re^6: how to test a connection with mysql db by jeanluca (Deacon) on Jul 25, 2005 at 12:29 UTC
Some notes below your chosen depth have not been shown here