>>>>> "Jesse" == Jesse Becker <jesse@stripped> writes:
>> Description:
Jesse> Configuration, compilation, and 'make install' all worked perfectly, but when I
Jesse> moved on to the next step, things start to break. The command in question is:
Jesse> 'scripts/mysql_install_db'
Jesse> Here is the output:
Jesse> bash-2.02$ scripts/mysql_install_db
Jesse> Creating db table
Jesse> Creating host table
Jesse> Creating user table
Jesse> Creating func table
Jesse> Creating tables_priv table
Jesse> Creating columns_priv table
Jesse> ERROR: 1064 You have an error in your SQL syntax near ';' at line 1
Jesse> Installation of grant tables failed!
<cut>
Jesse> Some paths: /usr/bin/perl /usr/gnupro/bin/make /usr/gnupro/bin/gmake
> /usr/gnupro/bin/gcc /usr/bin/cc
Jesse> GCC: Reading specs from
> /usr/gnupro/bin/../lib/gcc-lib/hppa1.1-hp-hpux10.20/2.9-gnupro-98r2/specs
Jesse> gcc version 2.9-gnupro-98r2
Jesse> Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
Jesse> Configure command: ./configure --with-low-memory --prefix=/production/mysql
> --with-mit-threads --without-debug --with-tcp-port=4444 --with-mysql-user=aries
Jesse> Perl: This is perl, version 5.005_02 built for PA-RISC1.1
Hi!
My guess is that it's some kind of optimization problem with gcc
(I compiled earlier today a HPUX version with gcc 2.8.1 and this worked)
Can you try the following configure line:
make clean
CFLAGS=-O2 CXX=gcc CXXFLAGS=-02 Configure command: ./configure --with-low-memory
--prefix=/production/mysql --with-mit-threads --with-debug --with-tcp-port=4444
--with-mysql-user=aries
If this works, then you can recompile once more with --without-debug.
Regards,
Monty
