>Description:
Configuration, compilation, and 'make install' all worked perfectly, but when I
moved on to the next step, things start to break. The command in question is:
'scripts/mysql_install_db'
Here is the output:
bash-2.02$ scripts/mysql_install_db
Creating db table
Creating host table
Creating user table
Creating func table
Creating tables_priv table
Creating columns_priv table
ERROR: 1064 You have an error in your SQL syntax near ';' at line 1
Installation of grant tables failed!
Examine the logs in /production/mysql/var for more information.
You can also try to start the mysqld demon with:
/production/mysql/libexec/mysqld --skip-grant &
You can use the command line tool
/production/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /production/mysql/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /production/mysql/var 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 /production/mysql/bin/mysqlbug script!
bash-2.02$
I have tried to do the same tasks as mysql_install_db does manually, but to no avail. The
same
thing happens. In fact, I tried to run this command: 'create table bar ( foo int)', and
it
failed with the same error.
(Oh, if you do respond, please make sure that 'jesse@stripped' is on the 'to:' list.
Thanks!)
>How-To-Repeat:
Run this command: 'scripts/mysql_install_db' from the base of the source tree.
>Fix:
<none>
>Submitter-Id:
>Originator: Jesse Becker
>Organization:
Kesmai Corp.
>MySQL support: none
>Synopsis: mysql_install_db fails on HPUX 10.20
>Severity: critical
>Priority: medium
>Category: mysql
>Class: support
>Release: mysql-3.22.22 (Source distribution)
>Environment:
System: HP-UX dogbert B.10.20 A 9000/735 2007463840 two-user license
Some paths: /usr/bin/perl /usr/gnupro/bin/make /usr/gnupro/bin/gmake /usr/gnupro/bin/gcc
/usr/bin/cc
GCC: Reading specs from
/usr/gnupro/bin/../lib/gcc-lib/hppa1.1-hp-hpux10.20/2.9-gnupro-98r2/specs
gcc version 2.9-gnupro-98r2
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --with-low-memory --prefix=/production/mysql
--with-mit-threads --without-debug --with-tcp-port=4444 --with-mysql-user=aries
Perl: This is perl, version 5.005_02 built for PA-RISC1.1