UNIX for Dummies Questions & Answers

i am a newbie to unix admin stuff so bare with me. -- i get this message when executing mysql_install_db during the installation of mysql. what is the cause of this and how can it be fixed. btw - i have tried installing as root and other accounts also.


scripts/mysql_install_db: ./bin/my_print_defaults: cannot execute binary file
WARNING: The host 'localhost.localdomain' 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 !
mkdir: cannot create directory `./data/mysql': Permission denied
chmod: getting attributes of `./data/mysql': Permission denied
mkdir: cannot create directory `./data/test': Permission denied
chmod: getting attributes of `./data/test': Permission denied
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: cannot execute binary file
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!

First you need to fix your "localhost.localdomain" problem. Put your real hostname in /etc/hostname and a proper entry in /etc/hosts and then reboot.

Next, make sure you are trying the install as root -- that should fix any "permission denied" errors you are seeing.

Finally, RedHat provides a mysql rpm package which would make the install much easier. Recommend installing that rather than trying to do it manually.

thanks, there are several mysql rpm's, which ones should I install?

I know this one
MySQL 3.23.44 Server

But what about these?
MySQL 3.23.44 Benchmark/test suites
MySQL 3.23.44 Client programs
MySQL 3.23.44 Libraries and Header files for development
MySQL 3.23.44 Client shared libraries

You almost certainly need the "Client Programs" and "Client Shared Libraries". You only need the "Benchmark" if you want to benchmark MySQL, and you only need the "Libraries and Header Files" if you want to write C/C++ programs which interface directly with your database. (i.e. if you are using a pre-built interface such as Perl, PHP, etc) you wont need this one.

thanks again --- another problem

installing the 'client programs' rpm using the following command line: rpm -ivv MySQL-client-3.23.44-1.i386.rpm, I get the following error, thus it does not install correctly.

error: unpacking of archive failed on file /usr/bin/mysql;3bf412e3: cpio: MD5 sum mismatch

I get the same type of error when installing the 'Client Shared Libraries' rpm. Can I get some more help? Thanks.

i think i might know what the problem is. i downloaded those two rpm's on a windows machine, and then ftp'd them to a linux box, then secured copied them to the machine that i tried to install them on. unlike the server rpm, which i downloaded directly.

I got the following warning when I wanted to see what the rpm would install: rpm -qpl MySQL-client-3.23.44-1.i386.rpm

warning: Expected size: 1773110 = lead(96)+sigs(68)+pad(4)+data(1772942)
warning: Actual size: 1773090

All that transferring must have mess with the size of the rpm or something (like I said I'm new to this). So I will download directly to the machine when I get home and then try it again. Thanks.

it worked - great


thanks again