Installation help ...!

2005-11-21 Thread Paul_Swingewood
Hello. I am a complete newbie here and to the world of Linux  MySQL.

I am trying to create a LAMP server

I have installed RedHat Enterprise Linux AS 4 - update 2 on my server and 
it seems to work ok.
I downloaded MySQL 5.0 and now want to install that 

I read somewhere that I need to remove rpm files from the server ... I 
think you can do this via add/remove programs in the RedHat Gui

How do I install MySQL on the server. I have tried quite a few times but I 
can never seem to get access to the MYSQL prompt ...

I get some error about a socket connection .

Is there any documentation available for installing MySQL 5.0 on to redhat 
..?

Many Thanks - Paul

***
The information contained within this e-mail (and any attachment) sent by 
Birmingham City Council is confidential and may be legally privileged. It is 
intended only for the named recipient or entity to whom it is addressed. If you 
are not the intended recipient please accept our apologies and notify the 
sender immediately, or telephone +(44) 121 464  Unauthorised access, use, 
disclosure, storage or copying is not permitted and may be unlawful. Any e-mail 
including its content may be monitored and used by Birmingham City Council for 
reasons of security and for monitoring internal compliance with the office 
policy on staff use. E-mail blocking software may also be used. Any views or 
opinions presented are solely those of the originator and do not necessarily 
represent those of Birmingham City Council. We cannot guarantee that this 
message or any attachment is virus free or has not been intercepted and amended.
***

Re: Installation help ...!

2005-11-21 Thread Tom Brown



Hello. I am a complete newbie here and to the world of Linux  MySQL.

I am trying to create a LAMP server

I have installed RedHat Enterprise Linux AS 4 - update 2 on my server and 
it seems to work ok.

I downloaded MySQL 5.0 and now want to install that 

I read somewhere that I need to remove rpm files from the server ... I 
think you can do this via add/remove programs in the RedHat Gui


How do I install MySQL on the server. I have tried quite a few times but I 
can never seem to get access to the MYSQL prompt ...


I get some error about a socket connection .

Is there any documentation available for installing MySQL 5.0 on to redhat 
..?


please outline HOW you installed many times - then show exect error messages

thanks


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Installation Help

2003-10-29 Thread Mike Nelson
Hi,
 
Im trying to install a newer version of Mysql on our Red Hat 2.1 AS.
I'm still new to Linux Installations.  I can't seem to figure out what
im doing wrong.
 
This is what I have tried, can somebody point me in the right direction
 

[EMAIL PROTECTED] root]# rpm -i MySQL-server-4.1.0-0.i386.rpm
error: failed dependencies:
MySQL-server conflicts with mysql-server-3.23.58-1.72
MySQL conflicts with mysql-3.23.58-1.72
[EMAIL PROTECTED] root]# rpm -U MySQL-server-4.1.0-0.i386.rpm
error: failed dependencies:
libmysqlclient.so.10   is needed by mod_auth_mysql-1.11-1
libmysqlclient.so.10   is needed by MySQL-python-0.9.0-2
libmysqlclient.so.10   is needed by perl-DBD-MySQL-1.2216-4
libmysqlclient.so.10   is needed by php-mysql-4.1.2-2.1.6

Thanks,
 
Mike.


 


**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**



RE: Installation Help

2002-11-13 Thread Phil Iovino
I wasn't sure if I was supposed to use 'root' or 'root@localhost' so I
did it for both. I'm still getting this:

[root@web01 phil]# /usr/local/mysql/bin/mysqladmin version
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

Ugh. :)

-Original Message-
From: Paul DuBois [mailto:paul;snake.net] 
Sent: Tuesday, November 12, 2002 7:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help


At 11:45 -0600 11/12/02, Black, Kelly W [PCS] wrote:
Make sure you issued the correct GRANT statements
at the sql, query.

mysqluse mysql;
Database Changed
mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 
mysql 'somepassword';

That's not quite right.

- GRANT * is not legal, I suspect you mean GRANT ALL.

- '[EMAIL PROTECTED]' is quoted incorrectly.  That is equivalent to
   '[EMAIL PROTECTED]'@'%'.  I suspect you mean
'userid'@'hostname.com'.
   (user and host parts should be quoted separately.)


#note that will give FULL access...see the docs to restrict this.
mysql FLUSH PRIVILEGES;
0 Rows Affected.

~Kelly W. Black



-
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: Installation Help

2002-11-13 Thread Black, Kelly W [PCS]
Right.

My mistake.

I think you get the general idea.

~K Black

-Original Message-
From: Paul DuBois [mailto:paul;snake.net]
Sent: Tuesday, November 12, 2002 4:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help


