Thanks for the help. I got it working. I could connect to mysql from shell
command. Now I try to connect to mysql using perl. I installed the DBI::DBD
module for perl. I think the DBI::DBD also working since I don't see error
return running the following code:
#!/usr/bin/perl
use DBI;
$dbh=DBI->connect('DBI:mysql:andy');
my $query="select * from client";
my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
$sth->execute;
my $rows;
while(@row=$sth->fetchrow_array)
{my $i;
for $i (0..($sth->{num_of_fields}-1))
{print "[".$row[$i]."]";}
print("\n");
}
$sth->finish;
$dbh->disconnect
I don't understand the code. I copy it from a book. I am trying to print out
the records returned from a query. I have a table named client in database
andy. The table has 2 records. When I run the above code, I have 2 blank
lines return. Could any one tell me what the problem is? Where could I
find better documentation on DBI::DBD::mysql stuff for beginner? man
DBD::mysql is difficult to understand. Thanks again for the info.
>From: "Chuck \"PUP\" Payne" <[EMAIL PROTECTED]>
>To: Doug Thompson <[EMAIL PROTECTED]>, Andy Cheng
><[EMAIL PROTECTED]>, Intrex <[EMAIL PROTECTED]>,
>"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>Subject: Re: Mysql installation. Help!
>Date: Sun, 10 Mar 2002 14:18:13 -0500
>
>Ok, if never run it then you have to start once, if I remember right undex
>Red Hat, you have to go to /etc/rc.d/init.d and do this...
>
>./mysql start that will start it
>
>Then you will need to set it up so it will start later. SuSE you have to
>start it once....
>
>You will then need to set a password for mysql.
>
>I hope that helps.
>
>
> ----------------------------
> | Chuck Payne |
> | Magi Design and Support |
> | www.magidesign.com |
> | [EMAIL PROTECTED] |
> ----------------------------
>
>BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
>Web Design you can afford.
>
>Fortune for today --
>
>Q: How many Zen masters does it take to screw in a light bulb?
>A: None. The Universe spins the bulb, and the Zen master stays out
> of the way.
>
>
>
> > If mysql.sock doesn't exist, that is because the server is not running.
> >
> > I fought the same battle as Mark and ultimately downloaded and installed
>the
> > RPM for 3.23.49a from MySQL in place of
> > the copy that came with RH. The MySQL RPM installed and came up just
>like it
> > says in the book. Saves a lot of hair
> > and dain bramage.
> >
> > If the server process _is_ running, it may be useful to go through the
>section
> > on binary installation and check those
> > items to see if your RPM set everything up correctly. Don't bet on
>finding
> > anything, but it doesn't take long to do
> > these checks.
> > http://www.mysql.com/doc/I/n/Installing_binary.html
> >
> > Regards,
> > Doug
> >
> > "Perfection is finally attained not when there is no longer anything to
>add,
> > but when there is no longer anything to
> > take away." -- Antoine de Saint Exup?ry
> >
> > On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
> >
> >> What I did was beat my brains out on the same exact problem. In the
>end I
> >> have no clue what I did to get it actually working. I had re-installed
>the
> >> mysql from the .tar.gz, I installed all the RPM's several times.
>Everytime,
> >> I fully rebooted the system, and finally I have to run
> >> safe_mysqld --user=root
> >>
> >> I think finaly I ran the tar -zxvf on the mysqlmax.<version>.tar.gz,
> >> rebooted the system, then re-ran safe_mysqld --user=root.
> >>
> >> Mark
> >>
> >> ----- Original Message -----
> >> From: "Andy Cheng" <[EMAIL PROTECTED]>
> >> To: <[EMAIL PROTECTED]>
> >> Sent: Sunday, March 10, 2002 10:01 AM
> >> Subject: Mysql installation. Help!
> >>
> >>
> >>> Hi all,
> >>> I got this error message when trying to connect to mysql at the shell
> >>> command:
> >>>
> >>> Error 2002:Can't connect to local MySql server through socket
> >>> '/var/lib/mysql/mysql.sock
> >>>
> >>>
> >>> There is no mysql.sock in the /var/lib/mysql directory. Did I miss
>some
> >>> thing in the mysql installation? Where could I find the mysql.sock?
>I
> >>> install mysql that came with redhat 7.2. Thank for the help.
> >>>
> >
> >
> >
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
