Re: how do I make utf8 the default encoding for my MySQL installation
Am 18.11.2011 04:31, schrieb Martin Mueller: [mysqld] init_connect=’SET collation_connection = utf8_general_ci’ init_connect=’SET NAMES utf8′ default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci skip-character-set-client-handshake On a Mac with MySQL 5.5.17 this produces the error [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-character-set=utf8' character-set-server = utf8 collation-server = utf8_general_ci and done default-character-set is an older option, was long time deprecated and removed - you should NEVER paste options in your configs only because some random guy say they do what you want before you read the manuals what they are doing signature.asc Description: OpenPGP digital signature
how do I make utf8 the default encoding for my MySQL installation
Is it possible to make utf8 the default for all databases and transactions in a MySQL installation? The current default is Latin1. There is a suggestion on the Web to edit the my.cnf file as follows [mysqld] init_connect=’SET collation_connection = utf8_general_ci’ init_connect=’SET NAMES utf8′ default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci skip-character-set-client-handshake On a Mac with MySQL 5.5.17 this produces the error [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-character-set=utf8' The Reference Manual is very tortuous but lacks instructions that are clear to a not very technical user. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: how do I make utf8 the default encoding for my MySQL installation
On Friday, November 18, 2011 at 03:31:44 UTC, martin.muel...@mac.com confabulated: Is it possible to make utf8 the default for all databases and transactions in a MySQL installation? The current default is Latin1. There is a suggestion on the Web to edit the my.cnf file as follows [mysqld] init_connect=’SET collation_connection = utf8_general_ci’ init_connect=’SET NAMES utf8′ default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci skip-character-set-client-handshake On a Mac with MySQL 5.5.17 this produces the error [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-character-set=utf8' The Reference Manual is very tortuous but lacks instructions that are clear to a not very technical user. http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-character-set The above link says default-character-set is depreciated and you should be using character-set-server. It also states default-character-set was removed in v5.5.3. You should be able to remove the option. -- There are 10 kinds of people in the world... Those who understand binary, and those who don't. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Mysql installation - Innodb not enabled?
Good day all We have downloaded the following MySQL version which untarred to provide a list of RPM's: MySQL-server-advanced-gpl-5.1.50-1.rhel5.x86_64.tar The installations went through fine, however while doing some configurations I found that Innodb is not enabled / installed. When configuring the Innodb paramters in the log files, I get the following errors when I try to start up the database: 101118 11:21:41 [ERROR] Plugin 'InnoDB' init function returned error. 101118 11:21:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 101118 11:23:51 [ERROR] Parsing options for plugin 'InnoDB' failed. 101118 11:23:51 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_flush_log_at_trx_commit=1' 101118 11:23:51 [ERROR] Aborting Could anyone please assist me with this issue. It would be much appreciated. FYI, the RPMS that came within the tar file are as follows: MySQL-advanced-gpl-debuginfo-5.1.50-1.rhel5.x86_64.rpm MySQL-server-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm MySQL-client-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm MySQL-shared-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm MySQL-devel-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm MySQL-shared-compat-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm MySQL-embedded-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm MySQL-test-advanced-gpl-5.1.50-1.rhel5.x86_64.rpm Regards Machiel
Suggestion : Better error message for hostname resolution error during MySQL installation
Hello everyone, Recently, while installing MySQL, I ran into an error[1] which complained about the hostname: --- Neither host 'blahblah' nor 'localhost' could be looked up with /usr/bin/resolveip Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option --- I looked a bit into the scripts/mysql_install_db script and was able to figure out what the real issue was (as explained in that blog[1]). In short, the /usr/bin/resolveip is a non-existent command (due to incorrect path). So, in such cases, would it be possible to print out a better error message which would tell the users what the real problem is? Something like: /usr/bin/resolveip command not found. Make sure basedir (and other variables) point to the right location. Tip: resolveip can be located in the bin folder of MySQL download location. [1] http://tinyurl.com/35l5lvg regards, -Jaikiran
MySQL Installation Not Working
Hi, I've tried several times now to get a local installation of MySQL going on my iMac (w/ OS X ver. 10.5.6). I've carefully tried everything I could comprehend to do per the mysql.com resource pages/ manual. I have also tried several procedures I discovered via Google searches that seemed to be promising/authoritative. Throughout this process I have encountered so many obstacles I've lost count. I have deleted and reinstalled the whole MySQL package (mysql-5.1.32-osx10.5- x86.dmg) 4 times while trying to follow the documentation with excruciating attention to the detail and nuances. I think I have encountered every version of 'permission denied', 'unable to open socket', unable to find 'my_print_defaults', 'unable to bind on port 3306', 'unable to access pid file' type of error possible. I am absolutely drowning in barely comprehended documentation, tips and tricks that have taken me down one dead end after another. Is there any way an ordinary person who doesn't walk on water with UNIX and is not able to manufacture a supercomputer with his pocketknife can get a simple 'local' MySQL installation going on his Mac? This is an appeal for help from someone who has wrestled with the official documentation to the point that it's liable to become a textbook case of 'terminal computer- frustration'. I wasn't able to figure out exactly how to comply with your 'MUST use the ./bin/mysqlbug script!' directive so I've copied and pasted the results of running that script below (please accept my apologies if these results were supposed to be transmitted in a different way). SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: DPD To: mysql@lists.mysql.com Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-5.1.32 (MySQL Community Server (GPL)) C compiler:i686-apple-darwin9-gcc-4.0.1 (GCC) 4.0.1 (Apple Inc. build 5465) C++ compiler: i686-apple-darwin9-gcc-4.0.1 (GCC) 4.0.1 (Apple Inc. build 5465) Environment: machine, os, target, libraries (multiple lines) System: Darwin DPD-Mac.local 9.6.0 Darwin Kernel Version 9.6.0: Mon Nov 24 17:37\ :00 PST 2008; root:xnu-1228.9.59~1/RELEASE_I386 i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using built-in specs. Target: i686-apple-darwin9 Configured with: /var/tmp/gcc/gcc-5490~1/src/configure --disable- checking -enabl\ e-werror --prefix=/usr --mandir=/share/man --enable-languages=c,objc,c+ +,obj-c++\ --program-transform-name=/^[cg][^.-]*$/s/$/-4.0/ --with-gxx-include- dir=/includ\ e/c++/4.0.0 --with-slibdir=/usr/lib --build=i686-apple-darwin9 --with- arch=apple\ --with-tune=generic --host=i686-apple-darwin9 --target=i686-apple- darwin9 Thread model: posix gcc version 4.0.1 (Apple Inc. build 5490) ** Regards, Dennis
MySQL installation failure
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? First I uncompress with gunzip, then I use pkgadd to install, and I got the following error message: group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/support-files/mysql.server.in failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/support-files/mysql.spec failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/support-files/ndb-config-2-node.ini failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/auto_increment.res failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/auto_increment.tst failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/big_record.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/export.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/fork2_test.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/fork_big.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/function.res failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/function.tst failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/grant.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/grant.res failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/insert_and_repair.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/lock_test.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/lock_test.res failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/mail_to_db.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/myisam-big-rows.tst failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/pmail.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/table_types.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/test_delayed_insert.pl failed group name wheel not found in group table(s) ERROR: attribute verification of /opt/mysql/mysql/tests/udf_test.res failed group name wheel not found in group table(s) ERROR: attribute verification of /usr/include/mysql failed group name wheel not found in group table(s) ERROR: attribute verification of /usr/info failed group name wheel not found in group table(s) ## Executing postinstall script. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /opt/mysql/mysql/bin/mysqladmin -u root password 'new-password' /opt/mysql/mysql/bin/mysqladmin -u root -h zrc2s153 password 'new-password' See the manual for more instructions. 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 Installation of mysql partially failed. Thanks, Hong
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 wheel 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]
MySQL installation problems.
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a question about MySQL installation
Dear, I have installed MySQL4.1. But why it can not startup when I open my computer? Also, how can I test MySQL can run or not? Thanks for your advice. Best Regards, Terry
RE: a question about MySQL installation
Suggest you review the MySQL documentation http://dev.mysql.com/doc/mysql/en/installing.html and in particular 2.3.13. Testing The MySQL Installation and 2.3.14. Troubleshooting a MySQL Installation Under Windows Bob -Original Message- From: Terry Leung [mailto:[EMAIL PROTECTED] Sent: Sunday, May 22, 2005 7:12 AM To: mysql@lists.mysql.com Subject: a question about MySQL installation Dear, I have installed MySQL4.1. But why it can not startup when I open my computer? Also, how can I test MySQL can run or not? Thanks for your advice. Best Regards, Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Trimming down a MySQL installation
I am installing MySQL on a server with limited space available and I'd like to minimize the footprint of the installed database. is there information available on what parts of the installation I can safely delete without harming functionality of the database? I'd love to hear recommendations from the experts out there before I just hack-and-slash through the mysql directory. Thanks in advance, Cris Cris Ewing CME and Telehealth Web Services University of Washington School of Medicine Work Phone: (206) 685-9116 Home Phone: (206) 365-3413 E-mail: [EMAIL PROTECTED] *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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 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]
Mysql installation
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
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]
mysql installation
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 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\binmysqld --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\binmysqld 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 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
MySQL Installation Problem
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. Thanks, Bijay K. Singh (757) 664-6808 Information Technology City of Norfolk, VA. www.norfolk.gov http://www.norfolk.gov/
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 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
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
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 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???
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
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]
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]
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 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/RH89 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
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 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-uspage=byoa/plusST=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 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-uspage=byoa/plusST=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-uspage=dialup/homeST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL installation on HP-UX 10.20
Hi! Can anybody guide me to the link for MySQL on a HP-UX 10.20 system. I have found the binaries for HP-UX 11 and 11.11, but nothing for 10.20. Thanx for the help in advance, Gagneet -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.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-uspage=byoa/plusST=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
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)brusing this manual:http://www.mysql.com/doc/en/Installing_binary.htmlbrHave no idea what's wrong. I looked on the mysql.log file and the file is brempty.brbrERROR MESSAGE:br[EMAIL PROTECTED] bin]# ./mysqlbrERROR 2002: Can't connect to local MySQL server through socket br'/tmp/mysql.sock' (2)br[EMAIL PROTECTED] bin]# ./mysql statusbrERROR 2002: Can't connect to local MySQL server through socket br'/tmp/mysql.sock'brbr_brScope out the new MSN Plus Internet Software optimizes dial-up to the max! br http://join.msn.com/?pgmarket=en-uspage=byoa/plusST=1brbrbr-- brMySQL General Mailing ListbrFor list archives: http://lists.mysql.com/mysqlbrTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]brbr ___ 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]
mySQL Installation!!
Hello List: This is my first post you can easily figure out that I am a complete newbie to mySQL. I have a fresh install of RH9 on a (test) server. It also has mySQL 3.23 installed (part of RH9). My question is: 1) Considering the above setup, do I upgrade (and How?) from 3.23 to 4.0.?? 2) or remove mySQL 3.23 from RH9 installation and re-install mySQL 4.0.?? (tar) I have spent better part of today reading the archives but I still have not gotten any satisfactory answer. Please Help!!! Kirti -- 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]
MySQL installation with SuSE Linux 9.0 and YaST
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]
MySQL installation problem
Hello, I have made a fresh installation of SuSE Linux 9.0. Now I try to install MySQL, but I cannot start mysqld, it always terminates. These are the two installation commands I used after installing with YaST: LPC:~ # mysql_install_db - all tables have been created in /var/lib/mysql/mysql/ including host.frm LPC:~ # mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 031206 15:05:20 mysqld ended 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? What can I do now? 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 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 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]
mysql installation error - version SUNW 1.2 not found
Description: I am trying to install mysql 4.0.16 on Solaris 8 on a i86pc. I created the user and group and everything went fine until I ran scripts/mysql_install_db. When I run the script I come acoss the error ld.so.1: ./bin/mysqld: fatal: librt.so.1: version `SUNW_1.2' not found (required by file ./bin/mysqld) Searching the web I came across a solution to circumvent by setting the LD_VERSION to non-null. But dont know how to set it to non-null. Can you help me with this please? How-To-Repeat: Run the install script Fix: MySQL support: none Synopsis: mysql installation error Severity: none Priority: low Category: mysql Class: install Release: mysql-4.0.16-standard (Official MySQL-standard binary) C compiler:gcc (GCC) 3.2.3 C++ compiler: gcc (GCC) 3.2.3 Environment: machine, os, target, libraries (multiple lines) System: SunOS cbr03_ux 5.7 Generic_106542-15 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/loc al/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.7/2.95.2 /specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXX FLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtt i' LDFLAGS='' ASFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1572352 Mar 24 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Feb 7 2000 /lib/libc.so - ./libc.so. 1 -rwxr-xr-x 1 bin bin 959172 Mar 24 2001 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1572352 Mar 24 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Feb 7 2000 /usr/lib/libc.so - ./libc .so.1 -rwxr-xr-x 1 bin bin 959172 Mar 24 2001 /usr/lib/libc.so.1 Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr /local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-st andard' '--enable-thread-safe-client' '--enable-local-infile' '--disable-shared' '--with-embedded-server' '--with-innodb' 'CC=gcc' 'CFLAGS=-O3 -fno-omit-frame-p ointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptio ns -fno-rtti' 'CXX=gcc' Perl: This is perl, version 5.005_03 built for i86pc-solaris Warm Regards, Manjunath Sangappan Unix Systems Administrator United KFPW p : +61 (2) 6245 5892 f : +61 (2) 6245 6813 e : mailto:[EMAIL PROTECTED] w: www.unitedkfpw.com.au The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL installation and starting problems on LynxOS
Hello, I tried installing MySQL on LynxOS, and it went fine. After installation I started mysqld and but was not able to communicate with it. When I ran mysqladmin it reported the following arjuna# /usr/local/mysql/bin/mysqladmin version /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Lost connection to MySQL server during query' arjuna# /usr/local/mysql/bin/mysqladmin version /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Lost connection to MySQL server during query' Then I tried telnet to 3306 port on which mysqld was listening arjuna# telnet arjuna 3306 Trying 192.168.0.21 ... Connected to arjuna. Escape character is '^]'. , 4.0.15a-log*VQtulA, Bad handshakeConnection closed by foreign host. arjuna# telnet arjuna 3306 Trying 192.168.0.21 ... Connected to arjuna. Escape character is '^]'. , 4.0.15a-logOVB8%N=, Bad handshakeConnection closed by foreign host. Server side log at time were arjuna# tail -f arjuna.err Version: '4.0.15a-log' socket: '/tmp/mysql.sock' port: 3306 Number of processes running now: 0 030930 12:47:06 mysqld restarted /usr/local/mysql/libexec/mysqld: File or directory doesn't exist 030930 12:47:06 mysqld ended 030930 12:47:37 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.0.15a-log' socket: '/tmp/mysql.sock' port: 3306 030930 12:55:28 Error on new connection socket: Socket operation on non-socket 030930 12:55:33 Error on new connection socket: Socket operation on non-socket Could some one help me to resolve this?? Regards Sp.Raja
mysql installation problems (RPM errors)
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 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]
MySQL Installation problem
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
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]
MySQL Installation Challenges
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: moyc To: [EMAIL PROTECTED] Subject: Installation challenges - mysqld Description: I've never installed MySql before and I am having a little trouble with 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? 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) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Chris Moy Organization: organization of PR author (multiple lines) MySQL support: [none] Synopsis: synopsis of the problem (one line) Severity: non-critical Priority: medium Category: mysql Class: support Release: mysql-3.23.54 (Source distribution) Environment: Linux Redhat 9.0 System: Linux bioserver 2.4.20-18.9 #1 Thu May 29 07:08:16 EDT 2003 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux Thread model: posix gcc version 3.2.2 20030222 (Red Hat Linux 3.2.2-5) Compilation info: CC='i386-redhat-linux-gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -g -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='i386-redhat-linux-g++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -g -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 27 07:49 /lib/libc.so.6 - libc-2.3.2.so -rwxr-xr-x1 root root 1549556 Mar 13 19:43 /lib/libc-2.3.2.so -rw-r--r--1 root root 2321376 Mar 13 18:35 /usr/lib/libc.a -rw-r--r--1 root root 204 Mar 13 17:58 /usr/lib/libc.so lrwxrwxrwx1 root root 10 May 27 08:36 /usr/lib/libc-client.a - c-client.a Configure command: ./configure '--host=i386-redhat-linux' '--build=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--without-readline' '--without-debug' '--enable-shared' '--with-extra-charsets=complex' '--with-bench' '--localstatedir=/var/lib/mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-mysqld-user=mysql' '--with-extra-charsets=all' '--with-innodb' '--enable-local-infile' '--enable-large-files=yes' '--enable-largefile=yes' '--with-berkeley-db-includes=/usr/include' '--with-berkeley-db-libs=/usr/lib' '--enable-thread-safe-client' 'CFLAGS=-O2 -march=i386 -mcpu=i686 -g -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' 'CXXFLAGS=-O2 -march=i386 -mcpu=i686 -g -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' 'build_alias=i386-redhat-linux' 'host_alias=i386-redhat-linux' 'target_alias=i386-redhat-linux-gnu' -- 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: I've never installed MySql before and I am having a little trouble with 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 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 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]
mysql installation problem
Hi, I am trying to install myql on redhat. mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz While following the instructions in install document..when i run the follwing command.. scripts/mysql_install_db following errors appear: - scripts/mysql_install_db: ./bin/my_print_defaults: /usr/libexec/ld-elf.so.1: bad ELF interpreter: No such file or directory WARNING: The host 'njsupport.niksun.com' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables scripts/mysql_install_db: ./bin/mysqld: /usr/libexec/ld-elf.so.1: bad ELF interpreter: No such file or directory Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! -- As i am new bie to mysql ..please tell how can i make mysql work. Thanks and Regards Anil. p.s.(Can i get precomplied package (.tgz) to which i can directly pkg_add?). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question about mysql installation
Hi all, Can i install mysql twice on the same comuter? And on the same hard disk? Thanks, Shilry _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - 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: question about mysql installation
Yes, http://www.mysql.com/doc/en/Installing_many_servers.html - Original Message - From: shirly cohen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 11:42 AM Subject: question about mysql installation Hi all, Can i install mysql twice on the same comuter? And on the same hard disk? Thanks, Shilry _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - 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: question about mysql installation
On Thursday 20 February 2003 13:42, shirly cohen wrote: Can i install mysql twice on the same comuter? And on the same hard disk? Yes and Yes: http://www.mysql.com/doc/en/Installing_many_servers.html -- 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 - 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: question about mysql installation
Hi again I looked in the site and in some place they write: you should create an option file for each server. In your startup script that is executed at boot time you should specify for both servers safe_mysqld --defaults-file=path-to-option-file What is the startup script? is it somthing that i need to ceate? Thanks for all the ones who replied me. From: Jerry [EMAIL PROTECTED] Reply-To: Jerry [EMAIL PROTECTED] To: shirly cohen [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: question about mysql installation Date: Thu, 20 Feb 2003 12:05:18 - Yes, http://www.mysql.com/doc/en/Installing_many_servers.html - Original Message - From: shirly cohen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 11:42 AM Subject: question about mysql installation Hi all, Can i install mysql twice on the same comuter? And on the same hard disk? Thanks, Shilry _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - 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 _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Installation Problem
I'm having difficulty installing MySQL 3.23.54 on a Windows 2000 server. I downloaded the file mysql-3.23.54-win.zip. It unzipped and installed smoothly on my Windows 2000 PC, but when I tried to install on the server Setup failed with the Windows message: 'Cannot find file C:\...SETUP.EXE (or one of its components)' etc. I currently have version 3.23.49-nt installed. There were no problems installing it. Can anyone suggest what might be wrong? John R. Porter I.T.Services University of Strathclyde Jordanhill Campus 76 Southbrae Drive Glasgow G13 1PP e-mail: [EMAIL PROTECTED] Tel. 0141 950 3289 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL-Installation on a Windows 2000 Cluster
I must install MySQL on a Windows 2000 Cluster-Server. What´s the best way to do it? How must the my.ini configured so that it works as fail over? Thanks Rainer SQL, Query - 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: Mysqladmin command not installed via rpm mysql installation
slickmik, Thursday, November 21, 2002, 6:58:18 PM, you wrote: saedodedn Description: saedodedn When mysql is installed via linux rpm file, it does not install saedodedn mysqladmin command? saedodedn How-To-Repeat: saedodedn just install mysql from redhat linux rpm. You need to install client RPM package. -- 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 - 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
Mysqladmin command not installed via rpm mysql installation
Description: When mysql is installed via linux rpm file, it does not install mysqladmin command? How-To-Repeat: just install mysql from redhat linux rpm. Fix: ? Submitter-Id: submitter ID Originator:MikeL Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Mysqladmin command not installed via rpm mysql installation Severity: Priority: Category: mysql Class: Release: mysql-3.23.53a (Official MySQL RPM) Environment: System: Linux localhost.localdomain 2.4.18-14 #1 Wed Sep 4 12:13:11 EDT 2002 i686 athlon i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Nov 20 15:30 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x2 root root 1235468 Sep 5 19:12 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 18:50 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Installation
Hi, i am doing a setup program that eventually install mySQL, myODBC, and my system. during my system installation, it require mySQL is installed and already run the WinMySQLAdmin.exe, where by from there i will be able to do some record insertion on the db. but now, since for the first time we run WinMySQLAdmin.exe, it actually require to login, i wonder can i skip this login process, in order for the end-user be more easier while they do the installation. if yes, may i know how to skip the first time WinMySQLAdmin.exe login process ? and besides that, i would like to know, before we running WinMySQLAdmin.exe, the my.ini file still not created yet, therefore, we will not know where's the mySQL installed. May i know how to locate where's the mySQL folder located in this case, so that i can have a shortcut for the end user to click on it and run the WinMySQLAdmin.exe ? /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - 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
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
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
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
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
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
-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 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
mysql installation error... mysql.sock file not found
Hi, I have redhat linux 7.1 server and I have downloaded the binary version of mysql 3.23.52 and I have installed the same version on other servers and it was all fine but on this server I am getting the following error [root@abacusweb mysql]# bin/safe_mysqld [1] 21278 [root@abacusweb mysql]# Starting mysqld daemon with databases from /var/lib/mysq l 020910 19:12:53 mysqld ended and I can not see the file mysql.sock in /varlib/mysql area but it has all the tables etc that are needed. And I followed the README and all the docs and did all the steps one by one.. and also I don't know how to run mysqlbug program?? How can direct mysqlbug program to a file so that I can send that file as an attachment to this mailing list?? Please help me.. seems like I am stuck here... I created mysql user and the group and I changed all the permissions according to the document Thanks Anand _ 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
I need some help in MySql installation ..
From: root To: [EMAIL PROTECTED] Subject: I need some help in MySql installation Description: I tried to install MySQL,version :- MySQL-3.23.52-1 using RPM which I downloaded from mysql website. I copied it in my root directory i.e. [root@FireWall2 /root] My machine name is FireWall2. My OS is Red hat Linux 7.1 with kernel version 2.4.2-2. From that directory I gave commands # rpm -ivh MySQL-3.23.52-1.i386.rpm # rpm -ivh MySQL-client-3.23.52-1.i386.rpm # rpm -ivh MySQL-shared-3.23.52-1.i386.rpm After doing that it showed me installing MySQL on machine. So when I ran following command # rpm -q MySQL I got this MySQL-3.23.52-1 That means mysql is installed successfully. What is the step by step procedure for post Installation configuration of MySql server? I really do not know that...Could you pls. tell me! If I have done anything wrong pls. make me aware of that also. Following are the few commands I gave and also given is the corresponding message displayed on the screen. That could be helpful to you to analyse the case. 1. [root@FireWall2 init.d]# mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) 2. [root@FireWall2 bin]# mysqladmin -u root password 'PASSTHEWORD' mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' 3. [root@FireWall2 bin]# mysqld --skip-grant-tables 020828 16:08:42 Can't start server: Bind on TCP/IP port: Address already in use 020828 16:08:42 Do you already have another mysqld server running on port: 3306 ? 020828 16:08:42 Aborting 020828 16:08:42 mysqld: Shutdown Complete 4. My mysqld daemon is in directory /usr/sbin/ I tried to run it and gave me the following ... [root@FireWall2 sbin]# mysqld 020830 12:05:22 Can't start server: Bind on TCP/IP port: Address already in use 020830 12:05:22 Do you already have another mysqld server running on port: 3306 ? 020830 12:05:22 Aborting 020830 12:05:22 mysqld: Shutdown Complete Kindly let me know where I am going wrong. Thanks a lot.. Originator:root Organization: CSS Ltd. Category: mysql sachin s. __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.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: I need some help in MySql installation ..
sachin, Friday, August 30, 2002, 10:30:47 AM, you wrote: ss Description: [skip] ss I got this ss MySQL-3.23.52-1 ss That means mysql is installed successfully. ss What is the step by step procedure for post ss Installation configuration of MySql server? Check chapter 2.4 Post-installation Setup and Testing: http://www.mysql.com/doc/en/Post-installation.html ss I really do not know that...Could you pls. tell me! ss If I have done anything wrong pls. make me aware of ss that also. ss Following are the few commands I gave and also given ss is the corresponding message displayed on the screen. ss That could be helpful to you to analyse the case. ss 1. ss [root@FireWall2 init.d]# mysql ss ERROR 1045: Access denied for user: 'root@localhost' ss (Using password: NO) ss 2. ss [root@FireWall2 bin]# mysqladmin -u root password ss 'PASSTHEWORD' ss mysqladmin: connect to server at 'localhost' failed ss error: 'Access denied for user: 'root@localhost' ss (Using password: NO)' Did you have installed MySQL server before? ss 3. ss [root@FireWall2 bin]# mysqld --skip-grant-tables ss 020828 16:08:42 Can't start server: Bind on TCP/IP ss port: Address already in use ss 020828 16:08:42 Do you already have another mysqld ss server running on port: 3306 ? ss 020828 16:08:42 Aborting ss 020828 16:08:42 mysqld: Shutdown Complete ss 4. ss My mysqld daemon is in directory /usr/sbin/ ss I tried to run it and gave me the following ... ss [root@FireWall2 sbin]# mysqld ss 020830 12:05:22 Can't start server: Bind on TCP/IP ss port: Address already in use ss 020830 12:05:22 Do you already have another mysqld ss server running on port: 3306 ? ss 020830 12:05:22 Aborting ss 020830 12:05:22 mysqld: Shutdown Complete CHECK if MySQL server is already running with ps ax | grep mysqld If so, take down mySQL server and then start mysqld with --skip-grant-tables option -- 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
MySQL installation problem
Hi guys, I am trying to install MySql on Linux (Mandrake 8). And everytime when I try to start the server. like this [mysql@127 support-files]# ./mysql.server start I get the message like: ./mysql.server: @hostname@ command not found ./mysql.server: my_print_defaults command not found [mysql@127 support-files]# Starting mysqld daemon with database from /usr/local/mysql/data 020709 09:07:03 mysqld ended Anybody can give me a hint? I really appreciate it! Tang --- Tang, Lianhong Vanderbilt University Email: [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: Newbie MySQL installation problems (specific)
Have you tried .../bin/safe_mysqld start to start the DB first? This is what will create /tmp/mysql.sock socket file start the DB server. Then you can use the 'mysql' client for connecting to the DB. Also, if you don't want to use transactional database, meaning, if you don't want support for rollback and stuff, which I am guessing you might not, then you can download the 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc Liyanage's site). Since it's giving errors regarding innodb, my guess is that the server is configured to create inno db tables and not myisam tables, which is what the default binaries/rpm are configured to do (i.e. create myisam tables, but they are non-transactional). Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 3:55 PM Subject: Newbie MySQL installation problems (specific) Buying Paul DuBois' most excellent book MySQL has made me more comfortable with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the web database for a redesigneed site at Right Moves For Youth (trying to keep at risk kids in school). After running his cleanup instructions and then downloading and installing the mysql package from Marc Liyanage's site, I tried to run the following command (as per instructions): sudo ./scripts/mysql_install_db; I then get the following results: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 020609 0:35:05 ./bin/mysqld: Shutdown Complete When I try to start mysql from the command line, I then get the ubiquitous error message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I also discovered a localhost.err file in my data directory which yields the following information: 020609 01:09:50 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 01:09:52 mysqld ended Finally, when I try the following: mysqladmin -u root status I also get the can't connect through /tmp/myssql.sock error message. No matter what I try, I can't seem to connect to mysql so that I can even BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how to what the ERROR: 1062 message means and how to resolve this mess? I've searched the archives, and this error appears to have occurred occasionally, but being a newbie to MySQL, I can't understand the solutions to the problem. Usually this problem has occurred AFTER someone has been able to successfully connect to mysql. Oh Woe is me, Colin - 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: Newbie MySQL installation problems (specific)
Thanks Bhavin, I tried your suggestion (safe_mysqld start) and get a lot of Permission denied errors. So, I su to root and try it, and it appears that it does start (Starting mysqld daemon with databases from /usr/local/mysql/data). However, when I try to connect, either as root (which I understand is not a good idea) or under my normal login, I get the same error, i.e., that the socket can't be found. Very puzzling and I'm quickly approaching the point of concluding that the amount of time trying to troubleshoot this mess not warranting the potential benefits. Colin Have you tried .../bin/safe_mysqld start to start the DB first? This is what will create /tmp/mysql.sock socket file start the DB server. Then you can use the 'mysql' client for connecting to the DB. Also, if you don't want to use transactional database, meaning, if you don't want support for rollback and stuff, which I am guessing you might not, then you can download the 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc Liyanage's site). Since it's giving errors regarding innodb, my guess is that the server is configured to create inno db tables and not myisam tables, which is what the default binaries/rpm are configured to do (i.e. create myisam tables, but they are non-transactional). Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 3:55 PM Subject: Newbie MySQL installation problems (specific) Buying Paul DuBois' most excellent book MySQL has made me more comfortable with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the web database for a redesigneed site at Right Moves For Youth (trying to keep at risk kids in school). After running his cleanup instructions and then downloading and installing the mysql package from Marc Liyanage's site, I tried to run the following command (as per instructions): sudo ./scripts/mysql_install_db; I then get the following results: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 020609 0:35:05 ./bin/mysqld: Shutdown Complete When I try to start mysql from the command line, I then get the ubiquitous error message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I also discovered a localhost.err file in my data directory which yields the following information: 020609 01:09:50 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 01:09:52 mysqld ended Finally, when I try the following: mysqladmin -u root status I also get the can't connect through /tmp/myssql.sock error message. No matter what I try, I can't seem to connect to mysql so that I can even BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how to what the ERROR: 1062 message means and how to resolve this mess? I've searched the archives, and this error appears to have occurred occasionally, but being a newbie to MySQL, I can't understand the solutions to the problem. Usually this problem has occurred AFTER someone has been able to successfully connect to mysql. Oh Woe is me, Colin - 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: Newbie MySQL installation problems (specific)
Ah...give up not for we have been using mysql for quite a long time and it is pretty stable. Try this... instead of trouble shooting this install and getting it work... go to www.mysql.com, download an rpm if you are on Red hat linux (or Mandrake) and do an rpm -i mysql...rpm and rpm -i mysq..client..rpm (this file is for insalling the client). If not, just download the binary and follow the instructions. We haven't had any trouble at all installing mysql and this might be a system specific problem. Let me know how it works out. Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 6:42 PM Subject: Re: Newbie MySQL installation problems (specific) Thanks Bhavin, I tried your suggestion (safe_mysqld start) and get a lot of Permission denied errors. So, I su to root and try it, and it appears that it does start (Starting mysqld daemon with databases from /usr/local/mysql/data). However, when I try to connect, either as root (which I understand is not a good idea) or under my normal login, I get the same error, i.e., that the socket can't be found. Very puzzling and I'm quickly approaching the point of concluding that the amount of time trying to troubleshoot this mess not warranting the potential benefits. Colin Have you tried .../bin/safe_mysqld start to start the DB first? This is what will create /tmp/mysql.sock socket file start the DB server. Then you can use the 'mysql' client for connecting to the DB. Also, if you don't want to use transactional database, meaning, if you don't want support for rollback and stuff, which I am guessing you might not, then you can download the 3.23.49 binary or rpm (not max) from the mysql.com site (instead of Marc Liyanage's site). Since it's giving errors regarding innodb, my guess is that the server is configured to create inno db tables and not myisam tables, which is what the default binaries/rpm are configured to do (i.e. create myisam tables, but they are non-transactional). Regards, Bhavin. - Original Message - From: Colin Cooler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 3:55 PM Subject: Newbie MySQL installation problems (specific) Buying Paul DuBois' most excellent book MySQL has made me more comfortable with Mysql and Unix, so I thought I would try to use Mysql/PHP combo as the web database for a redesigneed site at Right Moves For Youth (trying to keep at risk kids in school). After running his cleanup instructions and then downloading and installing the mysql package from Marc Liyanage's site, I tried to run the following command (as per instructions): sudo ./scripts/mysql_install_db; I then get the following results: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 020609 0:35:05 ./bin/mysqld: Shutdown Complete When I try to start mysql from the command line, I then get the ubiquitous error message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I also discovered a localhost.err file in my data directory which yields the following information: 020609 01:09:50 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020609 1:09:51 /usr/local/mysql-3.23.49/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.49/data/localhost.pid' (Errcode: 13) 020609 01:09:52 mysqld ended Finally, when I try the following: mysqladmin -u root status I also get the can't connect through /tmp/myssql.sock error message. No matter what I try, I can't seem to connect to mysql so that I can even BEGIN to figure out how to correct the 1062 problem! Can anyone tell me how to what the ERROR: 1062 message means and how to resolve this mess? I've searched the archives, and this error appears to have occurred occasionally, but being a newbie to MySQL, I can't understand the solutions to the problem. Usually this problem has occurred AFTER someone has been able
Re: php+apache+mysql installation. Help
Do I need to uninstall the old Apache before installing the newer version? How do I uninstall the old Apache in linux? Do I just use the package manager to remove the package? What does make do? I don't know how linux work. Please advise. Thanks. From: Andrew Lietzow [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: php+apache+mysql installation. Help! Date: Thu, 23 May 2002 21:34:37 -0500 Dear Andy, Here's a thought. Before you go much further, install Apache 2.0.36. It's easy to install and lots of improvements will be gained that you'll appreciate down the road, i.e. mod_ssl is preconfigured into the system. Andrew Lietzow The ACL Group, Inc. On Thursday 23 May 2002 06:33 pm, you wrote: Hi, I am new to linux and trying to install Apache, php and mysql on my Redhat 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: checking whether build environment is sane..configure error:newly created file is older than distributed files! I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my box. Would appreciated if some one could advise how to install PHP. Thanks P.S. I have start Mysql manually. How do I make it auto start and shutdown? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Andrew Lietzow The ACL Group, Inc. 515-274-0300 v/f 515-710-1955 c _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
php+apache+mysql installation. Help!
Hi, I am new to linux and trying to install Apache, php and mysql on my Redhat 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: checking whether build environment is sane..configure error:newly created file is older than distributed files! I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my box. Would appreciated if some one could advise how to install PHP. Thanks P.S. I have start Mysql manually. How do I make it auto start and shutdown? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: php+apache+mysql installation. Help!
Dear Andy, Here's a thought. Before you go much further, install Apache 2.0.36. It's easy to install and lots of improvements will be gained that you'll appreciate down the road, i.e. mod_ssl is preconfigured into the system. Andrew Lietzow The ACL Group, Inc. On Thursday 23 May 2002 06:33 pm, you wrote: Hi, I am new to linux and trying to install Apache, php and mysql on my Redhat 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: checking whether build environment is sane..configure error:newly created file is older than distributed files! I have Apache 1.3.20 (from RH 7.2) and Mysql 3.23.49a installed on my box. Would appreciated if some one could advise how to install PHP. Thanks P.S. I have start Mysql manually. How do I make it auto start and shutdown? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Andrew Lietzow The ACL Group, Inc. 515-274-0300 v/f 515-710-1955 c - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Installation Problem
Hello, I downloaded all the following files to load MYSQL software. mysql-4.0.0a-alpha-win-src.zip mysql-4.0.0a-alpha-win.zip mysql-4.0.1a-alpha-win-src.zip mysql-4.0.1a-alpha-win.zip I installed mysql after unzipping the above two versions of .zip files. After installation it is not coming to the programs but it is installing all the files. What i have to do to show the shortcut in programs and to use mysql database so plese send me all the required files or URLS which will give me correct information to solve my problem Thanks _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Installation Problem
Hello, I downloaded all the following files to load MYSQL software. mysql-4.0.0a-alpha-win-src.zip mysql-4.0.0a-alpha-win.zip mysql-4.0.1a-alpha-win-src.zip mysql-4.0.1a-alpha-win.zip I installed mysql after unzipping the above two versions of .zip files. After installation it is not coming to the programs but it is installing all the files. What i have to do to show the shortcut in programs and to use mysql database so plese send me all the required files or URLS which will give me correct information to solve my problem Thanks _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs - 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
Help with mysql installation
Hello, I am trying to install mysql from RPMs. My installation guide requires: -Mysql server -Mysql shared -Mysql client However those files are not present on mysql's website. Where do I find them?? Is the file available at Mysql.com sufficient for a server + client installation? Thanks in advance, Balteo. - 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: Help with mysql installation
Hello, I am trying to install mysql from RPMs. My installation guide requires: -Mysql server -Mysql shared -Mysql client However those files are not present on mysql's website. Where do I find them?? Where do you want to install .. on 1) Unix like OS or 2) windows or 3) any other? For 1 goto http://www.mysql.com/downloads/mysql-3.23.html and all RPM's are present under heading Linux Downloads For 2 server/client programs are all present in the .zip file on SAME site (under Windows Downloads) Is the file available at Mysql.com sufficient for a server + client installation? Thanks in advance, Balteo. - 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: Help with mysql installation
Should be able to find the right rpm's from your Linux distribution's website. Just a guess here but www.redhat.com. Mike sqp,mysql Balteo wrote: Hello, I am trying to install mysql from RPMs. My installation guide requires: -Mysql server -Mysql shared -Mysql client However those files are not present on mysql's website. Where do I find them?? Is the file available at Mysql.com sufficient for a server + client installation? Thanks in advance, Balteo. - 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 -- 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
MySql installation - DB dies
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
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 - 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 host_name.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 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 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
Help for MYSQL installation
Dear Sir/Madam, I downloaded the latest mysql-3.23.49 and wanted to install MYSQL in my FreeBSD 2.2.7 OS. The configuration (./configure) and Make both went smoothly, but it failed when I installed (make install) and here is the error message: -- mv -f .libs/get_password.lo get_password.lo /bin/sh ../libtool --mode=compile gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -c errmsg.c rm -f .libs/errmsg.lo gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c errmsg.c -fPIC -DPIC -o .libs/errmsg.lo gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c errmsg.c -o errmsg.o /dev/null 21 mv -f .libs/errmsg.lo errmsg.lo make: don't know how to make my_init.c. Stop *** Error code 1 Please help. Chip Thanks! __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.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
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
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
Mysql installation error
Hello, All: We have encountered the problem to install Mysql-3.23.49 version on Linux Redhat 7.1. 1. Run rpm with Mysql-3.23.49a-1.i386.rpm, the installation failed. 2. Gunzip mysql-3.23.49.tar.gz, we got the error: invalid compressed data--format violated. Can anyone offer some assistance on what's happening here? Thanks, Jane Tsai [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