RE: What mysql 5.0 binary relase use for CentOS 4.4 Pentium?
Finally I have an erroneous /etc/hosts file. But aside from that what of the realeses is best suited for a CentOS 4.4 Double Pentium III 1.0 Ghz? * Linux (x86, glibc-2.2, standard is static, gcc): mysql-standard-5.0.24a-linux-i686.tar.gz * Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz The first is compiled statically with glibc-2.2 and the second is compiled dinamically against glibc-2.3. CentOS 4.4 uses glibc-2.3. Then which is the best suited? For update is more easier using rpm relases but If I want to downgrade to the previous version I only have to change the symbolic link mysql in /usr/local/mysql to the directory of the previous version if I use binary instead of rpm releases. That works because I use another director for data thant /usr/local/mysql/data. Could I do these with rpm? -Mensaje original- De: Chris [mailto:[EMAIL PROTECTED] Enviado el: viernes, 22 de septiembre de 2006 2:19 Para: [EMAIL PROTECTED] CC: MySql Mail List Asunto: Re: What mysql 5.0 binary relase use for CentOS 4.4 Pentium? [EMAIL PROTECTED] wrote: Hi. What binary relase use for CentOS 4.4: * Linux (x86, glibc-2.2, standard is static, gcc): mysql-standard-5.0.24a-linux-i686.tar.gz * Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz In http://dev.mysql.com/doc/refman/5.0/en/binary-notes-linux.html says that it is possible that mysql couldn't resolves ips for hostnames. First I install mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz and executing mysql_install_db it says: Sorry, the host '' could not be looked up If you read that page: You can deal with this by executing mysql_install_db --force, which does not execute the resolveip test in mysql_install_db. The downside is that you cannot use hostnames in the grant tables: except for localhost, you must use IP numbers instead. If you are using an old version of MySQL that does not support --force, you must manually remove the resolveip test in mysql_install using a text editor. Basically your DNS is stuffed and mysql can't look up hostnames. Why aren't you using the rpms? They are much easier to deal with when it comes time to upgrade. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What mysql 5.0 binary relase use for CentOS 4.4 Pentium?
[EMAIL PROTECTED] wrote: Hi. What binary relase use for CentOS 4.4: * Linux (x86, glibc-2.2, standard is static, gcc): mysql-standard-5.0.24a-linux-i686.tar.gz * Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz In http://dev.mysql.com/doc/refman/5.0/en/binary-notes-linux.html says that it is possible that mysql couldn't resolves ips for hostnames. First I install mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz and executing mysql_install_db it says: Sorry, the host '' could not be looked up If you read that page: You can deal with this by executing mysql_install_db --force, which does not execute the resolveip test in mysql_install_db. The downside is that you cannot use hostnames in the grant tables: except for localhost, you must use IP numbers instead. If you are using an old version of MySQL that does not support --force, you must manually remove the resolveip test in mysql_install using a text editor. Basically your DNS is stuffed and mysql can't look up hostnames. Why aren't you using the rpms? They are much easier to deal with when it comes time to upgrade. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What mysql 5.0 binary relase use for CentOS 4.4 Pentium?
Hi, If you get Sorry, the host '' could not be looked up error message when you run mysql_install_db, or if you get the getpwnam: No such file or directory error message while running mysqld with --user option, Then try any of these solutions: a.. Get a MySQL source distribution either an RPM or the tar.gz distribution and install this instead. b.. Execute mysql_install_db --force; This will not execute the resolveip test in mysql_install_db. The downside is that you can't use host names in the grant tables; you must use IP numbers instead of host names except for localhost. If you are using an old MySQL release that doesn't support --force, you have to remove the resolveip test in mysql_install with an editor. c.. Start mysqld with su instead of using --user. Thanks ViSolve DB Team. - Original Message - From: [EMAIL PROTECTED] To: MySql Mail List mysql@lists.mysql.com Sent: Thursday, September 21, 2006 9:27 PM Subject: What mysql 5.0 binary relase use for CentOS 4.4 Pentium? Hi. What binary relase use for CentOS 4.4: * Linux (x86, glibc-2.2, standard is static, gcc): mysql-standard-5.0.24a-linux-i686.tar.gz * Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz In http://dev.mysql.com/doc/refman/5.0/en/binary-notes-linux.html says that it is possible that mysql couldn't resolves ips for hostnames. First I install mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz and executing mysql_install_db it says: Sorry, the host '' could not be looked up Then I install mysql-standard-5.0.24a-linux-i686.tar.gz and says the same when I execute mysql_install_db. Sorry, the host '' could not be looked up Aside from not could use hostnames what from these releases is best for me? Iago.