Re: Perl-mysql
- From: jm5379@xxxxxxxxx (Jm)
- Date: Wed, 30 Aug 2006 09:03:25 -0500
first, sharing the error message you get when trying to connect will
help isolate the actual cause of the problem.
second, getting rid of all the extraneous whitespace in your code
fragment will help in reading the code.
as for possible causes of the error:
1. DBI->connect syntax may be incorrect (i haven't looked it up to verify)
2. ip address may no longer be correct if it is a dynamic ip (even on
a home system)
3. networking for mysql may not be active
4. mysql may not be running
5. user "root" may not be allowed to connect via network (ie.
external) connection
6. user "root" may not have the same password you are passing
7. database "employee" may not exist or may be corrupt
there could be other possibilities, these are just the ones that come to mind.
On 8/30/06, Manne, Siva Chaitanya Prasad
<SivaChaitanya.Manne@xxxxxxxxxxxxx> wrote:
Hi,
I would like to connect to a database stored at linux
machine from my Windows machine. But I am unable to connect to the mysql
server.
Please help me regarding this issue.
************************************************************************
****************************
use DBI;
$dbh = DBI->connect("DBI:mysql:employee:xxx.xxx.xxx.xx", 'root',
'abc123',
{ RaiseError => 1 }
);
#do something here
}
$dbh->disconnect();
Thanks in advance
--
siva
--
since this is a gmail account, please verify the mailing list is
included in the reply to addresses
.
- Follow-Ups:
- Perl-mysql
- From: Siva Chaitanya Prasad Manne
- Perl-mysql
- References:
- Perl-mysql
- From: Siva Chaitanya Prasad Manne
- Perl-mysql
- Prev by Date: Perl-mysql
- Next by Date: Re: Perl-mysql
- Previous by thread: Perl-mysql
- Next by thread: Perl-mysql
- Index(es):
Relevant Pages
|
