Sorry I don't know perl. I am PHP man. And I am stll trying to learng mysql
so that I can get it working to the way I want.
Chuck Payne
Magi Design and Support
on 3/10/02 7:30 PM, Andy Cheng at [EMAIL PROTECTED] wrote:
> 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
>
---------------------------------------------------------------------
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
