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
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: 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
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 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
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
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: 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.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. _ 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
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.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
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.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
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.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
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.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
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.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
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: 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
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
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
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
