Installation help ...!
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 ...!
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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++ 1.7.9 installation help
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 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 - 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
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!!
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!!
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!!
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
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
Perl DBI installation. Help!
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
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
Installation help
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
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
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