Grokbase Groups MySQL mysql May 2006
FAQ
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' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--with-readline' '--with-vio' '--with-openssl' '--without-debug' '--enable-shared' '--with-bench' '--localstatedir=/var/lib/mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-mysqld-user=mysql' '--with-extra-charsets=all' '--with-innodb' '--with-isam' '--with-berkeley-db' '--enable-local-infile' '--enable-large-files=yes' '--enable-largefile=yes' '--enable-thread-safe-client' '--disable-dependency-tracking' '--with-named-thread-libs=-lpthread' 'CFLAGS=-O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=p
entium4 -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing' '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' 'FFLAGS=-O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables' 'build_alias=i386-redhat-linux' 'host_alias=i386-redhat-linux' 'target_alias=i386-redhat-linux-gnu'

Search Discussions

  • Sheeri kritzer at May 15, 2006 at 5:33 pm
    Check out line 1 of the fill_help_tables.sql file. (on my
    installation it was in /usr/share/mysql) See if there is an errant ".
    There shouldn't be, of course, but that's the problem according to
    MySQL.

    -Sheeri
    On 5/15/06, don-temp28@isis.cs3-inc.com wrote:

    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' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--with-readline' '--with-vio' '--with-openssl' '--without-debug' '--enable-shared' '--with-bench' '--localstatedir=/var/lib/mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--with-mysqld-user=mysql' '--with-extra-charsets=all' '--with-innodb' '--with-isam' '--with-berkeley-db' '--enable-local-infile' '--enable-large-files=yes' '--enable-largefile=yes' '--enable-thread-safe-client' '--disable-dependency-tracking' '--with-named-thread-libs=-lpthread' 'CFLAGS=-O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=p
    entium4 -fasynchronous-unwind-tables -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing' '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' 'FFLAGS=-O2 -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32 -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables' 'build_alias=i386-redhat-linux' 'host_alias=i386-redhat-linux' 'target_alias=i386-redhat-linux-gnu'


    --
    MySQL General Mailing List
    For list archives: http://lists.mysql.com/mysql
    To unsubscribe: http://lists.mysql.com/mysql?unsub=awfief@gmail.com

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupmysql @
categoriesmysql
postedMay 15, '06 at 4:59a
activeMay 15, '06 at 5:33p
posts2
users2
websitemysql.com
irc#mysql

2 users in discussion

Don-temp28: 1 post Sheeri kritzer: 1 post

People

Translate

site design / logo © 2022 Grokbase