List:General Discussion« Previous MessageNext Message »
From:Jesse Becker Date:June 9 1999 10:10pm
Subject:mysql_install_db fails on initial SQL statements
View as plain text  
>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
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