At 11:45 -0600 11/12/02, Black, Kelly W [PCS] wrote:
Make sure you issued the correct GRANT statements
at the sql, query.

mysqluse mysql;
Database Changed
mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY
'somepassword';

That's not quite right.

- GRANT * is not legal, I suspect you mean GRANT ALL.

- '[EMAIL PROTECTED]' is quoted incorrectly.  That is equivalent to
   '[EMAIL PROTECTED]'@'%'.  I suspect you mean 'userid'@'hostname.com'.
   (user and host parts should be quoted separately.)


#note that will give FULL access...see the docs to restrict this.
mysql FLUSH PRIVILEGES;
0 Rows Affected.

~Kelly W. Black


-
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: Installation Help

2002-11-13 Thread Black, Kelly W [PCS]
Sorry I made a mistake as Paul pointed out.

I meant 

GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';

If you use the localhost substitution for the fully qualified domain name
then be sure your /etc/hosts file has a line at the top like

127.0.0.1 localdomain.localhost localhost


~Kelly W. Black
-Original Message-
From: Phil Iovino [mailto:phil;nxtek.net]
Sent: Wednesday, November 13, 2002 10:36 AM
To: 'Paul DuBois'; Black, Kelly W [PCS]; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help


I wasn't sure if I was supposed to use 'root' or 'root@localhost' so I
did it for both. I'm still getting this:

[root@web01 phil]# /usr/local/mysql/bin/mysqladmin version
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

Ugh. :)

-Original Message-
From: Paul DuBois [mailto:paul;snake.net] 
Sent: Tuesday, November 12, 2002 7:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help


At 11:45 -0600 11/12/02, Black, Kelly W [PCS] wrote:
Make sure you issued the correct GRANT statements
at the sql, query.

mysqluse mysql;
Database Changed
mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 
mysql 'somepassword';

That's not quite right.

- GRANT * is not legal, I suspect you mean GRANT ALL.

- '[EMAIL PROTECTED]' is quoted incorrectly.  That is equivalent to
   '[EMAIL PROTECTED]'@'%'.  I suspect you mean
'userid'@'hostname.com'.
   (user and host parts should be quoted separately.)


#note that will give FULL access...see the docs to restrict this.
mysql FLUSH PRIVILEGES;
0 Rows Affected.

~Kelly W. Black



-
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: Installation Help

2002-11-13 Thread Phil Iovino
It does except my hosts file has localhost.localdomain switched around
from what you specified. Mine is:
127.0.0.1 web01.nxtek.net web01 localhost.localdomain localhost

Any other ideas anyone? I wish the rpm did all this crap. heh

-Original Message-
From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] 
Sent: Wednesday, November 13, 2002 1:39 PM
To: 'Phil Iovino'; 'Paul DuBois'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help


Sorry I made a mistake as Paul pointed out.

I meant 

GRANT ALL ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';

If you use the localhost substitution for the fully qualified domain
name then be sure your /etc/hosts file has a line at the top like

127.0.0.1 localdomain.localhost localhost


~Kelly W. Black
-Original Message-
From: Phil Iovino [mailto:phil;nxtek.net]
Sent: Wednesday, November 13, 2002 10:36 AM
To: 'Paul DuBois'; Black, Kelly W [PCS]; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help


I wasn't sure if I was supposed to use 'root' or 'root@localhost' so I
did it for both. I'm still getting this:

[root@web01 phil]# /usr/local/mysql/bin/mysqladmin version
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

Ugh. :)

-Original Message-
From: Paul DuBois [mailto:paul;snake.net] 
Sent: Tuesday, November 12, 2002 7:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help


At 11:45 -0600 11/12/02, Black, Kelly W [PCS] wrote:
Make sure you issued the correct GRANT statements
at the sql, query.

mysqluse mysql;
Database Changed
mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY
mysql 'somepassword';

That's not quite right.

- GRANT * is not legal, I suspect you mean GRANT ALL.

- '[EMAIL PROTECTED]' is quoted incorrectly.  That is equivalent to
   '[EMAIL PROTECTED]'@'%'.  I suspect you mean
'userid'@'hostname.com'.
   (user and host parts should be quoted separately.)


#note that will give FULL access...see the docs to restrict this.
mysql FLUSH PRIVILEGES;
0 Rows Affected.

~Kelly W. Black



-
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




Installation Help

2002-11-12 Thread Phil Iovino
I'm trying to install MySQL under RedHat 8. I installed the MySQL
3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs.

Per the instructions at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm
l#Post-installation, I started the server with /usr/bin/safe_mysqld 
and it appears to have started.

