mysql_install_db를 해도 data디랙토리가 생성되지 않습니다.
make; make install
까지 모두 끝내고 /usr/local/mysql/bin에 가서
다음과 같이 입력하였습니다.
------------------------------------------
[root@linux bin]# ./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
051223 191611 [ERROR] Aborting
051223 191611 [Note] /usr/local/mysql/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/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h linux.hanuri.com password 'new-password'
See the manual for more instructions.
NOTE If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with
cd /usr/local/mysql ; /usr/local/mysql/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/local/mysql/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
------------------------------------------
이렇게 나와있어도
------------------------------------------
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
051223 191611 [ERROR] Abort
------------------------------------------
어떻게 해결하는지를 모르겠네요...
전반적인 내용을 못봐서 모르겠습니다만 인스톨에 문제가 있는것으로 보이네요
전반적인 내용을 못봐서 모르겠습니다만 인스톨에 문제가 있는것으로 보이네요.
제대로 설치가 되신게 아니니 명령을 주셔도 안되는것입니다요.
다시 설치를 시도해보세요.
일단 confiure 하실때 에러가 없는지 확인을 하시구요 (구문에러가 대부분입니다.)
두번째로 make; make install 하시지 마시고 하나씩 따로 하세요.
make; make install 은 에러가 있더라도 무시하고 컴파일 후 설치를 하게 됩니다.
configure 쪽에서 문제가 없으셨다면 위의 무시옵션을 주셔서 에러를 확인 못하셨을 가능성이 크네요.
./configure 하실때 옵션도 올려주셔야 뭔가 답이 나올듯 싶은데요
./configure 하실때 옵션도 올려주셔야 뭔가 답이 나올듯 싶은데요.
아.. /configure 내용도 복사해서 올리겠습니다.그래도 글
아.. /configure 내용도 복사해서 올리겠습니다.
그래도 글봐주시고 답변해주시는 분들이 있어서 다행이네요^^
즐거운 크리스마스되세요~
좀 길긴합니다만 올립니다..^^./configure --prefi
좀 길긴합니다만 올립니다..^^
./configure --prefix=/usr/local/mysql --with-charset=euckr --localstatedir=/usr/local/mysql/data >> configure.txt
nm lc-messages.o no symbols
nm lc-monetary.o no symbols
nm lc-numeric.o no symbols
nm lc-time.o no symbols
nm lc-paper.o no symbols
nm lc-name.o no symbols
nm lc-address.o no symbols
nm lc-telephone.o no symbols
nm lc-measurement.o no symbols
nm lc-identification.o no symbols
nm lc-collate.o no symbols
nm old_atexit.o no symbols
nm udiv_qrnnd.o no symbols
nm mp_clz_tab.o no symbols
nm getopt_init.o no symbols
nm init-posix.o no symbols
nm lseek64.o no symbols
nm oldgetrlimit64.o no symbols
nm getutmpx.o no symbols
which no orbit-config in (/usr/kerberos/sbin/usr/kerberos/bin/usr/local/sbin /usr/local/bin/sbin/bin/usr/sbin/usr/bin/usr/X11R6/bin/root/bin)
vi configure.txt 의 내용입니다.(733라인이네요;;; 여러분께 불편할듯 해서 죄송합니다..ㅠ_ㅠ)
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking target system type... i686-pc-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking whether build environment is sane... yes
checking whether make sets $(MAKE)... (cached) yes
checking for gawk... (cached) gawk
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking how to run the C preprocessor... gcc -E
checking "C Compiler version"... "gcc gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3)"
checking "C++ compiler version"... "g++ g++ (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3)"
checking for ranlib... ranlib
checking for a sed that does not truncate output... /bin/sed
checking for egrep... grep -E
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
checking how to recognise dependent libraries... pass_all
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking how to run the C++ preprocessor... g++ -E
checking for g77... g77
checking whether we are using the GNU Fortran 77 compiler... yes
checking whether g77 accepts -g... yes
checking the maximum length of command line arguments... 32768
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... (cached) ranlib
checking for strip... strip
checking if gcc static flag works... yes
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
configure creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking for g++ option to produce PIC... -fPIC
checking if g++ PIC flag -fPIC works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
appending configuration tag "F77" to libtool
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for g77 option to produce PIC... -fPIC
checking if g77 PIC flag -fPIC works... yes
checking if g77 supports -c -o file.o... yes
checking whether the g77 linker (/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking for a BSD-compatible install... /usr/bin/install -c
checking for bison... bison -y
checking for pdftex... no
checking for tex... no
checking "return type of sprintf"... "int"
checking for uname... /bin/uname
checking operating system... Linux
checking "if we should use 'skip-locking' as default for linux-gnu"... "yes"
checking for ln... /bin/ln
checking for ln... /bin/ln
checking for mv... /bin/mv
checking for rm... /bin/rm
checking for cp... /bin/cp
checking for sed... /bin/sed
checking for cmp... /usr/bin/cmp
checking for chmod... /bin/chmod
checking for hostname... /bin/hostname
checking for gnutar... no
checking for gtar... gtar
checking for perl... /usr/bin/perl
checking for doxygen... /usr/bin/doxygen
checking for pdflatex... no
checking for makeindex... no
checking for ps... /bin/ps
checking "how to check if pid exists"... "/bin/ps p $$PID | grep -v grep | grep mysqld > /dev/null"
checking for kill... /bin/kill
checking "for kill switches"... "/bin/kill -0 $$PID > /dev/null 2> /dev/null"
checking for gcc option to accept ANSI C...
checking if we should use assembler functions... no
checking if we should use RAID... no
checking If we should should enable LOAD DATA LOCAL by default... no
checking for getconf... getconf
checking for CFLAGS value to request large file support... -D_FILE_OFFSET_BITS=64
checking for LDFLAGS value to request large file support...
checking for LIBS value to request large file support...
checking for _FILE_OFFSET_BITS... 64
checking for _LARGEFILE_SOURCE... no
checking for _LARGE_FILES... no
checking for size_t... yes
checking for dirent.h that defines DIR... yes
checking for library containing opendir... none required
checking for ANSI C header files... (cached) yes
checking for sys/wait.h that is POSIX.1 compatible... yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking float.h usability... yes
checking float.h presence... yes
checking for float.h... yes
checking floatingpoint.h usability... no
checking floatingpoint.h presence... no
checking for floatingpoint.h... no
checking ieeefp.h usability... no
checking ieeefp.h presence... no
checking for ieeefp.h... no
checking limits.h usability... yes
checking limits.h presence... yes
checking for limits.h... yes
checking for memory.h... (cached) yes
checking pwd.h usability... yes
checking pwd.h presence... yes
checking for pwd.h... yes
checking select.h usability... no
checking select.h presence... no
checking for select.h... no
checking for stdlib.h... (cached) yes
checking stddef.h usability... yes
checking stddef.h presence... yes
checking for stddef.h... yes
checking for strings.h... (cached) yes
checking for string.h... (cached) yes
checking synch.h usability... no
checking synch.h presence... no
checking for synch.h... no
checking sys/mman.h usability... yes
checking sys/mman.h presence... yes
checking for sys/mman.h... yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking arpa/inet.h usability... yes
checking arpa/inet.h presence... yes
checking for arpa/inet.h... yes
checking sys/timeb.h usability... yes
checking sys/timeb.h presence... yes
checking for sys/timeb.h... yes
checking for sys/types.h... (cached) yes
checking sys/un.h usability... yes
checking sys/un.h presence... yes
checking for sys/un.h... yes
checking sys/vadvise.h usability... no
checking sys/vadvise.h presence... no
checking for sys/vadvise.h... no
checking for sys/wait.h... (cached) yes
checking term.h usability... yes
checking term.h presence... yes
checking for term.h... yes
checking for unistd.h... (cached) yes
checking utime.h usability... yes
checking utime.h presence... yes
checking for utime.h... yes
checking sys/utime.h usability... no
checking sys/utime.h presence... no
checking for sys/utime.h... no
checking termio.h usability... yes
checking termio.h presence... yes
checking for termio.h... yes
checking termios.h usability... yes
checking termios.h presence... yes
checking for termios.h... yes
checking sched.h usability... yes
checking sched.h presence... yes
checking for sched.h... yes
checking crypt.h usability... yes
checking crypt.h presence... yes
checking for crypt.h... yes
checking alloca.h usability... yes
checking alloca.h presence... yes
checking for alloca.h... yes
checking sys/ioctl.h usability... yes
checking sys/ioctl.h presence... yes
checking for sys/ioctl.h... yes
checking malloc.h usability... yes
checking malloc.h presence... yes
checking for malloc.h... yes
checking sys/malloc.h usability... no
checking sys/malloc.h presence... no
checking for sys/malloc.h... no
checking linux/config.h usability... yes
checking linux/config.h presence... yes
checking for linux/config.h... yes
checking sys/resource.h usability... yes
checking sys/resource.h presence... yes
checking for sys/resource.h... yes
checking sys/param.h usability... yes
checking sys/param.h presence... yes
checking for sys/param.h... yes
checking for floor in -lm... yes
checking for gethostbyname_r in -lnsl_r... no
checking for gethostbyname_r in -lnsl... yes
checking for gethostbyname_r... yes
checking for setsockopt... yes
checking for yp_get_default_domain... yes
checking for p2open... no
checking for p2open in -lgen... no
checking for bind... yes
checking for crypt in -lcrypt... yes
checking for crypt... yes
checking for sem_init... no
checking for sem_init in -lposix4... no
checking for zlib compression library... ok
checking for atomic operations... no
checking if we should use pstack... no
checking for int8... no
checking "Linux threads"... "starting"
checking "getconf GNU_LIBPTHREAD_VERSION"... "NPTL"
"no need to check headers"
checking "for pthread_create in -lpthread"... "yes"
checking "named thread libs"... "-lpthread"
checking for strtok_r in -lpthread... yes
checking for strtok_r... yes
checking for dlopen in -ldl... yes
checking for unistd.h... (cached) yes
checking for restartable system calls... yes
checking "need of special linking flags"... "-rdynamic"
checking for an ANSI C-conforming const... yes
checking for inline... inline
checking for off_t... yes
checking for struct stat.st_rdev... yes
checking whether time.h and sys/time.h may both be included... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking for char... yes
checking size of char... 1
checking for char*... yes
checking size of char*... 4
checking for int... yes
checking size of int... 4
checking for long... yes
checking size of long... 4
checking for long long... yes
checking size of long long... 8
checking size of off_t... 8
checking the need for #pragma interface/implementation... no
checking whether byte ordering is bigendian... no
checking base type of last arg to accept... socklen_t
checking struct type to use with setrlimit... struct rlimit
checking stack direction for C alloca... -1
checking for working alloca.h... (cached) yes
checking for alloca... yes
checking if struct timespec has a ts_sec member... no
checking if we have tzname variable... yes
checking for type ulong... yes
checking for type uchar... no
checking for type uint... yes
checking for type fp_except... no
checking for type in_addr_t... yes
checking if g++ supports bool types... yes
checking if conversion of longlong to float works... yes
checking for sigset_t... yes
checking for off_t... (cached) yes
checking for size_t... (cached) yes
checking for u_int32_t... yes
checking if pthread_yield takes zero arguments... yes
checking if pthread_yield takes 1 argument... no
checking for malloc.h... (cached) yes
checking sys/cdefs.h usability... yes
checking sys/cdefs.h presence... yes
checking for sys/cdefs.h... yes
checking for working alloca.h... yes
checking for alloca... (cached) yes
checking whether gcc needs -traditional... no
checking return type of signal handlers... void
checking for re_comp... yes
checking for regcomp... yes
checking for strdup... yes
checking vis.h usability... no
checking vis.h presence... no
checking for vis.h... no
checking for strlcat... no
checking for strlcpy... no
checking for issetugid... no
checking for fgetln... no
checking for getline... yes
checking for flockfile... yes
checking varargs.h usability... no
checking varargs.h presence... no
checking for varargs.h... no
checking stdarg.h usability... yes
checking stdarg.h presence... yes
checking for stdarg.h... yes
checking dirent.h usability... yes
checking dirent.h presence... yes
checking for dirent.h... yes
checking locale.h usability... yes
checking locale.h presence... yes
checking for locale.h... yes
checking ndir.h usability... no
checking ndir.h presence... no
checking for ndir.h... no
checking sys/dir.h usability... yes
checking sys/dir.h presence... yes
checking for sys/dir.h... yes
checking sys/file.h usability... yes
checking sys/file.h presence... yes
checking for sys/file.h... yes
checking sys/ndir.h usability... no
checking sys/ndir.h presence... no
checking for sys/ndir.h... no
checking sys/ptem.h usability... no
checking sys/ptem.h presence... no
checking for sys/ptem.h... no
checking sys/pte.h usability... no
checking sys/pte.h presence... no
checking for sys/pte.h... no
checking sys/select.h usability... yes
checking sys/select.h presence... yes
checking for sys/select.h... yes
checking sys/stream.h usability... no
checking sys/stream.h presence... no
checking for sys/stream.h... no
checking for sys/mman.h... (cached) yes
checking curses.h usability... yes
checking curses.h presence... yes
checking for curses.h... yes
checking termcap.h usability... yes
checking termcap.h presence... yes
checking for termcap.h... yes
checking for termio.h... (cached) yes
checking termbits.h usability... no
checking termbits.h presence... no
checking for termbits.h... no
checking asm/termbits.h usability... yes
checking asm/termbits.h presence... yes
checking for asm/termbits.h... yes
checking grp.h usability... yes
checking grp.h presence... yes
checking for grp.h... yes
checking paths.h usability... yes
checking paths.h presence... yes
checking for paths.h... yes
checking semaphore.h usability... yes
checking semaphore.h presence... yes
checking for semaphore.h... yes
checking for lstat... yes
checking for putenv... yes
checking for select... yes
checking for setenv... yes
checking for setlocale... yes
checking for strcoll... yes
checking for tcgetattr... yes
checking whether stat file-mode macros are broken... no
checking for type of signal functions... posix
checking whether programs are able to redeclare getpw functions... yes
checking for TIOCGWINSZ in sys/ioctl.h... yes
checking for FIONREAD in sys/ioctl.h... yes
checking for TIOCSTAT in sys/ioctl.h... no
checking if struct dirent has a d_ino member... yes
checking if struct dirent has a d_namlen member... no
checking whether signal handlers are of type void... yes
checking for tgetent in -lncurses... yes
checking for termcap functions library... -lncurses
checking for strunvis... no
checking for strvis... no
checking for strlcpy... (cached) no
checking for strlcat... (cached) no
checking for fgetln... (cached) no
checking for stdlib.h... (cached) yes
checking for unistd.h... (cached) yes
checking for getpagesize... yes
checking for working mmap... yes
checking return type of signal handlers... (cached) void
checking return type of qsort... void
checking whether utime accepts a null argument... yes
checking for vprintf... yes
checking for _doprnt... no
checking for alarm... yes
checking for bcmp... yes
checking for bfill... no
checking for bmove... no
checking for bzero... yes
checking for chsize... no
checking for cuserid... yes
checking for fchmod... yes
checking for fcntl... yes
checking for fconvert... no
checking for fdatasync... yes
checking for finite... yes
checking for fpresetsticky... no
checking for fpsetmask... no
checking for fsync... yes
checking for ftruncate... yes
checking for getcwd... yes
checking for gethostbyaddr_r... yes
checking for gethostbyname_r... (cached) yes
checking for getpass... yes
checking for getpassphrase... no
checking for getpwnam... yes
checking for getpwuid... yes
checking for getrlimit... yes
checking for getrusage... yes
checking for getwd... yes
checking for gmtime_r... yes
checking for index... yes
checking for initgroups... yes
checking for isnan... yes
checking for localtime_r... yes
checking for locking... no
checking for longjmp... yes
checking for lrand48... yes
checking for madvise... yes
checking for mallinfo... yes
checking for memcpy... yes
checking for memmove... yes
checking for mkstemp... yes
checking for mlockall... yes
checking for perror... yes
checking for poll... yes
checking for pread... yes
checking for pthread_attr_create... no
checking for pthread_attr_getstacksize... yes
checking for pthread_attr_setprio... no
checking for pthread_attr_setschedparam... yes
checking for pthread_attr_setstacksize... yes
checking for pthread_condattr_create... no
checking for pthread_getsequence_np... no
checking for pthread_key_delete... yes
checking for pthread_rwlock_rdlock... yes
checking for pthread_setprio... no
checking for pthread_setprio_np... no
checking for pthread_setschedparam... yes
checking for pthread_sigmask... yes
checking for readlink... yes
checking for realpath... yes
checking for rename... yes
checking for rint... yes
checking for rwlock_init... no
checking for setupterm... no
checking for shmget... yes
checking for shmat... yes
checking for shmdt... yes
checking for shmctl... yes
checking for sigaction... yes
checking for sigemptyset... yes
checking for sigaddset... yes
checking for sighold... yes
checking for sigset... yes
checking for sigthreadmask... no
checking for snprintf... yes
checking for socket... yes
checking for stpcpy... yes
checking for strcasecmp... yes
checking for strerror... yes
checking for strnlen... yes
checking for strpbrk... yes
checking for strstr... yes
checking for strtol... yes
checking for strtoll... yes
checking for strtoul... yes
checking for strtoull... yes
checking for tell... no
checking for tempnam... yes
checking for thr_setconcurrency... no
checking for vidattr... no
checking for clock_gettime... no
checking for isinf with <math.h>... yes
checking for fseeko... yes
checking for dlopen... yes
checking for dlerror... yes
checking style of gethost* routines... checking whether madvise is declared... yes
other
checking style of gethostname_r routines... glibc2
checking 3 argument to gethostname_r routines... char
checking "args to pthread_getspecific"... POSIX
checking "args to pthread_mutex_init"... POSIX
checking "args to readdir_r"... POSIX
checking "style of sigwait"... POSIX
checking "for pthread_attr_setscope"... yes
checking "can netinet files be included"... "yes"
Warning extra-tools disabled because --enable-thread-safe-client wasn't used
checking for ORBit... not found
checking if we should build MySQLFS... no
checking for OpenSSL... no
checking "character sets"... default euckr, collation euckr_korean_ci; compiled in euckr latin1 utf8
checking whether to compile national Unicode collations... yes
checking for big tables support... no
checking for BerkeleyDB... no
Not using Berkeley DB
checking for Innodb... Using Innodb
checking for aio_read in -lrt... yes
checking for example storage engine... no
checking for archive storage engine... no
checking for csv storage engine... no
checking for blackhole storage engine... no
checking for NDB Cluster... Not using NDB Cluster
configure creating ./config.status
config.status creating isam/Makefile
config.status creating merge/Makefile
config.status creating Makefile
config.status creating extra/Makefile
config.status creating mysys/Makefile
config.status creating strings/Makefile
config.status creating regex/Makefile
config.status creating heap/Makefile
config.status creating myisam/Makefile
config.status creating myisammrg/Makefile
config.status creating os2/Makefile
config.status creating os2/include/Makefile
config.status creating os2/include/sys/Makefile
config.status creating man/Makefile
config.status creating BUILD/Makefile
config.status creating vio/Makefile
config.status creating libmysql/Makefile
config.status creating client/Makefile
config.status creating pstack/Makefile
config.status creating pstack/aout/Makefile
config.status creating sql/Makefile
config.status creating sql/share/Makefile
config.status creating sql-common/Makefile
config.status creating SSL/Makefile
config.status creating dbug/Makefile
config.status creating scripts/Makefile
config.status creating include/Makefile
config.status creating sql-bench/Makefile
config.status creating tests/Makefile
config.status creating Docs/Makefile
config.status creating support-files/Makefile
config.status creating support-files/MacOSX/Makefile
config.status creating mysql-test/Makefile
config.status creating netware/Makefile
config.status creating include/mysql_version.h
config.status creating cmd-line-utils/Makefile
config.status creating cmd-line-utils/libedit/Makefile
config.status creating zlib/Makefile
config.status creating cmd-line-utils/readline/Makefile
config.status creating config.h
config.status executing depfiles commands
config.status executing default commands
configure configuring in innobase
configure running /bin/sh './configure' --prefix=/usr/local/mysql '--prefix=/usr/local/mysql' '--with-charset=euckr' '--localstatedir=/usr/local/mysql/data' CFLAGS='-O3 -DDBUG_OFF ' CXXFLAGS='-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti' --cache-file=/dev/null --srcdir=.
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking target system type... i686-pc-linux-gnu
checking whether to enable maintainer-specific portions of Makefiles... no
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for ranlib... ranlib
checking for a BSD-compatible install... /usr/bin/install -c
checking for a sed that does not truncate output... /bin/sed
checking for egrep... grep -E
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
checking how to recognise dependent libraries... pass_all
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking how to run the C++ preprocessor... g++ -E
checking for g77... g77
checking whether we are using the GNU Fortran 77 compiler... yes
checking whether g77 accepts -g... yes
checking the maximum length of command line arguments... 32768
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... (cached) ranlib
checking for strip... strip
checking if gcc static flag works... yes
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
configure creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking for g++ option to produce PIC... -fPIC
checking if g++ PIC flag -fPIC works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
appending configuration tag "F77" to libtool
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for g77 option to produce PIC... -fPIC
checking if g77 PIC flag -fPIC works... yes
checking if g77 supports -c -o file.o... yes
checking whether the g77 linker (/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking aio.h usability... yes
checking aio.h presence... yes
checking for aio.h... yes
checking sched.h usability... yes
checking sched.h presence... yes
checking for sched.h... yes
checking for int... yes
checking size of int... 4
checking for long... yes
checking size of long... 4
checking for void*... yes
checking size of void*... 4
checking for sched_yield... yes
checking for fdatasync... yes
checking for localtime_r... yes
checking whether byte ordering is bigendian... no
configure creating ./config.status
config.status creating Makefile
config.status creating os/Makefile
config.status creating ut/Makefile
config.status creating btr/Makefile
config.status creating buf/Makefile
config.status creating data/Makefile
config.status creating dict/Makefile
config.status creating dyn/Makefile
config.status creating eval/Makefile
config.status creating fil/Makefile
config.status creating fsp/Makefile
config.status creating fut/Makefile
config.status creating ha/Makefile
config.status creating ibuf/Makefile
config.status creating include/Makefile
config.status creating lock/Makefile
config.status creating log/Makefile
config.status creating mach/Makefile
config.status creating mem/Makefile
config.status creating mtr/Makefile
config.status creating page/Makefile
config.status creating pars/Makefile
config.status creating que/Makefile
config.status creating read/Makefile
config.status creating rem/Makefile
config.status creating row/Makefile
config.status creating srv/Makefile
config.status creating sync/Makefile
config.status creating thr/Makefile
config.status creating trx/Makefile
config.status creating usr/Makefile
config.status creating ib_config.h
config.status ib_config.h is unchanged
config.status executing depfiles commands
MySQL has a Web site at http//www.mysql.com/ which carries details on the
latest release, upcoming features, and other information to make your
work or play with MySQL more productive. There you can also find
information about mailing lists for MySQL discussion.
Remember to check the platform specific part of the reference manual for
hints about installing MySQL on your platform. Also have a look at the
files in the Docs directory.
Thank you for choosing MySQL!
너무 긴 글을 올려서 죄송합니다... 혹시 문제가 된다면 자진 삭제하겠습니다.
FC3 를 사용하였으며 GCC는 패키지에 있는 그대로 3.x버전입니다.(4.x는 문제가 많다고 들어서)
컴파일 한 파일은 mysql.com에서 받은 mysql-4.1.16.tar.gz 입니다.[/list]
make 의 결과도 올립니다.[root@linux mysql-4.
make 의 결과도 올립니다.
[root@linux mysql-4.1.16]# make >> make.txt
../mysys/libmysys.a(my_tempnam.o)(.text+0x34) In function `my_tempnam'
warning the use of `tempnam' is dangerous, better use `mkstemp'
../mysys/libmysys.a(my_tempnam.o)(.text+0x34) In function `my_tempnam'
warning the use of `tempnam' is dangerous, better use `mkstemp'
make.txt의 내용
...........이건 너무 길어서 필요하시다면 올리도록하겟습니다...
(1500라인이 넘으니 올리기도 죄송하군요)
메리크리스마스^^
당황스럽습니다. =_=일단 첨부터 다시 글을 읽어보았는데 이상한 부분
당황스럽습니다. =_=
일단 첨부터 다시 글을 읽어보았는데 이상한 부분이 있습니다.
아래 부분을 잠깐 보시고 대답해주세요.
make, make install 이 끝나고나면
./mysql_install_db는 제가 알고 있기로는 설치를 한 위치에서 실행하는것으로
알고있습니다.
그러니까 일반적인 설치방법을 보자면
1. tar 로 압축을 푼다.
2. 압축을 푼 디렉토리를 /usr/local/mysql 로 이동한다.
3. /usr/local/mysql 디렉토리로 이동후 config, make, make install 등을 한다.
4. ./scripts/mysql_install_db 를 실행한다.
이렇게 되어야 할텐데요.
즉 /usr/local/mysql/bin/ 이 아니라 /usr/local/mysql/scripts/의 mysql_install_db를 실행하는것입니다.
지금까지 제가 알고있기로는 이렇게 알고있습니다.
물론 저렇게 하고나서 실행을 한다고 되는건 아니지만요. -_-;
위의 상황이 끝난후 소유권과 퍼미션을 바꿔주고
/usr/local/mysql/bin/mysqld_safe 를 실행하셔야 합니다.
실행자를 누구로 주셨는지는 configure 때 나왔을테니 잘 아시겠구요.
혹시 위의 문제가 아닌지 확인해 보실 필요도 있으실 것 같습니다.
친절한 답변 감사드립니다.오리주둥이님께서 지적해주신 순서대로 해봤
친절한 답변 감사드립니다.
오리주둥이님께서 지적해주신 순서대로 해봤습니다.
-----------------------------------------------------
1. tar 로 압축을 푼다.
2. 압축을 푼 디렉토리를 /usr/local/mysql 로 이동한다.
3. /usr/local/mysql 디렉토리로 이동후 config, make, make install 등을 한다.
4. ./scripts/mysql_install_db 를 실행한다.
이렇게 되어야 할텐데요.
즉 /usr/local/mysql/bin/ 이 아니라 /usr/local/mysql/scripts/의 mysql_install_db를 실행하는것입니다.
-----------------------------------------------------
하지만 같은 결과가 나오는군요.ㅠ_ㅠ
어제 새벽 4시에 다시 깔아서 해보았으나 같은결과...
(다시 깔자마자 소스받아서 컴파일시도)
FC3 에 무슨 문제라도 있는걸까요... 저희집컴퓨터가 이상한건가...
install 정상적으로 안된것 같습니다. 아래 메세지도 그런 내용인것
install 정상적으로 안된것 같습니다. 아래 메세지도 그런 내용인것 같구요..
WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
The "HELP" command might not work properly
혹시 기존 mysql 데몬이 살아있는 상태에서 작업을 하셨다거나 아니면 실행하신 mysql_install_db 스크립트가 이번에 설치하신 파일이 아닐수도 있을것 같습니다. 파일 생성날짜를 한번 확인해 보세요~
======================
BLOG : http://superkkt.com
superkkt 님의 답글 감사합니다.superkkt님의 말씀대로
superkkt 님의 답글 감사합니다.
superkkt님의 말씀대로 날짜를 확인해 봤으나, 생성날짜가 맞구요.
혹시 mysql이 살아있을까봐
rpm -e 으로 관련 패키지(아파치나 php까지)를 지우고 다시 해도 마찮가지 메세지군요..
아 뭐를 빠트렸는지 정말..ㅠ_ㅠ
어제도 새벽에 다시 깔았는데...;;
그래도 답글 달아주시는 분들덕택에 여러가지 배워가며 희망을 찾고 있습니다.
모질라가 자꾸 죽네여 -_-;;; 3번째쓰는중 OTL소스 설치시
모질라가 자꾸 죽네여 -_-;;; 3번째쓰는중 OTL
소스 설치시 순서 입니다.
make 이후의 작업은 /usr/local/mysql/ 로 이동후 입니다.
혹시 mysql계정과 그룹을 만드셨는지 우선 확인해 보세요 ^^
---------------------------------------
blog : http://myohan.egloos.com
mysql 5.x 버전을 깔았떠니 잘되네요..대체 뭐가 문제였던건
mysql 5.x 버전을 깔았떠니 잘되네요..
대체 뭐가 문제였던건지는 여전히 미스테리-0-
답변주신분들 모두 감사합니다.^^ 덕택에 여러가지 해볼수 있었고 많이 배웠네요. mysql 5.x 깔아본것도 그런 시도중에 하나였어요~ ^^
버전 문제였을수도 있겠군요.그러니까 그 버전문제라는것이.. 사용하는
버전 문제였을수도 있겠군요.
그러니까 그 버전문제라는것이.. 사용하는 리눅스에 따라 틀린경우가 있더군요.
레드햇 9에서는 4.1..... 뭐 어쨌든.. -_-;
버전을 깔면 에러가 발생하는경우가 있더군요.
페도라 역시 특정버전에 문제가 발생하는경우도 있었구요.
이건 mysql 뿐만 아니라 몇몇 특정 프로그램에서도 발생을 했었습니다.
심지어 테스트서버에 설치한 삼바서버역시 어떤 배포판이냐, 어떤 버전이냐에 따라
쉐어모드로 동작은 되는데, 특정 디렉토리에 권한을 가진 사용자는 로그인만 되고 접근이 안된다던지 하는 특이한 문제가 발생이 되었습니다.
( 개인적인 경험이라 객관화되고 검증된 문제는 아닙니다. )
어쨌든 여차저차 해결을 하셨다니 다행입니다.
문제점을 찾아 해결하셨다면 더 많이 익히는 기회가 되셨을테지만
저역시 안되면 님처럼.. 쿨럭;;; -_-;;
혹시나 틈나셔서 이전 버전의 문제를 해결하시면 꼭 올려주세요.
궁금해 미치겠어요. +_+
[quote="hanuri"]친절한 답변 감사드립니다.오리주둥이님
mysql 설치한지 하도 오래 되어서 기억이 가물가물하긴 한데.
./scripts/mysql_install_db
해서 설치 안되었던적이 있는듯 합니다. ( 치매야 치매.. )
그냥
scripts/mysql_install_db
해서 해결 되었던거 같은데.......
이유는 저도 모르구요. 함 시도해 보세요. (안된다고 돌 던지시면 안되요 ^^)
댓글 달기