Re: MySQL installation failure
On Wednesday, 1 February 2006 at 15:01:15 -0600, Hong Li wrote: > Hi > > I am doing investigation to determine whether we can use MySQL in > our project. But I got error message when I try to install MySQL on > Unix server. Could you please help me? > group name not found in group table(s) This suggests that you're using a BSD-style package. BSD systems have group wheel, many UNIX systems don't. Can you give details of your system and what version of MySQL you're trying to install? Greg -- Greg Lehey, Senior Software Engineer MySQL AB, http://www.mysql.com/ Echunga, South Australia Phone: +61-8-8388-8286 Mobile: +61-418-838-708 VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED] Are you MySQL certified? http://www.mysql.com/certification/ pgpTPx3cLWuAB.pgp Description: PGP signature
Re: MySQL installation problems.
Hello. Is this a clean new install of MySQL, or you have already installed MySQL instance? Please provide more information about your OS version (I guess it is Windows, isn't it?). May be some tips from the manual could be helpful: http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooting.html http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html Kevin Pollard wrote: > Today I downloaded and installed MySQL 5.0 (the "Complete Package"). > > Everything seemed to go with the install until it got to the "Processing > configuration..." stage. > It successfully completed "Prepare configuration", and "Write > configuration file", and "Start service". > > But it failed when it got to "Apply security settings" with the error > message "The security settings could not be applied. Error number 2003. > Can't connect ot MySQL server on 'locahost' (10061) > > What can I do about that? > > > Kevin > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql installation information
If the Redhat Enterprise edition is anything like the SuSE Enterprise then you have Mysql installed already. It won't be 4.1.10a most likely 4.0.x. Just down load the 4.1.10a rpm and install it over the top of the existing version. Kevin Cowley Product Development Alchemetrics Ltd SMARTER DATA , FASTER Tel: 0118 902 9000 (swithcboard) Tel: 0118 902 9099 (direct) Web: www.alchemetrics.co.uk Email: [EMAIL PROTECTED] > -Original Message- > From: Suryya Ghosh [mailto:[EMAIL PROTECTED] > Sent: 01 April 2005 12:05 > To: mysql@lists.mysql.com > Subject: Mysql installation information > > Hi, > > I have gone through the sites which you have recomended where it is > suggested that the exact version depends on the requirement and the > hardware. > > According to our hardware & software specification which is given below, I > think we should use (Linux (x86, glibc-2.2, static, gcc),Standard 4.1.10a > ) version of mysql server. > > I have no previous experience regarding installing mysql so it will be a > great help if let me know your openion about it. > Can you please review the URL > http://dev.mysql.com/downloads/mysql/4.1.html and recomend the exact > version which will go best with the server. > > Server Configuration > - > Server: Dual Xeon 2.8 GHz ( X86,32 bit,533MHz FSB,512KB L2 cache) > Primary HDD: 73 GB SCSI > RAM: ECC Registered 1024MB RAM > Bandwidth: 2000 GB Bandwidth > Uplink Port Speed: 100 Mbps Uplink > Operating System: Red Hat Enterprise Linux, Version 3 (recommended) > Drive Controller: SCSI > Chassis Control: DRAC Card > > > With Regards, > > Suryya ** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql installation information
download the source tar ball and try installing mysql from the source the configure script does it all you , u dont need to worry, for custom compilation use ./configure --help Regards Digvijoy Chatterjee Suryya Ghosh wrote: Hi, I have gone through the sites which you have recomended where it is suggested that the exact version depends on the requirement and the hardware. According to our hardware & software specification which is given below, I think we should use (Linux (x86, glibc-2.2, static, gcc),Standard 4.1.10a ) version of mysql server. I have no previous experience regarding installing mysql so it will be a great help if let me know your openion about it. Can you please review the URL http://dev.mysql.com/downloads/mysql/4.1.html and recomend the exact version which will go best with the server. Server Configuration - Server: Dual Xeon 2.8 GHz ( X86,32 bit,533MHz FSB,512KB L2 cache) Primary HDD: 73 GB SCSI RAM: ECC Registered 1024MB RAM Bandwidth: 2000 GB Bandwidth Uplink Port Speed: 100 Mbps Uplink Operating System: Red Hat Enterprise Linux, Version 3 (recommended) Drive Controller: SCSI Chassis Control: DRAC Card With Regards, Suryya -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql installation
Hi Suryya I don't want to offend you but this information can be found on the MySql website. Choosing wich version to install: http://dev.mysql.com/doc/mysql/en/choosing-version.html Choosing a distribution format http://dev.mysql.com/doc/mysql/en/choosing-distribution-format.html Download page http://dev.mysql.com/downloads/ With kind regards Andy Pieters On Thursday 31 March 2005 14:55, Suryya Ghosh wrote: > Hi, > > We have server with the following hardware specification: > > Server: Dual Xeon 2.8 GHz > Primary HDD: 73 GB SCSI > RAM: ECC Registered 1024MB RAM > Bandwidth: 2000 GB Bandwidth > Uplink Port Speed: 100 Mbps Uplink > Operating System: Red Hat Enterprise Linux, Version 3 (recommended) > Drive Controller: SCSI > Chassis Control: DRAC Card > > Can any body suggest which exact version of mysql will give optimum > performance in this hard ware, will an RPM installation will be the best > one we should compile it from source using an particulat gcc compiler. > > With Regards, > > Suryya -- Registered Linux User Number 379093 -- Feel free to check out these few php utilities that I released under the GPL2 and that are meant for use with a php cli binary: http://www.vlaamse-kern.com/sas/ -- pgpo80o6RLjwa.pgp Description: PGP signature
Re: mysql installation
I recommend starting with the online manual. It has a section on installation and a short tutorial section to help you get used to the MySQL client. http://dev.mysql.com/doc/mysql/en/index.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Caulfield, Linda" <[EMAIL PROTECTED]> wrote on 09/17/2004 12:41:54 PM: > Hello, > > I am trying to setup mysql and need some guidance - > > thanks > > Linda Caulfield > Software Quality Engineer > Global Hawk Program > Rancho Bernardo X4680 > Phone:858.618.4680 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] >
Re: mysql installation
Caulfield, Linda wrote: Hello, I am trying to setup mysql and need some guidance - thanks Linda Caulfield Software Quality Engineer Global Hawk Program Rancho Bernardo X4680 Phone:858.618.4680 Linda - MySQL, 2d Ed., by Paul Dubois is hard to beat. It provides a lot of guidance. - offbyone -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Problem
First, you'll get more help if you post to the list (Mysql General mailing list <[EMAIL PROTECTED]>) All the --console does is directs error messages to the console, i.e., the dos window you have open. If you leave it off the error messages go to a file. What you describe below > without --console as para I'm able to start the > server. is _not_ the server starting correctly. It's _not_ starting and the error message is going to file when you do it without the --console. If it had started you would not have gotten back to the prompt, it would just never come back until the server was stopped elsewhere. - Original Message - From: "Chukkala Bhaskar" <[EMAIL PROTECTED]> To: "Kofirowster" <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 10:28 PM Subject: Re: MySQL Installation Problem > Hi guys, > I'm new to MySQL. > > I tried the following on my test pc with Win98. > It gave me error if I use --console as para. > Any clue? > > without --console as para I'm able to start the > server. > > Regards > > D:\MySQL\bin>mysqld --console > 040618 13:11:07 InnoDB: Operating system error number > 32 in a file operation. > InnoDB: See http://www.innodb.com/ibman.php for > installation help. > InnoDB: See section 13.2 at > http://www.innodb.com/ibman.php > InnoDB: about operating system error numbers. > InnoDB: File name .\ibdata1 > InnoDB: File operation call: 'open'. > InnoDB: Cannot continue operation. > > D:\MySQL\bin>mysqld > > D:\MySQL\bin> > > > > --- Kofirowster <[EMAIL PROTECTED]> wrote: > > I have a windows installation of myql. The links > > Michael gave give correct > > info. > > Here's a synopsis: > > To test a mysql install on windows open the > > mysql/bin dir in a dos window. > > At the prompt type > > mysqld --console > > > > you should get a message back that indicates the > > server is running, such as > > mysqld: ready for connections > > > > open a second dos window at the same location and at > > the prompt type > > mysql > > > > you should get a message back similar to this where > > the x's are replaced by > > the version you are running: > > Welcome to the MySQL monitor. Commands end with ; > > or \g. > > Your MySQL connection id is 1 to server version: > > x.xx.xx-debug > > > > Type 'help' for help. > > > > mysql> > > > > HTH, > > Johnny > > - Original Message - > > From: "Michael Stassen" > > <[EMAIL PROTECTED]> > > To: "Singh, Bijay" <[EMAIL PROTECTED]> > > Cc: "Mysql General mailing list" > > <[EMAIL PROTECTED]> > > Sent: Thursday, June 17, 2004 11:01 AM > > Subject: Re: MySQL Installation Problem > > > > > > > > > > I'm including the list on this. In general, you > > will get better and > > faster > > > responses if you keep threads on the list. > > > > > > I've never run the mysql server under Windows, but > > I assume the manual is > > > accurate > > > <http://dev.mysql.com/doc/mysql/en/Windows_server_first_start.html> > > > and > > <http://dev.mysql.com/doc/mysql/en/NT_start.html>. > > > > > > You must configure phpmyadmin so that when it > > attempts to connect to > > mysql, > > > it uses a username-password combination that mysql > > will accept. If you > > have > > > a mysql user with no password, you can use that, > > but I wouldn't recommend > > > allowing any unauthenticated connections to mysql. > > See the manual for > > more > > > > > > <http://dev.mysql.com/doc/mysql/en/Default_privileges.html>. > > > > > > Michael > > > > > > Singh, Bijay wrote: > > > > > > > I am using localhost with no password. how do > > check whether MySQL is > > > running or not. If not how do I start the MySQL on > > Windows ? > > > > > > > > > > > > -Original Message- > > > > From: Michael Stassen > > [mailto:[EMAIL PROTECTED] > > > > Sent: Thursday, June 17, 2004 1:29 PM > > > > To: [EMAIL PROTECTED] > > > > Cc: Singh, Bijay; [EMAIL PROTECTED] > > > > Subject: Re: MySQL Installation Problem > > > > > > > > > > > > First, make sure mysql server is running. > > > > > > > > Second, make sure you have properly
Re: MySQL Installation Problem
I have a windows installation of myql. The links Michael gave give correct info. Here's a synopsis: To test a mysql install on windows open the mysql/bin dir in a dos window. At the prompt type mysqld --console you should get a message back that indicates the server is running, such as mysqld: ready for connections open a second dos window at the same location and at the prompt type mysql you should get a message back similar to this where the x's are replaced by the version you are running: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: x.xx.xx-debug Type 'help' for help. mysql> HTH, Johnny - Original Message - From: "Michael Stassen" <[EMAIL PROTECTED]> To: "Singh, Bijay" <[EMAIL PROTECTED]> Cc: "Mysql General mailing list" <[EMAIL PROTECTED]> Sent: Thursday, June 17, 2004 11:01 AM Subject: Re: MySQL Installation Problem > > I'm including the list on this. In general, you will get better and faster > responses if you keep threads on the list. > > I've never run the mysql server under Windows, but I assume the manual is > accurate <http://dev.mysql.com/doc/mysql/en/Windows_server_first_start.html> > and <http://dev.mysql.com/doc/mysql/en/NT_start.html>. > > You must configure phpmyadmin so that when it attempts to connect to mysql, > it uses a username-password combination that mysql will accept. If you have > a mysql user with no password, you can use that, but I wouldn't recommend > allowing any unauthenticated connections to mysql. See the manual for more > <http://dev.mysql.com/doc/mysql/en/Default_privileges.html>. > > Michael > > Singh, Bijay wrote: > > > I am using localhost with no password. how do check whether MySQL is > running or not. If not how do I start the MySQL on Windows ? > > > > > > -Original Message----- > > From: Michael Stassen [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 17, 2004 1:29 PM > > To: [EMAIL PROTECTED] > > Cc: Singh, Bijay; [EMAIL PROTECTED] > > Subject: Re: MySQL Installation Problem > > > > > > First, make sure mysql server is running. > > > > Second, make sure you have properly configured phpmyadmin in file > > config.inc.php. In particular, you have to set how phpmyadmin will connect > > to mysql (user and pass). > > > > Michael > > > > Daniel Clark wrote: > > > > > >>After the phpmyadmin login I got the same error. > >> > >>In the phpmyadmin config files I had to set the local IP address that > >>phpmyadmin was on. > > > > > > Strange. Didn't it default to localhost? > > > > > >>>Dear Michael, > >>> > >>>I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not > >>>able to get this rite. > >>> > >>> > >>>I am trying to instal MySQL with phpMyAdmin and i get the error when view > >> > >>>from : > >> > >>>http://localhost/phpMyAdmin/ > >>> > >>> > >>>#2003 - Can't connect to MySQL server on 'localhost' (10061) > >>> > >>>OS - WinXP Pro > >>>Apache > >>>phpMyAdmin 2.5.7 > >>> > >>>I tried reinstalling but not able to get. I checked Apache and php they > >>>work fine except mySQL. > >>> > >>>Any help will be appreciated. Feel free to email or contact me on phone # > >>>below. > >> > >> > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Problem
I'm including the list on this. In general, you will get better and faster responses if you keep threads on the list. I've never run the mysql server under Windows, but I assume the manual is accurate <http://dev.mysql.com/doc/mysql/en/Windows_server_first_start.html> and <http://dev.mysql.com/doc/mysql/en/NT_start.html>. You must configure phpmyadmin so that when it attempts to connect to mysql, it uses a username-password combination that mysql will accept. If you have a mysql user with no password, you can use that, but I wouldn't recommend allowing any unauthenticated connections to mysql. See the manual for more <http://dev.mysql.com/doc/mysql/en/Default_privileges.html>. Michael Singh, Bijay wrote: I am using localhost with no password. how do check whether MySQL is running or not. If not how do I start the MySQL on Windows ? -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 1:29 PM To: [EMAIL PROTECTED] Cc: Singh, Bijay; [EMAIL PROTECTED] Subject: Re: MySQL Installation Problem First, make sure mysql server is running. Second, make sure you have properly configured phpmyadmin in file config.inc.php. In particular, you have to set how phpmyadmin will connect to mysql (user and pass). Michael Daniel Clark wrote: After the phpmyadmin login I got the same error. In the phpmyadmin config files I had to set the local IP address that phpmyadmin was on. Strange. Didn't it default to localhost? Dear Michael, I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get this rite. I am trying to instal MySQL with phpMyAdmin and i get the error when view from : http://localhost/phpMyAdmin/ #2003 - Can't connect to MySQL server on 'localhost' (10061) OS - WinXP Pro Apache phpMyAdmin 2.5.7 I tried reinstalling but not able to get. I checked Apache and php they work fine except mySQL. Any help will be appreciated. Feel free to email or contact me on phone # below. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Problem
First, make sure mysql server is running. Second, make sure you have properly configured phpmyadmin in file config.inc.php. In particular, you have to set how phpmyadmin will connect to mysql (user and pass). Michael Daniel Clark wrote: After the phpmyadmin login I got the same error. In the phpmyadmin config files I had to set the local IP address that phpmyadmin was on. Strange. Didn't it default to localhost? Dear Michael, I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get this rite. I am trying to instal MySQL with phpMyAdmin and i get the error when view from : http://localhost/phpMyAdmin/ #2003 - Can't connect to MySQL server on 'localhost' (10061) OS - WinXP Pro Apache phpMyAdmin 2.5.7 I tried reinstalling but not able to get. I checked Apache and php they work fine except mySQL. Any help will be appreciated. Feel free to email or contact me on phone # below. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Problem
After the phpmyadmin login I got the same error. In the phpmyadmin config files I had to set the local IP address that phpmyadmin was on. > Dear Michael, > > I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not > able to get this rite. > > > I am trying to instal MySQL with phpMyAdmin and i get the error when view > from : > > http://localhost/phpMyAdmin/ > > > #2003 - Can't connect to MySQL server on 'localhost' (10061) > > OS - WinXP Pro > Apache > phpMyAdmin 2.5.7 > > I tried reinstalling but not able to get. I checked Apache and php they > work fine except mySQL. > > Any help will be appreciated. Feel free to email or contact me on phone # > below. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation in Fedora Core 1
Daevid Vincent wrote: Just make a symbolic link... Probably it's in /tmp So as root, "ln -vs /tmp/mysql.sock /var/lib/mysql/mysql.sock" This is always an annoyance with mysql and redhat it seems. *sigh* How exactly? I mean there cannot be a socket file in /tmp either, because MySQL does not even start properly. For example: [EMAIL PROTECTED] smaisnie]# ln -vs /tmp/mysql.sock /var/lib/mysql/mysql.sock create symbolic link `/var/lib/mysql/mysql.sock' to `/tmp/mysql.sock' ln: creating symbolic link `/var/lib/mysql/mysql.sock' to `/tmp/mysql.sock': No such file or directory Regards Sami -Original Message- From: Sami Maisniemi [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 3:11 PM To: [EMAIL PROTECTED] Subject: MySQL installation in Fedora Core 1 I intend to build up a web server that is based on Fedora Core 1. Installation and configuration of Apache and PHP4 was pretty simple, but there are some problems in configuration of MySQL. I installed the MySQL server RPM included in the distribution. Even in the MySQL pages it is mentioned that running "/etc/rc.d/init.d/mysqld start" is enough for post-installation process. However, there is no such file. Running "mysql" leads to an error: [EMAIL PROTECTED] smaisnie]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Does anyone have any idea how to carry out post-installation process? Regards Sami Maisniemi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Installation???
Hello List: I have installed and tested freeRADIUS 0.9.3 & MySQL 5.?.? (latest dev version). Now I want to install & test freeRADIUS & MySQL with InnoDB tables. I have researched GOOGLE & MySQL web site for information on installing MySQL with InnoDB tables without success. I would appreciate if somebody direct me to: What version of MySQL do I need to install (with freeRADIUS) so I can use InnoDB tables? I understand that installing MySQL with freeRADIUS requires a specific MySQL version? Is it correct? I would be more than happy to read the procedure if someone point me to the chapter in MySQL Doc! I have not been able to find out myself. Is it possible that there is no special separate procedure and that is why I am missing it? Thanks in advance. Kirt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation in Fedora Core 1
Hi! simply put a pair of lines like these pointing out to the correct location of your mysql.sock: socket = /opt/mysql-4.0.18/mysql.sock You'll need a line in your client and in your mysqld section of your my.cnf (mysql config file) Best Regards! Sami Maisniemi wrote: I intend to build up a web server that is based on Fedora Core 1. Installation and configuration of Apache and PHP4 was pretty simple, but there are some problems in configuration of MySQL. I installed the MySQL server RPM included in the distribution. 8< -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL installation in Fedora Core 1
Just make a symbolic link... Probably it's in /tmp So as root, "ln -vs /tmp/mysql.sock /var/lib/mysql/mysql.sock" This is always an annoyance with mysql and redhat it seems. *sigh* > -Original Message- > From: Sami Maisniemi [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 30, 2004 3:11 PM > To: [EMAIL PROTECTED] > Subject: MySQL installation in Fedora Core 1 > > I intend to build up a web server that is based on Fedora Core 1. > Installation and configuration of Apache and PHP4 was pretty > simple, but > there are some problems in configuration of MySQL. I > installed the MySQL > server RPM included in the distribution. > > Even in the MySQL pages it is mentioned that running > "/etc/rc.d/init.d/mysqld start" is enough for > post-installation process. > However, there is no such file. Running "mysql" leads to an error: > > [EMAIL PROTECTED] smaisnie]# mysql > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) > > Does anyone have any idea how to carry out post-installation process? > > Regards Sami Maisniemi > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation in Fedora Core 1
I intend to build up a web server that is based on Fedora Core 1. Installation and configuration of Apache and PHP4 was pretty simple, but there are some problems in configuration of MySQL. I installed the MySQL server RPM included in the distribution. Even in the MySQL pages it is mentioned that running "/etc/rc.d/init.d/mysqld start" is enough for post-installation process. However, there is no such file. Running "mysql" leads to an error: i'm not that familar with FC1, but can you just cd into /path/to/mysql and run bin/mysqld_safe --user=mysql & did you run scripts/mysql_install_db from /path/to/mysql ? or is that included as part of the rpm install. that may not be needed, i've always installed the binaries on Solaris/RH8&9 HTH jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL installation in Fedora Core 1
Sami, I run Fedora core 1 and haven't had any problems. This is all you do if you want MySQL 4.1.1. wget http://www.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-4.1.1-1.i386.rpm/f rom/http://mysql.mirrors.pair.com/ wget http://www.mysql.com/get/Downloads/MySQL-4.1/MySQL-client-4.1.1-0.i386.rpm/f rom/http://mysql.mirrors.pair.com/ wget http://www.mysql.com/get/Downloads/MySQL-4.1/MySQL-devel-4.1.1-0.i386.rpm/fr om/http://mysql.mirrors.pair.com/ rpm -i MySQL-server-4.1.1-1.i386.rpm rpm -i MySQL-client-4.1.1-0.i386.rpm rpm -i MySQL-devel-4.1.1-0.i386.rpm Sorry, word wrap sucks. Donny > -Original Message- > From: Sami Maisniemi [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 30, 2004 5:11 PM > To: [EMAIL PROTECTED] > Subject: MySQL installation in Fedora Core 1 > > I intend to build up a web server that is based on Fedora Core 1. > Installation and configuration of Apache and PHP4 was pretty simple, but > there are some problems in configuration of MySQL. I installed the MySQL > server RPM included in the distribution. > > Even in the MySQL pages it is mentioned that running > "/etc/rc.d/init.d/mysqld start" is enough for post-installation process. > However, there is no such file. Running "mysql" leads to an error: > > [EMAIL PROTECTED] smaisnie]# mysql > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2) > > Does anyone have any idea how to carry out post-installation process? > > Regards Sami Maisniemi > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server
Weird. I cannot find the my.cnf (configuration file).. How that's possible? Thanks From: Victor Medina <[EMAIL PROTECTED]> To: Mike Mapsnac <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server th Date: Sun, 18 Jan 2004 10:24:53 -0400 Probably your server is not using any sockets, check out your my.cnf. man mysql to see how to connect to a ip based mysql host. C/ya! On Sat, 2004-01-17 at 18:51, Mike Mapsnac wrote: > I just install MYSQL on Linux (Red Hat 9) > using this manual:http://www.mysql.com/doc/en/Installing_binary.html > Have no idea what's wrong. I looked on the mysql.log file and the file is > empty. > > ERROR MESSAGE: > [EMAIL PROTECTED] bin]# ./mysql > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) > [EMAIL PROTECTED] bin]# ./mysql status > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' > > _ > Scope out the new MSN Plus Internet Software optimizes dial-up to the max! >http://join.msn.com/?pgmarket=en-us&page=byoa/plus&ST=1 -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 | ||geek by nature - linux by choice | |...| ... "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." Rich Cook _ Check out the new MSN 9 Dial-up fast & reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-us&page=dialup/home&ST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th
Probably your server is not using any sockets, check out your my.cnf. man mysql to see how to connect to a ip based mysql host. C/ya! On Sat, 2004-01-17 at 18:51, Mike Mapsnac wrote: > I just install MYSQL on Linux (Red Hat 9) > using this manual:http://www.mysql.com/doc/en/Installing_binary.html > Have no idea what's wrong. I looked on the mysql.log file and the file is > empty. > > ERROR MESSAGE: > [EMAIL PROTECTED] bin]# ./mysql > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) > [EMAIL PROTECTED] bin]# ./mysql status > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' > > _ > Scope out the new MSN Plus Internet Software optimizes dial-up to the max! >http://join.msn.com/?pgmarket=en-us&page=byoa/plus&ST=1 -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|ext. 325 | ||geek by nature - linux by choice | |...| ... "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." Rich Cook
RE: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th
Hi Mike, You have to start the mysql server before you can run the client. Try running "mysqld_safe --user=mysql" from /usr/bin or /usr/local/bin, depending on where you installed it. To see if it is running currently on your machine, try this: ps -ef | grep mysqld Hope this helps... ~~Nick --- On Sat 01/17, Mike Mapsnac < [EMAIL PROTECTED] > wrote: From: Mike Mapsnac [mailto: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Sat, 17 Jan 2004 22:51:29 + Subject: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th I just install MYSQL on Linux (Red Hat 9)using this manual:http://www.mysql.com/doc/en/Installing_binary.htmlHave no idea what's wrong. I looked on the mysql.log file and the file is empty.ERROR MESSAGE:[EMAIL PROTECTED] bin]# ./mysqlERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)[EMAIL PROTECTED] bin]# ./mysql statusERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock'_Scope out the new MSN Plus Internet Software optimizes dial-up to the max! http://join.msn.com/?pgmarket=en-us&page=byoa/plus&ST=1-- MySQL General Mailing ListFor list archives: http://lists.mysql.com/mysqlTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation with SuSE Linux 9.0 and YaST
Franz, it could not be easier. 1. install MySQL using Yast's software menu. 2. use the Yast run level editor to have MySQL up at run levels 3 and 5 and to start the application. 3. be root in a xterm window and type: mybox:~ # mysql ... and you will see: mysql> here you are accessing a running system from the client. Use GRANT to set a password for root and to add new users. Where is the problem? Liebe Grüsse Thomas Spahni On Sun, 7 Dec 2003, Franz Edler wrote: > I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it > very comfortable for me to install various SW-packages. Therefore I try to > install also MySQL with YaST. > > There are MySQL packages (Version 4.0.15) included in SuSE Linux 9.0 > distribution and I try to install the server and the client with YaST. > > But after installation of these packages with YaST - which is the easy part > - one has to configure various parameters for MySQL to work properly e.g. > create the database files, define group and user, grant access ... > Unfortunately the MySQL-manual (which is a big document) does not give any > guidelines for installing with YaST. > > After several times re- and de-installing mysql and also SuSE-Linux itself I > still have troubles to get the server running. > > Has anyone already done a MySQL-installation with SuSE Linux 9.0 and YaST? > Is there any "quick installation guide" for this task? > > I would be very happy to get some help. > > Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation with SuSE Linux 9.0 and YaST
Hello Franz, On Sunday 07 December 2003 12:42, Franz Edler wrote: I do not have specific experiences with SuSE 9.0 (stiil waiting for it from my distributor) but I do with previous versions of SuSE (7.x and 8.x), > I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it > very comfortable for me to install various SW-packages. Therefore I try to > install also MySQL with YaST. > > There are MySQL packages (Version 4.0.15) included in SuSE Linux 9.0 > distribution and I try to install the server and the client with YaST. > > But after installation of these packages with YaST - which is the easy part > - one has to configure various parameters for MySQL to work properly e.g. > create the database files, define group and user, grant access ... > Unfortunately the MySQL-manual (which is a big document) does not give any > guidelines for installing with YaST. Unfortunately you cannot use YaST to confiture MySQL. Although your may want the server to start at boot time and that is done in the "System->Run Level Editor" in YaST. > > After several times re- and de-installing mysql and also SuSE-Linux itself > I still have troubles to get the server running. What kind of troubles? Probably this is the place this group can start to help you. > > Has anyone already done a MySQL-installation with SuSE Linux 9.0 and YaST? > Is there any "quick installation guide" for this task? I think you have done all it could be done using YaST. You need now to jump into the documentation of MySQL. I will suggest that you read the tutorial in section 3 of MySQL's documentation. (URL: http://www.mysql.com/doc/en/Tutorial.html). > > I would be very happy to get some help. Hope I have been usefull. > > Franz Bernard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation problem
On Sat, Dec 06, 2003 at 08:20:57PM +0100, Franz Edler wrote: > > > > Errno 13 is Permission Denied. Is the mysql daemon running with > > sufficient privileges to read the directory and files within it? > > All the database files should be owned by the mysql user, and are > > generally in the mysql group, mode 660. Check that's the case. > > All mysql-database files in /var/lib/mysql/mysql/ are owned by user=root and > group=root, mode =660. > There is no mysql group. > > I installed as user "root" (using YaST) and created the database-files with > mysql_install_db also as user "root". During normal operation, mysql should run as the user "mysql", so it can't read those. You'll want to chown them. Not having a mysql group isn't critical, but if you haven't got a mysql user then I dare say you need to check the installation process, because it probably hasn't worked correctly. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL installation problem
> From: Chris Elsworth Sent: Saturday, December 06, 2003 5:09 PM > > > The msqld.log file shows: > > 031206 15:05:20 mysqld started > > 031206 15:05:20 Fatal error: Can't open privilege tables: > > Can't find file: './mysql/host.frm' (errno: 13) > > 031206 15:05:20 Aborting > > 031206 15:05:20 /usr/sbin/mysqld: Shutdown Complete > > Errno 13 is Permission Denied. Is the mysql daemon running with > sufficient privileges to read the directory and files within it? > All the database files should be owned by the mysql user, and are > generally in the mysql group, mode 660. Check that's the case. All mysql-database files in /var/lib/mysql/mysql/ are owned by user=root and group=root, mode =660. There is no mysql group. I installed as user "root" (using YaST) and created the database-files with mysql_install_db also as user "root". Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation problem
On Sat, Dec 06, 2003 at 03:52:05PM +0100, Franz Edler wrote: > > The msqld.log file shows: > 031206 15:05:20 mysqld started > 031206 15:05:20 Fatal error: Can't open privilege tables: > Can't find file: './mysql/host.frm' (errno: 13) > 031206 15:05:20 Aborting > 031206 15:05:20 /usr/sbin/mysqld: Shutdown Complete > > What is wrong? Errno 13 is Permission Denied. Is the mysql daemon running with sufficient privileges to read the directory and files within it? All the database files should be owned by the mysql user, and are generally in the mysql group, mode 660. Check that's the case. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql installation problems (RPM errors)
First off to maybe make this easy on you, you do not need the MySQL-bench rpm if you do not plan on using the benchmarking tools. It is an optional install. Otherwise, I do not think rpm cares about capitalization. I believe this problem is discussed in the MySQL manual, and might have the solution, but then I am sure others on this list can help out. Most important thing to remember, is that you don't need benchmarking to run the MySQL server. In the past, I always used a tarball of the perl DBI and it worked fine. Gale Stafford wrote: Hey Folks Hi there! My first post to the list ... I am installing mysql 4.0.1-2 on a Redhat 8.0 workalike. I've installed the MySQL server software, client software, but when I try to install the MySQL-bench...rpm, I get the failed dependencies error, MySQL-DBI-perl-bin is needed. I did a search and found Mysql-DBI-perl-bin-1.1825-1.i386.rpm, and I installed it. But when I rpm -install the MySQL-bench...rpm package I still get a failed dependencies error. Is this a problem caused by "Mysql-DBI-perl...rpm) not having capitals in all the right places? I dont understand enough about how rpm works, to troubleshoot this! Can anyone help point me to the right MySQL-DBI-perl...rpm file? thanks, Gale -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation problem
Andrew, One, it sound like you have downloaded a binary distro, and this does not require a make. If your want to compile from source, you will need to grab the source distro instead. If you would like to continue with the binary, you can untar the package under /usr/local , and then add the group mysql, add a user mysql with membership to the mysql group, cd to the mysql dir(this should have been created when you untar'd the file under /usr/local, run scripts/mysql_install_db, which sets up all the mysql databases for privledges and stuff, chown -R root . , chown -R mysql data, chgrp -R mysql . , then start the server with bin/mysqld_safe --user=mysql & This should let your db server start, after which you will need to run shell> mysqladmin password 'your_new_password' if you try to do the same command again, it should complain about auth errors. If you need any other help, just ask. --James Hughbanks Mikro-Data Engineering Dept. [EMAIL PROTECTED] 1-866-457-6287 http://www.mikro-data.net On Monday, Aug 18, 2003, at 05:49 America/New_York, Andrew Keating wrote: To whom it may concern, We are having some trouble installing a MySQL database onto one of our servers and would appreciate some assistance, details are below. Installing MySQL v4.0.14 on a Solaris 8 (Sparc) system on a Netra X1. We have downloaded the source files from your website and have had a go at trying to install the software following the instructions on the user manual. We get to the point of configure and we get the following output: [EMAIL PROTECTED] > ./configure --prefix=/usr/local/mysql NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables 030818 10:39:06 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h stats1 password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [EMAIL PROTECTED] > Starting mysqld daemon with databases from /opt/clients/stats/mark/mysql-standard-4.0.14-sun-solaris2.8-sparc/data 030818 10:39:07 mysqld ended This seems to be all ok, but then I try to compile the program using the 'make' command and I get this message: [EMAIL PROTECTED] > make make: *** No targets specified and no makefile found. Stop. Has this error ever happened before and how could we go further on this. A point to note would be that in the directory /usr/local/ there is no mysql directory created! Regards, Mark A. Cauchi --James Hughbanks Mikro-Data Engineering Dept. [EMAIL PROTECTED] 1-866-457-6287 http://www.mikro-data.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Challenges
Chris Moy wrote: $mysqld_safe --user mysql & [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /var/lib/mysql 030812 13:24:04 mysqld ended but you can see that the deamon has "ended" right away. This should not happen, correct? look in the err-file. It's named laptop.err and lies in the data directory. /usr/local/mysql/data Did you enable innodb in /etc/my.cnf ? If yes, did you create it's data-folder ? Check if the user mysql can read/write there. * IMPORTANT * Don't use a file-manager like mc on the shell where you start mysql. It will look exactly like that if you run ./bin/mysqld_safe & from within mc though ./bin/mysqld_safe will work nut block the shell. Plain bash is fine. Then I go to connect to the server (locally) by entering in a mysqladmin command to check the version and the output is below: ... mysql ended error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' While we are at it. Some distributions put this socket elsewhere. SuSE has it's mysql package compiled to store data and socket in /var/lib/mysql. All client programs that came with the distribution will expect the stuff there. You have to symlink the socket to /var/lib/mysql to get the libraries working. Configured with: ../configure --prefix=/usr > '--bindir=/usr/bin' There you are ... RedHat's bin-directory is /usr/bin not /usr/local/mysql/bin '--datadir=/usr/share' and default data folder '--localstatedir=/var/lib/mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' and socket -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Challenges
Chris Moy <[EMAIL PROTECTED]> wrote: >>Description: > > the installation procedure. I have installed the binaries as described > in the manual for installation and I am able to start mysql through > > $mysqld_safe --user mysql & > [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from > /var/lib/mysql > 030812 13:24:04 mysqld ended > > but you can see that the deamon has "ended" right away. This should not > happen, correct? Look into error log file to see error message. > > Then I go to connect to the server (locally) by entering in a mysqladmin > command to check the version and the output is below: > > bin/mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2)' > Check that mysqld is running and that the socket: '/tmp/mysql.sock' > exists! > > It does not seem like the deamon is running at all when I go to check > (ps -aux | grep mysql). Any ideas. I am a little new to MySql. > > Note: I have tried the latest version of MySQL and still get the same > problems but on a diff computer running the same OS (Linux RH 9.0)> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql installation problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 6 Aug 2003, Anil Garg wrote: > I am trying to install myql on redhat. Red Hat Linux? > mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz This is the wrong package - this one is for FreeBSD! Please use the Linux binaries instead. > scripts/mysql_install_db: ./bin/my_print_defaults: /usr/libexec/ld-elf.so.1: > bad ELF interpreter: No such file or directory > scripts/mysql_install_db: ./bin/mysqld: /usr/libexec/ld-elf.so.1: bad ELF > interpreter: No such file or directory FreeBSD binaries do not run on Linux. Bye, LenZ - -- Lenz Grimmer <[EMAIL PROTECTED]> Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/MhEhSVDhKrJykfIRAqNGAJkBJYbw9uzsIOv48A+wQ9ol/BWOHQCfeAu7 yXzHGHVLi4tLINiXyomftLM= =3+9Z -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql installation
Hi, I need some help to install mysql. I downloaded the rpm for Linux. I installed it successfully based on the messages I received at the end of the installation. However, I could not find the mysqladmin tool any where and I do not know what else is missing from my installation. I would like to re-install mysql. Could some one help me out. I am looking for a simple way to make this happen. Thanks so much. Hao - 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: RE: MysQL Installation
SpyProductions, Friday, November 08, 2002, 10:50:33 PM, you wrote: SST> Well hells bells! SST> Would that be the 'Client programs (i386) (2.3M)' mentioned on the download SST> page? :) Yes. -- 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
RE: MySQL Installation
-Mike >I know this is OT a bit, but now I need to either re-compile PHP to get >mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I >need to do this at all? Not sure where PHP came into the picture here. Let's not confuse phpMyAdmin with MySqladmin. Different animals all together. For Mysqladmin you will simply need to download the rpm (rpmfind.net for MySqlClient) or build Mysql from scratch with source (how I like it done) Note:I have had nothing but trouble from the RedHat default Mysqld installs, so now (by default) as soon as the server is set up the first thing I do is disable the mysqld in services and re-compile both PHP and MySql (4.0 MAX of course) on the system without even asking. If you are talking about getting mysql working with PHP you need to compile PHP from source with (everyone flog me with wet cron jobs if I am wrong :) (in pseudo) ./configure --with-mysql=/usr/local/thelocationofyourmyslq.hfile and make. Note that if compiling PHP from source you should use the completed configure (see docs) something like (PLEASE KNOW THIS WILL VARY MACHINE TO MACHINE RESEARCH THIS) (This is a snapshot from my Davis, Ca. server and will NOT work with your PHP configure...) './configure' '--with-apxs=/usr/www.0727/bin/apxs' '--with-db' '--with-mysql=/usr/local/mysql' '--with-msql=/usr/local/Hughes' '--with-xml' '--with-gd=/usr/local' '--enable-ftp' '--with-imap-ssl=/usr/home/colossus/pine4.33/imap' '--with-jpeg-dir=/usr/lib' '--with-zlib' '--with-openssl=/usr/local/ssl' '--with-png-dir=/usr/lib' '--enable-magic-quotes=yes' '--enable-memory-limit' '--enable-trackvars=yes' If this didn't confuse you let me know I will try to confuse you again. ~Kelly W. Black sql, query -Original Message----- From: SpyProductions Support Team [mailto:support@;spyproductions.com] Sent: Friday, November 08, 2002 2:26 PM To: Black, Kelly W [PCS] Cc: [EMAIL PROTECTED] Subject: RE: MySQL Installation I know this is OT a bit, but now I need to either re-compile PHP to get mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I need to do this at all? Even at rpmfind.net is seems hard to distinguish what it is I need. Is there anyway to get a 'complete' PHP rpm somewhere? Thanks! -Mike > -Original Message- > From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com] > Sent: Friday, November 08, 2002 5:12 PM > To: '[EMAIL PROTECTED]' > Cc: [EMAIL PROTECTED] > Subject: RE: MySQL Installation > > > Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the > server package, but MySql.com has it in the client's: > $ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin > > /usr/bin/mysqladmin > /usr/share/man/man1/mysqladmin.1.gz > > sql, query > > ~Kelly W. Black > > PS IN the future check out http://www.rpmfind.net/ > > -Original Message- > From: SpyProductions Support Team [mailto:support@;spyproductions.com] > Sent: Friday, November 08, 2002 12:51 PM > To: Black, Kelly W [PCS] > Cc: [EMAIL PROTECTED] > Subject: RE: MysQL Installation > > > > Well hells bells! > > Would that be the 'Client programs (i386) (2.3M)' mentioned on > the download > page? :) > > Thanks, > > Mike > > > > > -Original Message- > > From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com] > > Sent: Friday, November 08, 2002 2:17 PM > > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > > Subject: RE: MysQL Installation > > > > > > Mysqladmin is seperate rpm > > > > ~K Black > > > > -Original Message- > > From: SpyProductions Support Team [mailto:support@;spyproductions.com] > > Sent: Friday, November 08, 2002 11:13 AM > > To: [EMAIL PROTECTED] > > Subject: MysQL Installation > > > > > > > > I just installed the most recent version of MySQL with an RPM (through > > webmin interface), but it doesn't seem to have installed a > > mysqladmin.anyone know why? :) > > > > Thanks! > > > > -Mike > > > > > > > > ----- > > 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 > > > -Original Mes
RE: MySQL Installation
I know this is OT a bit, but now I need to either re-compile PHP to get mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I need to do this at all? Even at rpmfind.net is seems hard to distinguish what it is I need. Is there anyway to get a 'complete' PHP rpm somewhere? Thanks! -Mike > -Original Message- > From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com] > Sent: Friday, November 08, 2002 5:12 PM > To: '[EMAIL PROTECTED]' > Cc: [EMAIL PROTECTED] > Subject: RE: MySQL Installation > > > Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the > server package, but MySql.com has it in the client's: > $ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin > > /usr/bin/mysqladmin > /usr/share/man/man1/mysqladmin.1.gz > > sql, query > > ~Kelly W. Black > > PS IN the future check out http://www.rpmfind.net/ > > -Original Message- > From: SpyProductions Support Team [mailto:support@;spyproductions.com] > Sent: Friday, November 08, 2002 12:51 PM > To: Black, Kelly W [PCS] > Cc: [EMAIL PROTECTED] > Subject: RE: MysQL Installation > > > > Well hells bells! > > Would that be the 'Client programs (i386) (2.3M)' mentioned on > the download > page? :) > > Thanks, > > Mike > > > > > -Original Message- > > From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com] > > Sent: Friday, November 08, 2002 2:17 PM > > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > > Subject: RE: MysQL Installation > > > > > > Mysqladmin is seperate rpm > > > > ~K Black > > > > -Original Message- > > From: SpyProductions Support Team [mailto:support@;spyproductions.com] > > Sent: Friday, November 08, 2002 11:13 AM > > To: [EMAIL PROTECTED] > > Subject: MysQL Installation > > > > > > > > I just installed the most recent version of MySQL with an RPM (through > > webmin interface), but it doesn't seem to have installed a > > mysqladmin.anyone know why? :) > > > > Thanks! > > > > -Mike > > > > > > > > - > > 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
Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the server package, but MySql.com has it in the client's: $ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin /usr/bin/mysqladmin /usr/share/man/man1/mysqladmin.1.gz sql, query ~Kelly W. Black PS IN the future check out http://www.rpmfind.net/ -Original Message- From: SpyProductions Support Team [mailto:support@;spyproductions.com] Sent: Friday, November 08, 2002 12:51 PM To: Black, Kelly W [PCS] Cc: [EMAIL PROTECTED] Subject: RE: MysQL Installation Well hells bells! Would that be the 'Client programs (i386) (2.3M)' mentioned on the download page? :) Thanks, Mike > -Original Message- > From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com] > Sent: Friday, November 08, 2002 2:17 PM > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > Subject: RE: MysQL Installation > > > Mysqladmin is seperate rpm > > ~K Black > > -Original Message- > From: SpyProductions Support Team [mailto:support@;spyproductions.com] > Sent: Friday, November 08, 2002 11:13 AM > To: [EMAIL PROTECTED] > Subject: MysQL Installation > > > > I just installed the most recent version of MySQL with an RPM (through > webmin interface), but it doesn't seem to have installed a > mysqladmin.anyone know why? :) > > Thanks! > > -Mike > > > > - > 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
Well hells bells! Would that be the 'Client programs (i386) (2.3M)' mentioned on the download page? :) Thanks, Mike > -Original Message- > From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com] > Sent: Friday, November 08, 2002 2:17 PM > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > Subject: RE: MysQL Installation > > > Mysqladmin is seperate rpm > > ~K Black > > -Original Message- > From: SpyProductions Support Team [mailto:support@;spyproductions.com] > Sent: Friday, November 08, 2002 11:13 AM > To: [EMAIL PROTECTED] > Subject: MysQL Installation > > > > I just installed the most recent version of MySQL with an RPM (through > webmin interface), but it doesn't seem to have installed a > mysqladmin.anyone know why? :) > > Thanks! > > -Mike > > > > - > 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
On Fri, 2002-11-08 at 14:12, SpyProductions Support Team wrote: > > I just installed the most recent version of MySQL with an RPM (through > webmin interface), but it doesn't seem to have installed a > mysqladmin.anyone know why? :) > > Thanks! > > -Mike > Probably you just installed the server not the client you need both. - 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
Mysqladmin is seperate rpm ~K Black -Original Message- From: SpyProductions Support Team [mailto:support@;spyproductions.com] Sent: Friday, November 08, 2002 11:13 AM To: [EMAIL PROTECTED] Subject: MysQL Installation I just installed the most recent version of MySQL with an RPM (through webmin interface), but it doesn't seem to have installed a mysqladmin.anyone know why? :) Thanks! -Mike - 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 - DB dies
D, Wednesday, April 24, 2002, 6:16:31 PM, you wrote: DO> Having followed instructions from various sources and installed from source (twice) and binary (once), I still get the following problem. DO> --- DO> [root mysql]# /usr/local/mysql/bin/safe_mysqld & DO> [1] 16168 DO> [root mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var DO> 020425 00:11:37 mysqld ended Please, look in the your .err file in the MySQL data dir and show me the contents of this file (but not the whole file! about last 20-40 rows ...) DO> DO> Please help! DO> I am using "Cobalt Linux release 6.0 (Carmel) Kernel 2.2.16C7 on an i586" DO> Thank you in advance. DO> Daniel. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
Re: MySql installation - DB dies - SOLVED
Opps sorry. Found the problem. Not starting as proper user. Thanks. D. -- On Wed, 24 April 2002, D Okonkwo wrote: > > Having followed instructions from various sources and installed from source (twice) >and binary (once), I still get the following problem. > --- > [root mysql]# /usr/local/mysql/bin/safe_mysqld & > [1] 16168 > [root mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var > 020425 00:11:37 mysqld ended > > > Please help! > I am using "Cobalt Linux release 6.0 (Carmel) Kernel 2.2.16C7 on an i586" > Thank you in advance. > Daniel. > > > > - > 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 problem with 3.23.49 Linux Source release on RH7.3 Beta 1.
Do you have g++ installed? It doesn't look like you do. On Friday 19 April 2002 1:45 pm, Ricky Sun wrote: > I am trying to install mysql 3.23.49 source release on RH7.3 Beta 1 > workstation... Encountered the following gcc C++ compiler executable > creation problem > > when ./configure checks for C++ compiler it complains : > > > checking for gcc... gcc > checking whether the C compiler (gcc ) works... yes > checking whether the C compiler (gcc ) is a cross-compiler... no > checking whether we are using GNU C... yes > checking whether gcc accepts -g... yes > checking for c++... no > checking for g++... no > checking for gcc... gcc > checking whether the C++ compiler (gcc ) works... no > configure: error: installation or configuration problem: C++ compiler = > =3D > cannot create executables. > > > > The version of gcc I am using is 2.96 2731... any hints? Why it's not > recognized as a C++ compiler? > > > $gcc -v > Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs > gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-109) > > > > - > 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 problem with 3.23.49 Linux Source release on RH7.3 Beta 1.
I am trying to install mysql 3.23.49 source release on RH7.3 Beta 1 workstation... Encountered the following gcc C++ compiler executable creation problem when ./configure checks for C++ compiler it complains : checking for gcc... gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... yes checking whether gcc accepts -g... yes checking for c++... no checking for g++... no checking for gcc... gcc checking whether the C++ compiler (gcc ) works... no configure: error: installation or configuration problem: C++ compiler = =3D cannot create executables. The version of gcc I am using is 2.96 2731... any hints? Why it's not recognized as a C++ compiler? $gcc -v Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-109) - 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 error
Jane, Probably u downloaded the file on your windows box and ftp'ed it using "ascii" mode instead of binary as Egor has suggested. -Prakash. -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 8:40 PM To: [EMAIL PROTECTED] Subject: Mysql installation error Jane, Wednesday, April 03, 2002, 12:27:33 AM, you wrote: JT> We have encountered the problem to install Mysql-3.23.49 version on Linux JT> Redhat 7.1. JT> 1. Run rpm with Mysql-3.23.49a-1.i386.rpm, the installation failed. JT> 2. Gunzip mysql-3.23.49.tar.gz, we got the error: invalid compressed JT> data--format violated. JT> Can anyone offer some assistance on what's happening here? Are you sure you have downloaded rpm and tar.gz files in binary format and correctly? JT> Thanks, JT> Jane Tsai -- For technical support contracts, goto https://order.mysql.com/ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help!
Great, the uppercase in $sth->{NUM_OF_FIELDS} works. Now I can start to
learn perl. Any advice on where could I find a good source for beginner on
the web? Thank you very much.
>From: ds <[EMAIL PROTECTED]>
>To: Andy Cheng <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: Mysql installation. Help!
>Date: 11 Mar 2002 19:41:08 +
>
>
>I don't understand the code. I copy it from a book. I am trying to print
>out
>the records returned from a query. I have a table named client in database
>andy. The table has 2 records. When I run the above code, I have 2 blank
>lines return. Could any one tell me what the problem is? Where could I
>find better documentation on DBI::DBD::mysql stuff for beginner? man
>DBD::mysql is difficult to understand. Thanks again for the info.
>
>#!/usr/bin/perl
>
>use DBI;
>$dbh=DBI->connect('DBI:mysql:andy');
>my $query="select * from client";
>my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
>$sth->execute;
>my $rows;
>while(@row=$sth->fetchrow_array)
>{my $i;
>for $i (0..($sth->{num_of_fields}-1))
>{print "[".$row[$i]."]";}
>print("\n");
>}
>$sth->finish;
>$dbh->disconnect
>Hi,
>I'm not an expert in perl too, but i would correct your code to this:
>
>#!/usr/bin/perl
>
>use DBI;
>$dbh=DBI->connect('DBI:mysql:andy');
>my $query="select * from client";
>my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
>$sth->execute;
>my $rows;
>while(@row=$sth->fetchrow_array)
>{my $i;
>for $i (0..($sth->{NUM_OF_FIELDS}-1))
>{print "[".$row[$i]."]";}
>print("\n");
>}
>$sth->finish;
>$dbh->disconnect
>
>Note the uppercase in $sth->{NUM_OF_FIELDS}.
>Also remove the line "my $rows"... It's doing nothing there.
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help!
>
> I don't understand the code. I copy it from a book. I am trying to print out
> the records returned from a query. I have a table named client in database
> andy. The table has 2 records. When I run the above code, I have 2 blank
> lines return. Could any one tell me what the problem is? Where could I
> find better documentation on DBI::DBD::mysql stuff for beginner? man
> DBD::mysql is difficult to understand. Thanks again for the info.
>
> #!/usr/bin/perl
>
> use DBI;
> $dbh=DBI->connect('DBI:mysql:andy');
> my $query="select * from client";
> my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
> $sth->execute;
> my $rows;
> while(@row=$sth->fetchrow_array)
> {my $i;
> for $i (0..($sth->{num_of_fields}-1))
> {print "[".$row[$i]."]";}
> print("\n");
> }
> $sth->finish;
> $dbh->disconnect
Hi,
I'm not an expert in perl too, but i would correct your code to this:
> #!/usr/bin/perl
>
> use DBI;
> $dbh=DBI->connect('DBI:mysql:andy');
> my $query="select * from client";
> my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
> $sth->execute;
> my $rows;
> while(@row=$sth->fetchrow_array)
> {my $i;
> for $i (0..($sth->{NUM_OF_FIELDS}-1))
> {print "[".$row[$i]."]";}
> print("\n");
> }
> $sth->finish;
> $dbh->disconnect
Note the uppercase in $sth->{NUM_OF_FIELDS}.
Also remove the line "my $rows"... It's doing nothing there.
>
> >From: "Chuck \"PUP\" Payne" <[EMAIL PROTECTED]>
> >To: Doug Thompson <[EMAIL PROTECTED]>, Andy Cheng
> ><[EMAIL PROTECTED]>, Intrex <[EMAIL PROTECTED]>,
> >"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> >Subject: Re: Mysql installation. Help!
> >Date: Sun, 10 Mar 2002 14:18:13 -0500
> >
> >Ok, if never run it then you have to start once, if I remember right undex
> >Red Hat, you have to go to /etc/rc.d/init.d and do this...
> >
> >./mysql start that will start it
> >
> >Then you will need to set it up so it will start later. SuSE you have to
> >start it once
> >
> >You will then need to set a password for mysql.
> >
> >I hope that helps.
> >
> >
> >
> > | Chuck Payne |
> > | Magi Design and Support |
> > | www.magidesign.com |
> > | [EMAIL PROTECTED] |
> >
> >
> >BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
> >Web Design you can afford.
> >
> >Fortune for today --
> >
> >Q: How many Zen masters does it take to screw in a light bulb?
> >A: None. The Universe spins the bulb, and the Zen master stays out
> > of the way.
> >
> >
> >
> > > If mysql.sock doesn't exist, that is because the server is not running.
> > >
> > > I fought the same battle as Mark and ultimately downloaded and installed
> >the
> > > RPM for 3.23.49a from MySQL in place of
> > > the copy that came with RH. The MySQL RPM installed and came up just
> >like it
> > > says in the book. Saves a lot of hair
> > > and dain bramage.
> > >
> > > If the server process _is_ running, it may be useful to go through the
> >section
> > > on binary installation and check those
> > > items to see if your RPM set everything up correctly. Don't bet on
> >finding
> > > anything, but it doesn't take long to do
> > > these checks.
> > > http://www.mysql.com/doc/I/n/Installing_binary.html
> > >
> > > Regards,
> > > Doug
> > >
> > > "Perfection is finally attained not when there is no longer anything to
> >add,
> > > but when there is no longer anything to
> > > take away." -- Antoine de Saint Exup?ry
> > >
> > > On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
> > >
> > >> What I did was beat my brains out on the same exact problem. In the
> >end I
> > >> have no clue what I did to get it actually working. I had re-installed
> >the
> > >> mysql from the .tar.gz, I installed all the RPM's several times.
> >Everytime,
> > >> I fully rebooted the system, and finally I have to run
> > >> safe_mysqld --user=root
> > >>
> > >> I think finaly I ran the tar -zxvf on th
Re: Mysql installation. Help!
I don't think you need to know DBD::mysql (DBD::mysql is a DBD driver to
mysql). Go and have a look at the man page of DBI. You'll get what you
need.
Andy Cheng wrote:
>
> Thanks for the help. I got it working. I could connect to mysql from shell
> command. Now I try to connect to mysql using perl. I installed the DBI::DBD
> module for perl. I think the DBI::DBD also working since I don't see error
> return running the following code:
>
> #!/usr/bin/perl
>
> use DBI;
> $dbh=DBI->connect('DBI:mysql:andy');
> my $query="select * from client";
> my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
> $sth->execute;
> my $rows;
> while(@row=$sth->fetchrow_array)
> {my $i;
> for $i (0..($sth->{num_of_fields}-1))
> {print "[".$row[$i]."]";}
> print("\n");
> }
> $sth->finish;
> $dbh->disconnect
>
> I don't understand the code. I copy it from a book. I am trying to print out
> the records returned from a query. I have a table named client in database
> andy. The table has 2 records. When I run the above code, I have 2 blank
> lines return. Could any one tell me what the problem is? Where could I
> find better documentation on DBI::DBD::mysql stuff for beginner? man
> DBD::mysql is difficult to understand. Thanks again for the info.
>
> >From: "Chuck \"PUP\" Payne" <[EMAIL PROTECTED]>
> >To: Doug Thompson <[EMAIL PROTECTED]>, Andy Cheng
> ><[EMAIL PROTECTED]>, Intrex <[EMAIL PROTECTED]>,
> >"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> >Subject: Re: Mysql installation. Help!
> >Date: Sun, 10 Mar 2002 14:18:13 -0500
> >
> >Ok, if never run it then you have to start once, if I remember right undex
> >Red Hat, you have to go to /etc/rc.d/init.d and do this...
> >
> >./mysql start that will start it
> >
> >Then you will need to set it up so it will start later. SuSE you have to
> >start it once
> >
> >You will then need to set a password for mysql.
> >
> >I hope that helps.
> >
> >
> >
> > | Chuck Payne |
> > | Magi Design and Support |
> > | www.magidesign.com |
> > | [EMAIL PROTECTED] |
> >
> >
> >BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
> >Web Design you can afford.
> >
> >Fortune for today --
> >
> >Q: How many Zen masters does it take to screw in a light bulb?
> >A: None. The Universe spins the bulb, and the Zen master stays out
> > of the way.
> >
> >
> >
> > > If mysql.sock doesn't exist, that is because the server is not running.
> > >
> > > I fought the same battle as Mark and ultimately downloaded and installed
> >the
> > > RPM for 3.23.49a from MySQL in place of
> > > the copy that came with RH. The MySQL RPM installed and came up just
> >like it
> > > says in the book. Saves a lot of hair
> > > and dain bramage.
> > >
> > > If the server process _is_ running, it may be useful to go through the
> >section
> > > on binary installation and check those
> > > items to see if your RPM set everything up correctly. Don't bet on
> >finding
> > > anything, but it doesn't take long to do
> > > these checks.
> > > http://www.mysql.com/doc/I/n/Installing_binary.html
> > >
> > > Regards,
> > > Doug
> > >
> > > "Perfection is finally attained not when there is no longer anything to
> >add,
> > > but when there is no longer anything to
> > > take away." -- Antoine de Saint Exup?ry
> > >
> > > On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
> > >
> > >> What I did was beat my brains out on the same exact problem. In the
> >end I
> > >> have no clue what I did to get it actually working. I had re-installed
> >the
> > >> mysql from the .tar.gz, I installed all the RPM's several times.
> >Everytime,
> > >> I fully rebooted the system, and finally I have to run
> > >> safe_mysqld --user=root
> > >>
> > >> I think finaly I ran the tar -zxvf on the mysqlmax..tar.gz,
> > >> rebooted the system, then re-ran safe_mysqld --user=root.
> > >>
> > >> Mark
> > >>
> > >> - Original Message -
> > >> From: "Andy Cheng" <[EMAIL PROTECTED]&
Re: Mysql installation. Help
Sorry I don't know perl. I am PHP man. And I am stll trying to learng mysql
so that I can get it working to the way I want.
Chuck Payne
Magi Design and Support
on 3/10/02 7:30 PM, Andy Cheng at [EMAIL PROTECTED] wrote:
> Thanks for the help. I got it working. I could connect to mysql from shell
> command. Now I try to connect to mysql using perl. I installed the DBI::DBD
> module for perl. I think the DBI::DBD also working since I don't see error
> return running the following code:
>
>
> #!/usr/bin/perl
>
> use DBI;
> $dbh=DBI->connect('DBI:mysql:andy');
> my $query="select * from client";
> my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
> $sth->execute;
> my $rows;
> while(@row=$sth->fetchrow_array)
> {my $i;
> for $i (0..($sth->{num_of_fields}-1))
> {print "[".$row[$i]."]";}
> print("\n");
> }
> $sth->finish;
> $dbh->disconnect
>
> I don't understand the code. I copy it from a book. I am trying to print out
> the records returned from a query. I have a table named client in database
> andy. The table has 2 records. When I run the above code, I have 2 blank
> lines return. Could any one tell me what the problem is? Where could I
> find better documentation on DBI::DBD::mysql stuff for beginner? man
> DBD::mysql is difficult to understand. Thanks again for the info.
>
>
>
>
>
>> From: "Chuck \"PUP\" Payne" <[EMAIL PROTECTED]>
>> To: Doug Thompson <[EMAIL PROTECTED]>, Andy Cheng
>> <[EMAIL PROTECTED]>, Intrex <[EMAIL PROTECTED]>,
>> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>> Subject: Re: Mysql installation. Help!
>> Date: Sun, 10 Mar 2002 14:18:13 -0500
>>
>> Ok, if never run it then you have to start once, if I remember right undex
>> Red Hat, you have to go to /etc/rc.d/init.d and do this...
>>
>> ./mysql start that will start it
>>
>> Then you will need to set it up so it will start later. SuSE you have to
>> start it once
>>
>> You will then need to set a password for mysql.
>>
>> I hope that helps.
>>
>>
>>
>> | Chuck Payne |
>> | Magi Design and Support |
>> | www.magidesign.com |
>> | [EMAIL PROTECTED] |
>>
>>
>> BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
>> Web Design you can afford.
>>
>> Fortune for today --
>>
>> Q: How many Zen masters does it take to screw in a light bulb?
>> A: None. The Universe spins the bulb, and the Zen master stays out
>> of the way.
>>
>>
>>
>>> If mysql.sock doesn't exist, that is because the server is not running.
>>>
>>> I fought the same battle as Mark and ultimately downloaded and installed
>> the
>>> RPM for 3.23.49a from MySQL in place of
>>> the copy that came with RH. The MySQL RPM installed and came up just
>> like it
>>> says in the book. Saves a lot of hair
>>> and dain bramage.
>>>
>>> If the server process _is_ running, it may be useful to go through the
>> section
>>> on binary installation and check those
>>> items to see if your RPM set everything up correctly. Don't bet on
>> finding
>>> anything, but it doesn't take long to do
>>> these checks.
>>> http://www.mysql.com/doc/I/n/Installing_binary.html
>>>
>>> Regards,
>>> Doug
>>>
>>> "Perfection is finally attained not when there is no longer anything to
>> add,
>>> but when there is no longer anything to
>>> take away." -- Antoine de Saint Exup?ry
>>>
>>> On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
>>>
>>>> What I did was beat my brains out on the same exact problem. In the
>> end I
>>>> have no clue what I did to get it actually working. I had re-installed
>> the
>>>> mysql from the .tar.gz, I installed all the RPM's several times.
>> Everytime,
>>>> I fully rebooted the system, and finally I have to run
>>>> safe_mysqld --user=root
>>>>
>>>> I think finaly I ran the tar -zxvf on the mysqlmax..tar.gz,
>>>> rebooted the system, then re-ran safe_mysqld --user=root.
>>>>
>>>> Mark
>>>>
>>>> - Original Message -
>>>> From: "Andy Cheng" <[EMAIL PROTECTED]&
Re: Mysql installation. Help!
Thanks for the help. I got it working. I could connect to mysql from shell
command. Now I try to connect to mysql using perl. I installed the DBI::DBD
module for perl. I think the DBI::DBD also working since I don't see error
return running the following code:
#!/usr/bin/perl
use DBI;
$dbh=DBI->connect('DBI:mysql:andy');
my $query="select * from client";
my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
$sth->execute;
my $rows;
while(@row=$sth->fetchrow_array)
{my $i;
for $i (0..($sth->{num_of_fields}-1))
{print "[".$row[$i]."]";}
print("\n");
}
$sth->finish;
$dbh->disconnect
I don't understand the code. I copy it from a book. I am trying to print out
the records returned from a query. I have a table named client in database
andy. The table has 2 records. When I run the above code, I have 2 blank
lines return. Could any one tell me what the problem is? Where could I
find better documentation on DBI::DBD::mysql stuff for beginner? man
DBD::mysql is difficult to understand. Thanks again for the info.
>From: "Chuck \"PUP\" Payne" <[EMAIL PROTECTED]>
>To: Doug Thompson <[EMAIL PROTECTED]>, Andy Cheng
><[EMAIL PROTECTED]>, Intrex <[EMAIL PROTECTED]>,
>"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>Subject: Re: Mysql installation. Help!
>Date: Sun, 10 Mar 2002 14:18:13 -0500
>
>Ok, if never run it then you have to start once, if I remember right undex
>Red Hat, you have to go to /etc/rc.d/init.d and do this...
>
>./mysql start that will start it
>
>Then you will need to set it up so it will start later. SuSE you have to
>start it once
>
>You will then need to set a password for mysql.
>
>I hope that helps.
>
>
>
> | Chuck Payne |
> | Magi Design and Support |
> | www.magidesign.com |
> | [EMAIL PROTECTED] |
>
>
>BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
>Web Design you can afford.
>
>Fortune for today --
>
>Q: How many Zen masters does it take to screw in a light bulb?
>A: None. The Universe spins the bulb, and the Zen master stays out
> of the way.
>
>
>
> > If mysql.sock doesn't exist, that is because the server is not running.
> >
> > I fought the same battle as Mark and ultimately downloaded and installed
>the
> > RPM for 3.23.49a from MySQL in place of
> > the copy that came with RH. The MySQL RPM installed and came up just
>like it
> > says in the book. Saves a lot of hair
> > and dain bramage.
> >
> > If the server process _is_ running, it may be useful to go through the
>section
> > on binary installation and check those
> > items to see if your RPM set everything up correctly. Don't bet on
>finding
> > anything, but it doesn't take long to do
> > these checks.
> > http://www.mysql.com/doc/I/n/Installing_binary.html
> >
> > Regards,
> > Doug
> >
> > "Perfection is finally attained not when there is no longer anything to
>add,
> > but when there is no longer anything to
> > take away." -- Antoine de Saint Exup?ry
> >
> > On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
> >
> >> What I did was beat my brains out on the same exact problem. In the
>end I
> >> have no clue what I did to get it actually working. I had re-installed
>the
> >> mysql from the .tar.gz, I installed all the RPM's several times.
>Everytime,
> >> I fully rebooted the system, and finally I have to run
> >> safe_mysqld --user=root
> >>
> >> I think finaly I ran the tar -zxvf on the mysqlmax..tar.gz,
> >> rebooted the system, then re-ran safe_mysqld --user=root.
> >>
> >> Mark
> >>
> >> - Original Message -
> >> From: "Andy Cheng" <[EMAIL PROTECTED]>
> >> To: <[EMAIL PROTECTED]>
> >> Sent: Sunday, March 10, 2002 10:01 AM
> >> Subject: Mysql installation. Help!
> >>
> >>
> >>> Hi all,
> >>> I got this error message when trying to connect to mysql at the shell
> >>> command:
> >>>
> >>> Error 2002:Can't connect to local MySql server through socket
> >>> '/var/lib/mysql/mysql.sock
> >>>
> >>>
> >>> There is no mysql.sock in the /var/lib/mysql directory. Did I miss
>some
> >>> thing in the mysql installation? Where could I find the mysql.sock?
>I
> >>> instal
Re: Mysql installation. Help!
Ok, if never run it then you have to start once, if I remember right undex Red Hat, you have to go to /etc/rc.d/init.d and do this... ./mysql start that will start it Then you will need to set it up so it will start later. SuSE you have to start it once You will then need to set a password for mysql. I hope that helps. | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Fortune for today -- Q: How many Zen masters does it take to screw in a light bulb? A: None. The Universe spins the bulb, and the Zen master stays out of the way. > If mysql.sock doesn't exist, that is because the server is not running. > > I fought the same battle as Mark and ultimately downloaded and installed the > RPM for 3.23.49a from MySQL in place of > the copy that came with RH. The MySQL RPM installed and came up just like it > says in the book. Saves a lot of hair > and dain bramage. > > If the server process _is_ running, it may be useful to go through the section > on binary installation and check those > items to see if your RPM set everything up correctly. Don't bet on finding > anything, but it doesn't take long to do > these checks. > http://www.mysql.com/doc/I/n/Installing_binary.html > > Regards, > Doug > > "Perfection is finally attained not when there is no longer anything to add, > but when there is no longer anything to > take away." -- Antoine de Saint Exup?ry > > On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote: > >> What I did was beat my brains out on the same exact problem. In the end I >> have no clue what I did to get it actually working. I had re-installed the >> mysql from the .tar.gz, I installed all the RPM's several times. Everytime, >> I fully rebooted the system, and finally I have to run >> safe_mysqld --user=root >> >> I think finaly I ran the tar -zxvf on the mysqlmax..tar.gz, >> rebooted the system, then re-ran safe_mysqld --user=root. >> >> Mark >> >> - Original Message - >> From: "Andy Cheng" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Sunday, March 10, 2002 10:01 AM >> Subject: Mysql installation. Help! >> >> >>> Hi all, >>> I got this error message when trying to connect to mysql at the shell >>> command: >>> >>> Error 2002:Can't connect to local MySql server through socket >>> '/var/lib/mysql/mysql.sock >>> >>> >>> There is no mysql.sock in the /var/lib/mysql directory. Did I miss some >>> thing in the mysql installation? Where could I find the mysql.sock? I >>> install mysql that came with redhat 7.2. Thank for the help. >>> > > > > > > > > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help!
If mysql.sock doesn't exist, that is because the server is not running. I fought the same battle as Mark and ultimately downloaded and installed the RPM for 3.23.49a from MySQL in place of the copy that came with RH. The MySQL RPM installed and came up just like it says in the book. Saves a lot of hair and dain bramage. If the server process _is_ running, it may be useful to go through the section on binary installation and check those items to see if your RPM set everything up correctly. Don't bet on finding anything, but it doesn't take long to do these checks. http://www.mysql.com/doc/I/n/Installing_binary.html Regards, Doug "Perfection is finally attained not when there is no longer anything to add, but when there is no longer anything to take away." -- Antoine de Saint Exupry On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote: >What I did was beat my brains out on the same exact problem. In the end I >have no clue what I did to get it actually working. I had re-installed the >mysql from the .tar.gz, I installed all the RPM's several times. Everytime, >I fully rebooted the system, and finally I have to run >safe_mysqld --user=root > >I think finaly I ran the tar -zxvf on the mysqlmax..tar.gz, >rebooted the system, then re-ran safe_mysqld --user=root. > >Mark > >- Original Message - >From: "Andy Cheng" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Sunday, March 10, 2002 10:01 AM >Subject: Mysql installation. Help! > > >> Hi all, >> I got this error message when trying to connect to mysql at the shell >> command: >> >> Error 2002:Can't connect to local MySql server through socket >> '/var/lib/mysql/mysql.sock >> >> >> There is no mysql.sock in the /var/lib/mysql directory. Did I miss some >> thing in the mysql installation? Where could I find the mysql.sock? I >> install mysql that came with redhat 7.2. Thank for the help. >> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help!
What I did was beat my brains out on the same exact problem. In the end I have no clue what I did to get it actually working. I had re-installed the mysql from the .tar.gz, I installed all the RPM's several times. Everytime, I fully rebooted the system, and finally I have to run safe_mysqld --user=root I think finaly I ran the tar -zxvf on the mysqlmax..tar.gz, rebooted the system, then re-ran safe_mysqld --user=root. Mark - Original Message - From: "Andy Cheng" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 10, 2002 10:01 AM Subject: Mysql installation. Help! > Hi all, > I got this error message when trying to connect to mysql at the shell > command: > > Error 2002:Can't connect to local MySql server through socket > '/var/lib/mysql/mysql.sock > > > There is no mysql.sock in the /var/lib/mysql directory. Did I miss some > thing in the mysql installation? Where could I find the mysql.sock? I > install mysql that came with redhat 7.2. Thank for the help. > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql installation on linux(RH7.2)
"nagendra prasad" <[EMAIL PROTECTED]> writes: > hi > i downloaded mysql rpms from mysql.com > & tried to install them on linux. > when i use the command rpm -i mysqlpackname in shell > it says > > error:can't get exclusive lock on /var/lib/rpm/packages > error:can't open packages database in /var/lib/rpm > > what shall i do. Install as root. -- Trond Eivind Glomsrød Red Hat, Inc. - 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/Configuration
At 13:35 15/02/2002 -0500, Juwon Aikulola wrote: Hi! >Hi Gurus, >I downloaded and installed MySql successfully, on a Windows 2000 O/S. I >want to locate the "my-example.cnf" file, copy it to my root directory and >rename it "my.cnf". However, the "my-example.cnf" file I locate is a >shortcut, pointing to no physical target. The shortcut was created because in your environment the extension .cnf was applied for an MS application. Open my computer. In the Tool menu, open Folder Options. Click the Tab Files Types. Search for the .cnf extension and remove it (if you don't need this set file option). Create the my.cnf file again. Regards, Miguel > As a result, after going through this process, I cannot open the file to > uncomment and edit the "basedir" line to point to MySql installation directory. >Somebody please help. > >Thanks > >Juwon > >_ >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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ 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
Re: mysql++ installation
Just ignore automake warnings. Regarding /opt/sfw/bin/ginstall problems, configure probably erred. Make a symlink so that the above ginstall points to the real one. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ 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
Re: Mysql installation problem on NT
Hi Joachim I tried to install mySQL on Windows NT (Service Pack 6). That means: Unzipping, installing, then starting mySQL as a service with : mysqld-nt --install. Until now everything worked fine and we saw the service in the NT's Service list. But we could not start the service. Neither with NT nor with "NET START mysql" from the DOS box. There was an error 1067. =in the Services list what were the values? Was the status "started" and is startup automatic or manual. =When mine installed, it came up auto and started automatically. Thus there was no need to use the DOS box/NET command! One more thing to explain: We installed mySQL in a directory D:\inst\\ When we started: mysqld-nt --install there was no file my.cnf. (Because my installation in the office is in C:\mysql I forgot to save my.cnf in WINNT). Maybe thats the problem. But I don´t know. =use Windows Explorer or My Computer, navigate to the MySQL\bin sub-directory. Execute the WinMySQLAdmin program and customise the relevant directory fields, then restart the MySQL server. Second question: How to get rid of the mysql-service in the NT service list. You see I'm not very accustomed to WIN NT. =the above answers this - it should start automatically. You should be able to use the admin GUI to stop and restart it, if/when necessary, otherewise it will start automatically on every NT boot. I hope somebody will help me. =hope it has been helpful, =dn - 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 on Linux
or you could just say rpm -ivh MYSQL-* then it will install all mysql packages Jim - Original Message - From: "MySQL" <[EMAIL PROTECTED]> To: "Donna Zeller" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, November 20, 2001 12:30 PM Subject: SV: MySQL Installation on Linux > Hi Donna, > > Try this. That was the way i've installed Mysql on my server. > > rpm -ivh MySQL-3.23.44-1.i386.rpm > rpm -ivh MySQL-client-3.23.44-1.i386.rpm > > Please notice, that you have to use the RPM command 2 times. > > Regards > > Frank > Denmark. > > <---> > > http://www.tuffy.dk > > <---> > > -Oprindelig meddelelse- > Fra: Donna Zeller [mailto:[EMAIL PROTECTED]] > Sendt: 20. november 2001 21:00 > Til: [EMAIL PROTECTED] > Emne: MySQL Installation on Linux > > > 11/19/01 > > Linux version 2.2 > > rpm -i MySQL-3.23.44-1.i386.rpm MySQL-client-3.23.44-1.i386.rpm > > Error Message: MySQL-client-3.23.44-1.i386.rpm can not be installed > > RPM files in usr/local/mysql > client > server > benchmark > libraries > shared libraries > > > > - > 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: MySQL installation problem
On Mon, 12 Nov 2001, ? wrote: > > You need to get gcc-2.95.2 over newer. It is available on the > > stage.caldera.com site. or http://www.caldera.com/skunkware. > > > I do this, but message is the same: > gcc -03 -DDBUG_OFF -DSCO -O conf_to_src conf_tosrc.o -lcrypt -lsocket -lm > Undefined first referenced symbol in file > main /usr/ccs/lib/crt1.o > conf_to_src: fatal error: Symbol referencing errors. No output written to > conf_to_src > ***Error code 1 (bu21) > ***Error code 1 (bu21) > ***Error code 1 (bu21) > (I install MySQL 3.23.43 on SCO Open Server 3.2 v5.0.4 > Other software: FSU Pthreads 3.5, gcc-2.95.2, GNU Make 3.78.1) > Can You help me? Did you install the libraries and linkers from the CD. That file is part of the libraries and linkers. Also have you installed all the patches? I just did a complete make with out any problems on my OSR 5.0.4 system. I am using GNU Make 3.79.1 and FSU Pthreads 3.8. Foy can get the 3.8. from. I know that 5.0.4 and pervious versions are very buggy. Unfortunately my ftp.zenez.com site is down. The site below has many of what I consider to be the most important files. ftp://ftp.lerctr.org/pub/zenez Good Luck, -- Boyd Gerber <[EMAIL PROTECTED]> ZENEZ 3748 Valley Forge Road, Magna Utah 84044 Office 801-250-0795 FAX 801-250-7975 - 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 problem
- Original Message - From: "Boyd Lynn Gerber" <[EMAIL PROTECTED]> To: "é×ÁÎ ðÏÎÏÍÁÒÅ×" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, November 11, 2001 5:57 PM Subject: Re: MySQL installation problem > You need to get gcc-2.95.2 over newer. It is available on the > stage.caldera.com site. or http://www.caldera.com/skunkware. > I do this, but message is the same: gcc -03 -DDBUG_OFF -DSCO -O conf_to_src conf_tosrc.o -lcrypt -lsocket -lm Undefined first referenced symbol in file main /usr/ccs/lib/crt1.o conf_to_src: fatal error: Symbol referencing errors. No output written to conf_to_src ***Error code 1 (bu21) ***Error code 1 (bu21) ***Error code 1 (bu21) (I install MySQL 3.23.43 on SCO Open Server 3.2 v5.0.4 Other software: FSU Pthreads 3.5, gcc-2.95.2, GNU Make 3.78.1) Can You help me? - 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: Re: MySQL installation problem
database,sql,query,table You have written the following: You need to get gcc-2.95.2 over newer. It is available on the stage.caldera.com site. or http://www.caldera.com/skunkware. Good Luck, -- Boyd Gerber <[EMAIL PROTECTED]> ZENEZ 3748 Valley Forge Road, Magna Utah 84044 Office 801-250-0795 FAX 801-250-7975 - 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 on NT problem
hi ! thanx for your reply. now i could install mysql on my NT. nut now when i give the command mysql-nt --install it says unable to install. moreover as it is in the installaton doci tried to look for the my-example.cnf file but i cud get only a link of this name in whole of my hard disk and that too is a speedDial file (clicking on it opens the MS-netmeeting configuration dialogue). please help. sumit - Original Message - From: "Antonie Neethling" <[EMAIL PROTECTED]> To: "Sumit Ranjan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 07, 2001 5:34 PM Subject: RE: mysql installation on NT problem > Hi, > > Try to extract the files before running setup.exe. If this does not work you > zip archive may be corrupt. > > Regards, > Antonie > > -- S C I B I T -- > Antonie Neethling ([EMAIL PROTECTED]) > http://www.scibit.com/mysql - MySQL related products > -- S C I B I T -- > > > -Original Message- > > From: Sumit Ranjan [mailto:[EMAIL PROTECTED]] > > Sent: Friday, September 07, 2001 1:40 PM > > To: [EMAIL PROTECTED] > > Subject: mysql installation on NT problem > > > > > > hi all ! > >i am new to mysql and trying to install it onto my win NT 4.0 > > workstation. > >but the winzip is not able to install it ! > > > >is anybody else facing the same prob? > >does anybody know the cure? > > > > sumit > > > > > > > > - > > 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 on NT problem
Hi, Try to extract the files before running setup.exe. If this does not work you zip archive may be corrupt. Regards, Antonie -- S C I B I T -- Antonie Neethling ([EMAIL PROTECTED]) http://www.scibit.com/mysql - MySQL related products -- S C I B I T -- > -Original Message- > From: Sumit Ranjan [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 07, 2001 1:40 PM > To: [EMAIL PROTECTED] > Subject: mysql installation on NT problem > > > hi all ! >i am new to mysql and trying to install it onto my win NT 4.0 > workstation. >but the winzip is not able to install it ! > >is anybody else facing the same prob? >does anybody know the cure? > > sumit > > > > - > 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 Problem
Antonio Scotti writes: > I downloaded the libraries but I'm experiencing problems in installing > them. I've decompressed them then I've run "automake" and "autoconf". No > problem. At this point I tried "./configure" but during the process it stops > with an error saying that cannot find mysql libraries in ' ' . What does it > mean? What have i to do to install the APIs? Obviously I have installed the > mysql server. > > Thanks in advice to everybody. > > Antonio Scotti > There are options for configure that let you specify mysql C API includes directory and libs directory. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ 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
Re: Mysql Installation
Jaitly, Rajiv (Contractor) schrieb am Dienstag, 21. August 2001, 10:14:33: > I installed the latest release of MYSQL on windows 2000 environment (non > networked). I would like to add the mysql server start up as a service at > system startup. Could anybody tell me how to do this. >From my readme: This distribution of MySQL includes the new winmysqladmin.exe by Miguel A. Solórzano. With this you can install MySQL as a service, start the service and monitor MySQL. This will also automaticly shut down MySQL on Win9x when the machine needs to be rebooted. Don't know if this applies to NT as well, but I should think so and you can find out immediately. -- Herzlich Werner MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - 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
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 from source
You have some 'odd' options in your configuration line...Have you tried using a 'simple' configuration to see if it will buildproperly ? ./configure --prefix=/apps/mysqlAre you in the "/apps/mysql" directory when you run "mysql_install_db" ??(you should actually be typing "./bin/mysql_install_db" )If you're getting the message "Can't start server: Bind on TCP/IP port:Address already in use, Do you already have another mysqld server running onport: 3306" did you check to see if you DO have it running already ? (type"ps -ef | grep mysql" )I have attached my 'build' and 'configure' webdocs for MySQL. Thedirectory 'paths' will be different than yours, but the rest should coverwhat you should be doing... (I've never had a problembuilding/installing/running MySQL on any RedHat 6.2 system). Look closelyat the permission settings I use.- Original Message -From: "Aditya Dhekney" <[EMAIL PROTECTED]>To: "'Steve Brazill'" <[EMAIL PROTECTED]>; <,[EMAIL PROTECTED]>Sent: Thursday, June 21, 2001 12:50 PMSubject: RE: mysql installation from source>> -----Original Message-----> From: Steve Brazill [mailto:[EMAIL PROTECTED]]> Sent: Thursday, June 21, 2001 3:38 PM> To: Aditya Dhekney> Cc: [EMAIL PROTECTED]> Subject: Re: mysql installation from source>>> Could you list (exactly) what commands you are using to 'unpack',> 'configure', 'build', and 'install' the distribution (which package haveyou> downloaded ?) ??>>> i'm using mysql-3.23.39.tar.gz>> these are the EXACT commands i used:>> tar -zxvf mysql-3.23.39.tar.gz>> cd mysql-3.23.39>> CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -f> no-exceptions -fno-rtti"./configure --prefix=/apps/mysql --enable-assembler> --> with-mysqld-ldflags=-all-static>> make>> make install>> scripts/mysql_install_db>> chown -R root /apps/mysql/>> chown -R mysql /apps/mysql/var>> chgrp -R mysql /apps/mysql/>> /apps/mysql/bin/safe_mysqld --user=mysql &>> (this is where i get the first error (mysqld ended)>> in my host.err file, i get this:> 010621 15:11:40 mysqld started> 010621 15:11:40 Can't start server: Bind on TCP/IP port: Address alreadyin> use> 010621 15:11:40 Do you already have another mysqld server running onport:> 3306> ?> 010621 15:11:40 Aborting>> 010621 15:11:40 /apps/mysql/libexec/mysqld: Shutdown Complete>> 010621 15:11:40 mysqld ended>> BUT, when i run ps, mysqld is NOT listed...:(>> I get the "check if tmp/mysql.sock exists" error when i try to use> mysqladmin tool.>> should i be concerned about the message that says to check tmp/mysql.sock?>> Thanks,> Aditya> - Original Message -> From: "Aditya Dhekney" <[EMAIL PROTECTED]>> To: <[EMAIL PROTECTED]>> Sent: Thursday, June 21, 2001 12:19 PM> Subject: mysql installation from source>>> > Hi,> > I have been trying to install mysql on my server for way too long now!my> > system specs are: intel i686, with linux 6.2 loaded.> >> > I think i once did get the installation to work almost correctly, or at> > least more correctly than it does now...> >> > the problem: when i compile/make etc., i get no errors at all, so...you> may> > think...this is good! BUT, unfortunately every time i do this, there isno> > mysql.sock file in the /tmp/ directory...infact, it's nowhere on the> > system!!! why would this be the case? where is it? and why doesn't the> > setup create it? can someone PLEASE suggest what i can do...i'm out of> > ideas as to what could be causing this problem!> >> > Thanks in advance,> > Aditya Dhekney> > [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: mysql installation from source
-Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 3:31 PM To: Aditya Dhekney; [EMAIL PROTECTED] Subject: Re: mysql installation from source I think mysql.sock gets created once you start the server. Have you tried starting it and then looking in /tmp? Cal yes, i've tried that...i think.. when i run: bin/safe_mysqld & i get: [root@oddjob mysql]# Starting mysqld daemon with databases from /apps/mysql/var 010621 15:53:49 mysqld ended thanks again, aditya * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: "Aditya Dhekney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 21, 2001 2:19 PM Subject: mysql installation from source > Hi, > I have been trying to install mysql on my server for way too long now! my > system specs are: intel i686, with linux 6.2 loaded. > > I think i once did get the installation to work almost correctly, or at > least more correctly than it does now... > > the problem: when i compile/make etc., i get no errors at all, so...you may > think...this is good! BUT, unfortunately every time i do this, there is no > mysql.sock file in the /tmp/ directory...infact, it's nowhere on the > system!!! why would this be the case? where is it? and why doesn't the > setup create it? can someone PLEASE suggest what i can do...i'm out of > ideas as to what could be causing this problem! > > Thanks in advance, > Aditya Dhekney > [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 > > - 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 from source
Could you list (exactly) what commands you are using to 'unpack', 'configure', 'build', and 'install' the distribution (which package have you downloaded ?) ?? - Original Message - From: "Aditya Dhekney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 21, 2001 12:19 PM Subject: mysql installation from source > Hi, > I have been trying to install mysql on my server for way too long now! my > system specs are: intel i686, with linux 6.2 loaded. > > I think i once did get the installation to work almost correctly, or at > least more correctly than it does now... > > the problem: when i compile/make etc., i get no errors at all, so...you may > think...this is good! BUT, unfortunately every time i do this, there is no > mysql.sock file in the /tmp/ directory...infact, it's nowhere on the > system!!! why would this be the case? where is it? and why doesn't the > setup create it? can someone PLEASE suggest what i can do...i'm out of > ideas as to what could be causing this problem! > > Thanks in advance, > Aditya Dhekney > [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 > - 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 from source
I think mysql.sock gets created once you start the server. Have you tried starting it and then looking in /tmp? Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: "Aditya Dhekney" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 21, 2001 2:19 PM Subject: mysql installation from source > Hi, > I have been trying to install mysql on my server for way too long now! my > system specs are: intel i686, with linux 6.2 loaded. > > I think i once did get the installation to work almost correctly, or at > least more correctly than it does now... > > the problem: when i compile/make etc., i get no errors at all, so...you may > think...this is good! BUT, unfortunately every time i do this, there is no > mysql.sock file in the /tmp/ directory...infact, it's nowhere on the > system!!! why would this be the case? where is it? and why doesn't the > setup create it? can someone PLEASE suggest what i can do...i'm out of > ideas as to what could be causing this problem! > > Thanks in advance, > Aditya Dhekney > [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 > > - 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 problem
On Thu, May 31, 2001 at 06:27:38PM +0800, yewei wrote: > Hi Dear Sir/Mdm, > > I've encountered a problem when I run 'scripts/mysql_install_db' > command. The error message is following: > > Starting mysql server > ./bin/safe_mysqld: /my/gnu/bin/hostname: not found > ./bin/safe_mysqld: /my/gnu/bin/hostname: not found > ./bin/safe_mysqld: /my/gnu/bin/hostname: not found > Starting mysqld demon with databases from > /usr/local/mysql-3.21.33b-sun-solaris2 > .6-sparc/data > mysqld demon ended > > I've followed the procedure of installation. What's wrong? Need to > configure something? Wow. That's a really old version of MySQL. I'd suggest getting one of the newer releases before you spend much time with it. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 6 days, processed 38,250,369 queries (73/sec. avg) - 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 in a user account
On Sat, 5 May 2001, David Loke wrote: > Hi Guys! > > I am a web server system administrator. I would like to enable the users of > my server to be able to install MySQL individually. That means each user > will have their individual MySQL root access. And from there, their PHP can > connect to their MySQL db. Is that possible? yeah, when start mysqld, every user must specify it's own --datadir --socket --user --P Every user must run mysql_install_db, specify --datadir, to make mysql priviliges database, though. - 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