When I try to test it, I get this:
[root@web01 bin]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

I'm kinda stuck. Any ideas?


-
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: Installation Help

2002-11-12 Thread Scott Pippin


Scott Pippin
[EMAIL PROTECTED]

 Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM 
I'm trying to install MySQL under RedHat 8. I installed the MySQL
3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs.

Per the instructions at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm

l#Post-installation, I started the server with /usr/bin/safe_mysqld

and it appears to have started.

When I try to test it, I get this:
[root@web01 bin]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password:
NO)'

I'm kinda stuck. Any ideas?

Did you set up root as a user?  If you did, try 

/usr/bin/safe_mysqld -u root

If not set up a user.
http://www.mysql.com/doc/en/Adding_users.html

hope this helps.
(sql, mysql)

-
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: Installation Help

2002-11-12 Thread Phil Iovino
I believe root has all permissions. I'm using Webmin to verify it.

I started it with -u root but still got the same error.

Since I installed with the RPM didn't it give root permission?

-Original Message-
From: Scott Pippin [mailto:spippin;mtctrains.com] 
Sent: Tuesday, November 12, 2002 10:43 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Installation Help




Scott Pippin
[EMAIL PROTECTED]

 Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM 
I'm trying to install MySQL under RedHat 8. I installed the MySQL
3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs.

Per the instructions at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.ht
m

l#Post-installation, I started the server with /usr/bin/safe_mysqld

and it appears to have started.

When I try to test it, I get this:
[root@web01 bin]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password:
NO)'

I'm kinda stuck. Any ideas?

Did you set up root as a user?  If you did, try 

/usr/bin/safe_mysqld -u root

If not set up a user.
http://www.mysql.com/doc/en/Adding_users.html

hope this helps.
(sql, mysql)

-
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: Installation Help

2002-11-12 Thread Scott Pippin
Did you set up root as a user inside of MYSQL?  Eventhough root has
permission it must be set up as a user inside of MySQL.


 Phil Iovino [EMAIL PROTECTED] 11/12/02 09:13AM 
I believe root has all permissions. I'm using Webmin to verify it.

I started it with -u root but still got the same error.

Since I installed with the RPM didn't it give root permission?

-Original Message-
From: Scott Pippin [mailto:spippin;mtctrains.com] 
Sent: Tuesday, November 12, 2002 10:43 AM
To: [EMAIL PROTECTED] 
Cc: [EMAIL PROTECTED] 
Subject: Re: Installation Help




Scott Pippin
[EMAIL PROTECTED] 

 Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM 
I'm trying to install MySQL under RedHat 8. I installed the MySQL
3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs.

Per the instructions at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.ht

m

l#Post-installation, I started the server with /usr/bin/safe_mysqld

and it appears to have started.

When I try to test it, I get this:
[root@web01 bin]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password:
NO)'

I'm kinda stuck. Any ideas?

Did you set up root as a user?  If you did, try 

/usr/bin/safe_mysqld -u root

If not set up a user.
http://www.mysql.com/doc/en/Adding_users.html 

hope this helps.
(sql, mysql)

-
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: Installation Help

2002-11-12 Thread Black, Kelly W [PCS]
Make sure you issued the correct GRANT statements
at the sql, query.

mysqluse mysql;
Database Changed
mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';

#note that will give FULL access...see the docs to restrict this.
mysql FLUSH PRIVILEGES;
0 Rows Affected.

~Kelly W. Black

-Original Message-
From: Phil Iovino [mailto:phil;nxtek.net]
Sent: Tuesday, November 12, 2002 8:14 AM
To: 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help


I believe root has all permissions. I'm using Webmin to verify it.

I started it with -u root but still got the same error.

Since I installed with the RPM didn't it give root permission?

-Original Message-
From: Scott Pippin [mailto:spippin;mtctrains.com] 
Sent: Tuesday, November 12, 2002 10:43 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Installation Help




Scott Pippin
[EMAIL PROTECTED]

 Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM 
I'm trying to install MySQL under RedHat 8. I installed the MySQL
3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs.

Per the instructions at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.ht
m

l#Post-installation, I started the server with /usr/bin/safe_mysqld

and it appears to have started.

When I try to test it, I get this:
[root@web01 bin]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password:
NO)'

I'm kinda stuck. Any ideas?

Did you set up root as a user?  If you did, try 

/usr/bin/safe_mysqld -u root

If not set up a user.
http://www.mysql.com/doc/en/Adding_users.html

hope this helps.
(sql, mysql)

-
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

-
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: Installation Help

2002-11-12 Thread Paul DuBois
At 11:45 -0600 11/12/02, Black, Kelly W [PCS] wrote:

