I start from an up-to-date fedora core 4 (except that I've not
rebooted lately, so I have newer kernels than I'm now running).
This includes
mysql-4.1.16-1.FC4.1.i386.rpm
mysql-devel-4.1.16-1.FC4.1.i386.rpm
mysql-server-4.1.16-1.FC4.1.i386.rpm
mysqlclient10-3.23.58-6.i386.rpm
I'm trying to follow directions in
http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
Transcript:
# su mysql
bash-3.00$ cd /var/lib
bash-3.00$ mysql_install_db
Installing all prepared tables
Fill help tables
ERROR: 1064 You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 1
060514 21:39:56 [ERROR] Aborting
060514 21:39:56 [Note] /usr/libexec/mysqld: Shutdown complete
WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
The HELP command might not work properly
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h don-eve.dyndns.org password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
bash-3.00$
What's the error in syntax?
I'm now simply following the directions above that say to use mysqlbug
and tell you what I did.
I can't tell for sure,but it looks like I'm supposed to just mail this buffer.
That's another problem. I seem to be in emacs (not the right one) and not
in a mail buffer ... I'll try to mail it anyway...
Description:
precise description of the problem (multiple lines)
How-To-Repeat:
code/input/activities to reproduce the problem (multiple lines)
Fix:
how to correct or work around the problem, if known (multiple lines)
Submitter-Id: submitter ID
Originator:root
Organization:
organization of PR author (multiple lines)
MySQL support: [none | licence | email support | extended email support ]
Synopsis: synopsis of the problem (one line)
Severity: [ non-critical | serious | critical ] (one line)
Priority: [ low | medium | high ] (one line)
Category: mysql
Class: [ sw-bug | doc-bug | change-request | support ] (one line)
Release: mysql-4.1.16 (Source distribution)
C compiler:i386-redhat-linux-gcc (GCC) 4.0.2 20051125 (Red Hat 4.0.2-8)
C++ compiler: i386-redhat-linux-g++ (GCC) 4.0.2 20051125 (Red Hat 4.0.2-8)
Environment:
machine, os, target, libraries (multiple lines)
System: Linux don-eve.dyndns.org 2.6.15-1.1831_FC4 #1 Tue Feb 7 13:37:42 EST
2006 i686 i686 i386 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using built-in specs.
Target: i386-redhat-linux
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--enable-checking=release --with-system-zlib --enable-__cxa_atexit
--disable-libunwind-exceptions --enable-libgcj-multifile
--enable-languages=c,c++,objc,java,f95,ada --enable-java-awt=gtk
--with-java-home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre
--host=i386-redhat-linux
Thread model: posix
gcc version 4.0.2 20051125 (Red Hat 4.0.2-8)
Compilation info: CC='i386-redhat-linux-gcc' CFLAGS='-O2 -g -pipe
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4
-fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64
-D_LARGEFILE_SOURCE -fno-strict-aliasing' CXX='i386-redhat-linux-g++'
CXXFLAGS='-O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386
-mtune=pentium4 -fasynchronous-unwind-tables -D_GNU_SOURCE
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fno-rtti
-fno-exceptions' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Mar 28 06:49 /lib/libc.so.6 - libc-2.3.6.so
-rwxr-xr-x 1 root root 1481808 Mar 14 05:31 /lib/libc-2.3.6.so
-rw-r--r-- 1 root root 2519920 Mar 14 05:00 /usr/lib/libc.a
-rw-r--r-- 1 root root 238 Mar 14 04:26 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Nov 19 07:11 /usr/lib/libc-client.a - c-client.a
lrwxrwxrwx 1 root root 20 Nov 19 07:11 /usr/lib/libc-client.so -
libc-client.so.2004g
-rwxr-xr-x 1 root root 800272 Dec 1 11:58 /usr/lib/libc-client.so.0
-rwxr-xr-x 1 root root 828604 Nov 17 05:25 /usr/lib/libc-client.so.2004g
Configure command: ./configure '--build=i386-redhat-linux'
'--host=i386-redhat-linux' '--target=i386-redhat-linux-gnu' '--program-prefix='
'--prefix=/usr' '--exec-prefix=/usr'