Description:
MySQL installation reports error while installing on Solaris 8 with latest patches (SunOS 5.8 Generic_117000-03).
We get following error
-------------------------------------------------------
$ cd mysql
$ scripts/mysql_install_db
./bin/my_print_defaults: ^B^E^H: not found
./bin/my_print_defaults: ^L^P^R^S^V^W^[^]^^!: is not
an identifier
./bin/my_print_defaults:
^?ELF^B^B^A^B+^A^AHX@^Bd\220@8^E@^Y^X^F^E@^A@^A^X^A^X^C^D^AX^Y^A^E^A^AI^M^AI^M^P^A^G^AI^P^A^QI^P^A^PØ^AcÀ^P^B^G^ARè^A^QRè^Aà/usr/lib/sparcv9/ld.so.1^Aa^Ab^A^C^D^F^G:
not found
./bin/my_print_defaults: syntax error at line 14: `^'
unexpected
WARNING: The host 'XXXX' 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 daemon,
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: Failed to make directory "data/mysql";
Permission denied
chmod: WARNING: can't access ./data/mysql
mkdir: Failed to make directory "data/test";
Permission denied
chmod: WARNING: can't access ./data/test
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
./bin/mysqld: syntax error at line 1: `)' unexpected
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!
How to repeat:
The latest Solaris 8 patch cluster can be found at http://sunsolve.sun.com/pub-cgi/retrieve.pl?doctype=patch&doc=8_Recommended.README
Install latest patched and try installing MySQL 4.0 Solaris build available at http://www.mysql.com/get/Downloads/MySQL-4.0/mysql-standard-4.0.18-sun-solaris2.8-sparc.tar.gz/from/pick
Suggested fix:
Please make available MySQL binary compiled using latest libc version.
It looks like patch 108993 (http://sunsolve.sun.com/pub-cgi/findPatch.pl?patchId=108993&rev=33) has new libc.