Make sure you issued the correct GRANT statements
at the sql, query.

mysqluse mysql;
Database Changed
mysql GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';


That's not quite right.

- GRANT * is not legal, I suspect you mean GRANT ALL.

- '[EMAIL PROTECTED]' is quoted incorrectly.  That is equivalent to
  '[EMAIL PROTECTED]'@'%'.  I suspect you mean 'userid'@'hostname.com'.
  (user and host parts should be quoted separately.)



#note that will give FULL access...see the docs to restrict this.
mysql FLUSH PRIVILEGES;
0 Rows Affected.

~Kelly W. Black




-
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




Installation Help

2002-06-12 Thread Stephen Brown

I am installing MYsql under linux and need some one on one help if somoeone 
is willing..

Thanks,
Stephen


-
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




Installation Help

2002-06-12 Thread Stephen Brown

I am installing MYsql under linux and need some one on one help if somoeone 
is willing..

Thanks,
Stephen 


-
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: Installation Help

2002-06-12 Thread Gerald R. Jensen

Stephen:

The *best* help for the kind of questions you have is in the MySQL Manual.

Gerald Jensen

- Original Message -
From: Stephen Brown [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 8:22 PM
Subject: Installation Help


I am installing MYsql under linux and need some one on one help if somoeone
is willing..

Thanks,
Stephen


-
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++ 1.7.9 installation help

2002-06-03 Thread Shaorong Liu

Hi,

   I try to install mySQL++ 1.7.9 in Linux 7.1 (gcc 2.96). I put the mySQL++
source code in /home/group2/ and type the following commands:
automake
autoconf
./configure --with-prefix='/home/group2/'
but there is an error message: checking for MySQL library directory...
configure: error: Didn't find the mysql library dir in ''

Does it mean that I need to put the mysql library in the directory:
/home/group2/?
If this is the case, then anybody can tell me that where can I download
mysql library? Thanks!


_
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




Re: mySQL++ 1.7.9 installation help

2002-06-03 Thread Gelu Gogancea

Hi,
If you have installed MySQL, the library it is on the right place.

Gelu
- Original Message -
From: Shaorong Liu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 12:01 AM
Subject: mySQL++ 1.7.9 installation help


 Hi,

I try to install mySQL++ 1.7.9 in Linux 7.1 (gcc 2.96). I put the
mySQL++
 source code in /home/group2/ and type the following commands:
 automake
 autoconf
 ./configure --with-prefix='/home/group2/'
 but there is an error message: checking for MySQL library directory...
 configure: error: Didn't find the mysql library dir in ''

 Does it mean that I need to put the mysql library in the directory:
 /home/group2/?
 If this is the case, then anybody can tell me that where can I download
 mysql library? Thanks!


 _
 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++ 1.7.9 installation help

2002-06-03 Thread Yegor Bryukhov


1.You need libraries+headers from MySQL installation
2.You have to specify their locations in configure parameters 
(--with-mysql-lib=..., --with-mysql-include=...)

As I remember one of these parameters does not recognize well on RH 7.2 
(and 7.1 also I guess)

   I try to install mySQL++ 1.7.9 in Linux 7.1 (gcc 2.96). I put the mySQL++
 source code in /home/group2/ and type the following commands:
 automake
 autoconf
 ./configure --with-prefix='/home/group2/'
 but there is an error message: checking for MySQL library directory...
 configure: error: Didn't find the mysql library dir in ''
 
 Does it mean that I need to put the mysql library in the directory:
 /home/group2/?
 If this is the case, then anybody can tell me that where can I download
 mysql library? Thanks!
 

-- 
Best regards,
Yegor
__
Yegor Bryukhov, PhD student at GC CUNY
office:   4330
office phone: +1(212)817-8653
home phone:   +1(718)842-4250
e-mail:   [EMAIL PROTECTED]


-
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: INSTALLATION HELP, PLEASE!!

2002-06-02 Thread Benjamin Pflugmann

Hi.

On Fri 2002-05-31 at 09:19:38 -0400, [EMAIL PROTECTED] wrote:
 im missing the mysql and mysqladmin binaries after my admin guy installed
 the most recent stable mysql rpm on a (linux) machine. are these included in
 the client rpm that he may have missed or is there something new that i
 missed?

Yes, they are in the client rpm. Why didn't you just check yourself?
It is as easy as

  rpm -qlp package.rpm

-- 
[EMAIL PROTECTED]

-
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: INSTALLATION HELP, PLEASE!!

2002-06-01 Thread Egor Egorov

Christopher,
Friday, May 31, 2002, 4:19:38 PM, you wrote:

CLW im missing the mysql and mysqladmin binaries after my admin guy installed
CLW the most recent stable mysql rpm on a (linux) machine. are these included in
CLW the client rpm that he may have missed or is there something new that i
CLW missed?

yeah, you are right! MySQL client program and mysqladmin are included
in the MySQL-client package.

CLW Luke





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.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




INSTALLATION HELP, PLEASE!!

2002-05-31 Thread Christopher L. White

im missing the mysql and mysqladmin binaries after my admin guy installed
the most recent stable mysql rpm on a (linux) machine. are these included in
the client rpm that he may have missed or is there something new that i
missed?

Luke


-
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

2002-05-27 Thread Andy Cheng

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!

2002-05-23 Thread Andy Cheng


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!

2002-05-23 Thread Andrew Lietzow

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!

2002-03-11 Thread ds

 
 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!

2002-03-11 Thread Andy Cheng

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!

2002-03-10 Thread Andy Cheng

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




Re: Mysql installation. Help!

2002-03-10 Thread Intrex

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!

2002-03-10 Thread Doug Thompson

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




Re: Mysql installation. Help!

2002-03-10 Thread Chuck \PUP\ Payne

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!

2002-03-10 Thread Andy Cheng

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

2002-03-10 Thread Chuck \PUP\ Payne

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!

2002-03-10 Thread Sammy Lau

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

Perl DBI installation. Help!

2002-03-07 Thread Andy Cheng

Hello all,
I am new to linux.  I was told that I need DBI::DBD to connect to Mysql 
using perl. So I go to http://www.mysql.com/downloads/api-dbi.html and 
downloaded DBI-1.18.tar.gz, Msql-Mysql-modules-1.2216.tar.gz.  Using gunzip, 
I unziped the two files.  Now I have DBI-1.18.tar and 
Msql-Mysql-modules-1.2216.tar.  What should I do next to install them and 
test them?  Thanks for the help







_
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




Ask for Linux+MySQL installation help

2001-11-01 Thread YANG

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

2001-11-01 Thread YANG

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

2001-11-01 Thread Z Julian

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.

2001-06-27 Thread Jason Brunk

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.

2001-06-27 Thread Jason Brunk

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.

2001-06-27 Thread Ansgar Becker

 
 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




Installation help

2001-06-11 Thread Bernd Prager

Hi,

I downloaded the mysql-3.23.38 source rpm.
When I try to build it I get the error message:

checking for gcc... egcs
checking whether the C compiler (egcs  -O3  ) works... no
configure: error: installation or configuration problem: C compiler cannot
create executables.
error: Bad exit status from /var/tmp/rpm-tmp.8977 (%build)


RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.8977 (%build)

I don't have an egcs. I do have the gcc-2.96-69 package working.

What can I do to convince config to use gcc?

Thanks,
-- Bernd


-
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: Installation help

2001-06-11 Thread Whit Blauvelt

Is that a Red Hat gcc? There was a famous version they put out with 7.0
that's broken for a lot of things - but I don't recall the gcc version
number.

I've compiled MySQL just fine with gcc version 2.95.2 on Debian (aside from
MySQL needing some help finding zlib). If you go to gnu.org and download
their latest stable gcc, that will also quite automatically compile and
install on most systems in just a few steps (and a lot of waiting on your
CPU during the compile). Can solve problems from using distro gcc's
sometimes, and you can keep two gccs on a system just by setting up a gcc
symlink, in case you have reason to switch back.

Whit

On Mon, Jun 11, 2001 at 12:23:03PM -0400, Bernd Prager wrote:
 Hi,
 
 I downloaded the mysql-3.23.38 source rpm.
 When I try to build it I get the error message:
 
 checking for gcc... egcs
 checking whether the C compiler (egcs  -O3  ) works... no
 configure: error: installation or configuration problem: C compiler cannot
 create executables.
 error: Bad exit status from /var/tmp/rpm-tmp.8977 (%build)
 
 
 RPM build errors:
 Bad exit status from /var/tmp/rpm-tmp.8977 (%build)
 
 I don't have an egcs. I do have the gcc-2.96-69 package working.
 
 What can I do to convince config to use gcc?
 
 Thanks,
 -- Bernd

-
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




Need installation help on HP-UX

2001-03-07 Thread c cw_1

Hi,

I tried to install the HP-UX Binary Distribution on
my HP-UX B.10.20; according to documentation I should use the command

shell /usr/sbin/swinstall -s /path/to/depot mysql.full

After I tar the Binary file, I still can't find the depot file.

Can someone tell where can I find it?

Thank you very much!
Cathy


_
Get your FREE download of MSN Explorer at http://explorer.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