List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:June 9 1999 11:06pm
Subject:mysql_install_db fails on initial SQL statements
View as plain text  
>>>>> "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
Thread
mysql_install_db fails on initial SQL statementsJesse Becker10 Jun
  • mysql_install_db fails on initial SQL statementsMichael Widenius10 Jun
    • Re: mysql_install_db fails on initial SQL statementsJesse Becker23 Jun
      • Re: mysql_install_db fails on initial SQL statementsSasha Pachev23 Jun
        • Re: mysql_install_db fails on initial SQL statementsJesse Becker23 Jun
      • Re: mysql_install_db fails on initial SQL statements(Paul D. Smith)23 Jun
      • Re: mysql_install_db fails on initial SQL statementsSasha Pachev24 Jun
      • Re: mysql_install_db fails on initial SQL statements(Paul D. Smith)24 Jun
      • Intel+BSD/Linux vs the Big GuysSasha Pachev24 Jun
        • Re: Intel+BSD/Linux vs the Big GuysPatrick Greenwell24 Jun
          • Re: Intel+BSD/Linux vs the Big GuysSasha Pachev24 Jun
            • Re: Intel+BSD/Linux vs the Big GuysPatrick Greenwell24 Jun
          • Re: Intel+BSD/Linux vs the Big Guysathompso24 Jun
        • Re: Intel+BSD/Linux vs the Big GuysUnknown Sender24 Jun
RE: Intel+BSD/Linux vs the Big GuysJohn Foley24 Jun
  • concerns running MySQL on FreeBSD ?chas29 Jun
    • Re: concerns running MySQL on FreeBSD ?Suresh Rajagopalan29 Jun
      • Re: concerns running MySQL on FreeBSD ?Jon Drukman29 Jun
        • Re: concerns running MySQL on FreeBSD ?Suresh Rajagopalan29 Jun
      • Re: concerns running MySQL on FreeBSD ?Scott Hess29 Jun
      • Re: concerns running MySQL on FreeBSD ?Vivek Khera29 Jun
    • RE: concerns running MySQL on FreeBSD ?Kelly Yancey29 Jun
      • Re: concerns running MySQL on FreeBSD ?Karl Pielorz1 Jul
        • Re: concerns running MySQL on FreeBSD ?Don Read1 Jul
          • Re: concerns running MySQL on FreeBSD ?chas7 Jul
Re: Intel+BSD/Linux vs the Big GuysFred Lindberg24 Jun
Re: Intel+BSD/Linux vs the Big GuysDerick H Siddoway24 Jun
Re: Intel+BSD/Linux vs the Big GuysKevin Ying25 Jun
Re: Intel+BSD/Linux vs the Big GuysDerick H Siddoway28 Jun
Re: concerns running MySQL on FreeBSD ?Nazar7 Jul