MySQL Forums
Forum List  »  Perl

Re: Error 10061: connect to MySQL server failed
Posted by: Jess McKenzie
Date: April 04, 2011 04:36PM

Randy,
I'm pretty naive, so please tell me if this is silly:
I looked in My Computer>Environmental Variables>System Variables
to see 3 paths: C:\Perl\site\bin C:\Perl\bin and
C:\Program Files\MySql\MySQL Server 5.5\bin

so i put copies of My.ini in each of those \bin folders. Then I tried this fragment:
#!/usr/bin/perl
#load module
use DBI();
#connect
my $dbh = DBI->connect("DBI:mysql:database=perltest;host=localhost", "user", "pass");

Here's the error msg: "DBI connect (database=perltest;host=localhost", "user", "pass") failed: Can't connect to MySQL server on 'localhost' (10061) at ...[[then it gives the folder\filename.pl of the script above]]
[[then it continues]]
line 6
ID:->('id') name:->('name') phone:->('phone') n

I'm still confused about all this. Have I misunderstood you?
~jess

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.