Re: php+apache+mysql installation. Help
Do I need to uninstall the old Apache before installing the newer version? How do I uninstall the old Apache in linux? Do I just use the package manager to remove the package? What does make do? I don't know how linux work. Please advise. Thanks. >From: Andrew Lietzow <[EMAIL PROTECTED]> >To: "Andy Cheng" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] >Subject: Re: php+apache+mysql installation. Help! >Date: Thu, 23 May 2002 21:34:37 -0500 > >Dear Andy, > >Here's a thought. Before you go much further, install Apache 2.0.36. >It's >easy to install and lots of improvements will be gained that you'll >appreciate down the road, i.e. mod_ssl is preconfigured into the system. > >Andrew Lietzow >The ACL Group, Inc. > > >On Thursday 23 May 2002 06:33 pm, you wrote: > > Hi, > > > > I am new to linux and trying to install Apache, php and mysql on my >Redhat > > 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: > > > > checking whether build environment is sane..configure error:newly >created > > file is older than distributed files! > > > > I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my >box. > > Would appreciated if some one could advise how to install PHP. Thanks > > > > P.S. > > I have start Mysql manually. How do I make it auto start and shutdown? > > > > > > > > > > > > _ > > MSN Photos is the easiest way to share and print your photos: > > http://photos.msn.com/support/worldwide.aspx > > > > > > - > > 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 > >-- >Andrew Lietzow >The ACL Group, Inc. >515-274-0300 v/f >515-710-1955 c _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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
Re: php+apache+mysql installation. Help!
Dear Andy, Here's a thought. Before you go much further, install Apache 2.0.36. It's easy to install and lots of improvements will be gained that you'll appreciate down the road, i.e. mod_ssl is preconfigured into the system. Andrew Lietzow The ACL Group, Inc. On Thursday 23 May 2002 06:33 pm, you wrote: > Hi, > > I am new to linux and trying to install Apache, php and mysql on my Redhat > 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: > > checking whether build environment is sane..configure error:newly created > file is older than distributed files! > > I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my box. > Would appreciated if some one could advise how to install PHP. Thanks > > P.S. > I have start Mysql manually. How do I make it auto start and shutdown? > > > > > > _ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > > > - > 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 -- Andrew Lietzow The ACL Group, Inc. 515-274-0300 v/f 515-710-1955 c - 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
php+apache+mysql installation. Help!
Hi, I am new to linux and trying to install Apache, php and mysql on my Redhat 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: checking whether build environment is sane..configure error:newly created file is older than distributed files! I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my box. Would appreciated if some one could advise how to install PHP. Thanks P.S. I have start Mysql manually. How do I make it auto start and shutdown? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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
Re: Mysql installation. Help!
Great, the uppercase in $sth->{NUM_OF_FIELDS} works. Now I can start to
learn perl. Any advice on where could I find a good source for beginner on
the web? Thank you very much.
>From: ds <[EMAIL PROTECTED]>
>To: Andy Cheng <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: Mysql installation. Help!
>Date: 11 Mar 2002 19:41:08 +
>
>
>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.
>
>#!/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
>Hi,
>I'm not an expert in perl too, but i would correct your code to this:
>
>#!/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
>
>Note the uppercase in $sth->{NUM_OF_FIELDS}.
>Also remove the line "my $rows"... It's doing nothing there.
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
-
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
Re: Mysql installation. Help!
>
> 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.
>
> #!/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
Hi,
I'm not an expert in perl too, but i would correct your code to this:
> #!/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
Note the uppercase in $sth->{NUM_OF_FIELDS}.
Also remove the line "my $rows"... It's doing nothing there.
>
> >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 th
Re: Mysql installation. Help!
I don't think you need to know DBD::mysql (DBD::mysql is a DBD driver to
mysql). Go and have a look at the man page of DBI. You'll get what you
need.
Andy Cheng 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..tar.gz,
> > >> rebooted the system, then re-ran safe_mysqld --user=root.
> > >>
> > >> Mark
> > >>
> > >> - Original Message -
> > >> From: "Andy Cheng" <[EMAIL PROTECTED]&
Re: Mysql installation. Help
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..tar.gz,
>>>> rebooted the system, then re-ran safe_mysqld --user=root.
>>>>
>>>> Mark
>>>>
>>>> - Original Message -
>>>> From: "Andy Cheng" <[EMAIL PROTECTED]&
Re: Mysql installation. Help!
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..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
> >>> instal
Re: Mysql installation. Help!
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..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
Re: Mysql installation. Help!
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 Exupry 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..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
Re: Mysql installation. Help!
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..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. > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.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
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. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
Re: Ask for Linux+MySQL installation help
try to copy mysql libraries to /usr/local/lib and /usr/lib cp -a /usr/local/MySQL/lib/MySQL/* /usr/local/lib cp -a /usr/local/MySQL/lib/MySQL/* /usr/lib >From: "YANG" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Ask for Linux+MySQL installation help >Date: Fri, 2 Nov 2001 13:43:46 +0800 (CST) > >Dear Sir: > I want to ask some questions about Redhat Linux+MySQL installation. >1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43. Commands is as follws: ># cd /usr/local ># tar ¨Czxvf MySQL-3.23.443.tar.gz ># mv MySQL-3.23.43 /usr/local/MySQL ># cd /usr/local/MySQL ># ./configure ¨Cprefix=/usr/local/MySQL ># make ># make install >Instalation Success; >2. Then, I write a small program test.c to test the mysql database C API. The makefile is as follows: ># gcc ¨CI/usr/local/MySQL/include/MySQL ¨Cc test.c ># gcc ¨Co test test.o ¨CL/usr/local/MySQL/lib/MySQL ¨Cl/MySQLclient >Compile and link all success; >3. But, when I run the program, error occurs. Error message is as follows: ># ./test: error in loading shared libraries:libMySQLclient.so.6 cannot open shared object file: No such file or directory >4. I install MySQL Rpm Package in another computer. The version of Redhat Linux and MySQL is same as that mentioned previously. Instalation command is as follows: ># rpm ¨Ci MySQL-3.23.43-1.i386.rpm MySQL-client-3.23.43-1.i386.rpm MySQL-devel-3.23.43-1.i386.rpm MySQL-shared-3.23.43-1.i386.rpm > I compile and link it with same makefile. This time, everything is OK. > Because I want use Linux+MySQL+Apache+PHP in our system, I want install MySQL database with the first method. So I ask for helping as soon as possible. Thanks. > >My E-mail address is: [EMAIL PROTECTED] > > > > > > > _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - 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
Ask for Linux+MySQL installation help
Dear Sir: I want to ask some questions about Redhat Linux+MySQL installation. 1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43. Commands is as follws: # cd /usr/local # tar ¨Czxvf MySQL-3.23.443.tar.gz # mv MySQL-3.23.43 /usr/local/MySQL # cd /usr/local/MySQL # ./configure ¨Cprefix=/usr/local/MySQL # make # make install Instalation Success; 2. Then, I write a small program test.c to test the mysql database C API. The makefile is as follows: # gcc ¨CI/usr/local/MySQL/include/MySQL ¨Cc test.c # gcc ¨Co test test.o ¨CL/usr/local/MySQL/lib/MySQL ¨Cl/MySQLclient Compile and link all success; 3. But, when I run the program, error occurs. Error message is as follows: # ./test: error in loading shared libraries:libMySQLclient.so.6 cannot open shared object file: No such file or directory 4. I install MySQL Rpm Package in another computer. The version of Redhat Linux and MySQL is same as that mentioned previously. Instalation command is as follows: # rpm ¨Ci MySQL-3.23.43-1.i386.rpm MySQL-client-3.23.43-1.i386.rpm MySQL-devel-3.23.43-1.i386.rpm MySQL-shared-3.23.43-1.i386.rpm I compile and link it with same makefile. This time, everything is OK. Because I want use Linux+MySQL+Apache+PHP in our system, I want install MySQL database with the first method. So I ask for helping as soon as possible. Thanks. My E-mail address is: [EMAIL PROTECTED]
Ask for Linux+MySQL installation help
Dear Sir: I want to ask some questions about Redhat Linux+MySQL installation. 1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43. Commands is as follws: # cd /usr/local # tar ¨Czxvf MySQL-3.23.443.tar.gz # mv MySQL-3.23.43 /usr/local/MySQL # cd /usr/local/MySQL # ./configure ¨Cprefix=/usr/local/MySQL # make # make install Instalation Success; 2. Then, I write a small program test.c to test the mysql database C API. The makefile is as follows: # gcc ¨CI/usr/local/MySQL/include/MySQL ¨Cc test.c # gcc ¨Co test test.o ¨CL/usr/local/MySQL/lib/MySQL ¨Cl/MySQLclient Compile and link all success; 3. But, when I run the program, error occurs. Error message is as follows: # ./test: error in loading shared libraries:libMySQLclient.so.6 cannot open shared object file: No such file or directory 4. I install MySQL Rpm Package in another computer. The version of Redhat Linux and MySQL is same as that mentioned previously. Instalation command is as follows: # rpm ¨Ci MySQL-3.23.43-1.i386.rpm MySQL-client-3.23.43-1.i386.rpm MySQL-devel-3.23.43-1.i386.rpm MySQL-shared-3.23.43-1.i386.rpm I compile and link it with same makefile. This time, everything is OK. Because I want use Linux+MySQL+Apache+PHP in our system, I want install MySQL database with the first method. So I ask for helping as soon as possible. Thanks. My E-mail address is: [EMAIL PROTECTED]
Re: MySQL Installation Help Requested.
> > grant all privileges on *.* to jbrunk@"%" > > and it goes into the user table of the database mysql, and shows that the > host that jbrunk is allowed to connect from is "%" but it won't let me > connect from mysqlfront did you "FLUSH PRIVILEGES" ? Greetings, Ansgar - 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
Re: MySQL Installation Help Requested.
i originally tried to do it with the /stand/sysinstall on bsd, and it installs it fine, but i am using the program MySQLFront to try and access it, and it keeps coming up "Host perm202-202.ij.net is not allowed to connect to this mysql server" the host name perm202-202.ij.net is host of my workstation since i am on a static ip, but i used grant all privileges on *.* to jbrunk@"%" and it goes into the user table of the database mysql, and shows that the host that jbrunk is allowed to connect from is "%" but it won't let me connect from mysqlfront Jason - Original Message - From: "Peter Matulis" <[EMAIL PROTECTED]> To: "'Jason Brunk'" <[EMAIL PROTECTED]> Sent: Wednesday, June 27, 2001 2:12 PM Subject: RE: MySQL Installation Help Requested. > From RPM, binary, or source? I have my personal docs for source. > > Peter Matulis > 282-7073 ext 392 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > -Original Message- > From: Jason Brunk [mailto:[EMAIL PROTECTED]] > Sent: June 27, 2001 12:43 PM > To: [EMAIL PROTECTED] > Subject: MySQL Installation Help Requested. > > > is there anyone who icq and who has a few minutes that might be willing to > help me out with the mysql install? i have been having some trouble, so i > figured i would check and see if there was anyone who could help a newbie > out. > > Jason > > > - > 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
MySQL Installation Help Requested.
is there anyone who icq and who has a few minutes that might be willing to help me out with the mysql install? i have been having some trouble, so i figured i would check and see if there was anyone who could help a newbie out. Jason - 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
