List:General Discussion« Previous MessageNext Message »
From:gburditt Date:May 12 2000 2:27am
Subject:mysql_install_db fails to install grant tables
View as plain text  
	Run mysql_install_db with no existing databases.
	Output is:

Creating db table
Creating host table
Creating user table
Creating func table
Creating tables_priv table
Creating columns_priv table
Please read "Security" section of the manual to find out how to run mysqld as root!
000511 19:59:12  Aborting

Installation of grant tables failed!

Examine the logs in /var/db/mysql for more information.
You can also try to start the mysqld demon with:
/usr/local/libexec/mysqld --skip-grant &
You can use the command line tool
/usr/local/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/local/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/db/mysql that may be helpful.

The latest information about MySQL is available on the web at
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 /usr/local/bin/mysqlbug script!
	Install mysql 3.23.15 (even though the grant table creation fails).
	Remove or rename /var/db/mysql to start fresh.
	As root, run mysql_install_db
	In line 245 of mysql_install_db (where mysqld is invoked), 
	add the option --user=root .  (At this point, the installation
	has created the databases owned by root, so it has to be root.)

	I suspect that --user=root (or some other user) is also required 
	on several of the command lines suggested in mysql_install_db 
	or various other scripts.

	Note that the configure option --with-mysql-user=mysql doesn't help.

>Submitter-Id:	<submitter ID>
>Originator:	Gordon Burditt
>MySQL support: none [none | licence | email support | extended email support ]
>Synopsis:	mysql_install_db fails to install grant tables 
>Severity:	serious 
>Priority:	medium 
>Category:	mysql
>Class:		sw-bug 
>Release:	mysql-3.23.15-alpha (Source distribution)

System: FreeBSD 4.0-RELEASE FreeBSD 4.0-RELEASE #0: Thu Apr 20 15:34:59
CDT 2000     gordon@stripped:/usr/src/sys/compile/HAMMY  i386

Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='cc'  CFLAGS='-O -pipe'  CXX='c++'  CXXFLAGS='-O -pipe'  LDFLAGS=''
-r--r--r--  1 root  wheel  1128450 Apr 11 03:51 /usr/lib/libc.a
lrwxrwxr-x  1 root  wheel  9 Apr 11 03:51 /usr/lib/ ->
-r--r--r--  1 root  wheel  517727 Nov 19 22:28 /usr/lib/
-r--r--r--  1 root  wheel  531444 Apr 11 03:51 /usr/lib/
Configure command: ./configure  --localstatedir=/var/db/mysql --without-perl
--without-debug --without-readline --without-bench --with-mit-threads=no
--prefix=/usr/local i386--freebsd4.0
Perl: This is perl, version 5.005_03 built for i386-freebsd
mysql_install_db fails to install grant tablesgburditt12 May
  • mysql_install_db fails to install grant tablesMichael Widenius13 May