MySQL 왕초보입니다.
MySQL을 실행하면 바로 시작했다가 끝내버리는군요.
/usr/local/mysql/data/컴퓨터주소.err 파일을 확인해보니
--bindir이라는 option 을 모른다는 메시지만 남아있어요.
사용시스템
=========
H/W : SUN Sparc20
kernel : Linux 2.2.5.-15
mysql_version : 3.22.32
shared_lib_version : 6:0:0
release : 1
실행내용
=======
# /etc/rc.d/init.d/mysql.server start
# Starting mysqld deamon with databases from /usr/local/mysql/data
mysqld daemon ended
/etc/rc.d/mysql.server 내용에 다음과 같은 값들이 설정되 있구요
=================================================
PATH=/sbin:/usr/sbin:/bin:/usr/bin
basedir=/usr/local/mysql
bindir=/usr/local/mysql/bin
datadir=/usr/local/mysql/data
pid_file=/usr/local/mysql/data/mysqld.pid
mysql_daemon_user=root # Run mysqld as this user.
export PATH
/etc/my.cnf 내용
============
[mysqld]
basedir=/usr/local/mysql
bindir=/usr/local/mysql/bin
datadir=/usr/local/mysql/data
socket=tmp/mysqld.sock
port=3306
[mysql.server]
user=mysql
basedir=/usr/local/mysql
/usr/local/mysql/data/컴퓨터주소.err 파일의 마지막 부분
===========================================
/usr/local/mysql/libexec/mysqld: unrecognized option `--bindir=/usr/local/mysql/bin'
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
/usr/local/mysql/libexec/mysqld Ver 3.22.32 for unknown-linux-gnu on sparc
Copyright (C) 1979-2000 TcX AB & Monty Program KB & Detron HB.
All rights reserved. Se the file PUBLIC for licence information.
This software comes with ABSOLUTELY NO WARRANTY: see the file PUBLIC for details.
Starts the mysql server
Usage: /usr/local/mysql/libexec/mysqld [OPTIONS]
-b, --basedir=path Path to installation directory. All paths are
usually resolved relative to this
등등... 옵션 설명이 나오고
Default options are read from the following files in the given order:
/etc/my.cnf /usr/local/mysql/data/my.cnf ~/.my.cnf
The following groups are read: mysqld server
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# Only read default options from the given file #
To see what values a running MySQL server is using, type
'mysqladmin variables' inThe default values (after parsing the command line arguments) are:
basedir: /home3/mysql/
datadir: /home3/mysql/data/
tmpdir: /tmp/
language: /home3/mysql/share/mysql/english/
pid file: /home3/mysql/data/networks.pid
TCP port: 3306
Unix socket: /tmp/mysql.sock
system locking is not in use
Possible variables for option --set-variable (-O) are:
back_log current value: 5
connect_timeout current value: 5
delayed_insert_timeout current value: 300
delayed_insert_limit current value: 100
:
: 등의 변수값들이 나오고
tmp_table_size current value: 1048576
thread_stack current value: 65536
wait_timeout current value: 28800
mysqld ended on Sat Mar 4 20:11:33 KST 2000
stead of 'mysqld --help'.
|