In the data directory for MySQL, you should find a file titled <hostname>.err. What is the contents of that file?
-----Original Message----- From: Hamid Nouri [mailto:[EMAIL PROTECTED] Sent: Saturday, October 18, 2003 5:07 PM To: [EMAIL PROTECTED] Subject: I can't start mysqld Hi there I have a problem with starting mysqld. I tried to install mysql-4.1 on my debian, but when i want to start mysql daemon it failes. I generated bug report. my.cnf and mysql also attached. Thanks in advance ----------------------------------------------------- SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: <synopsis of the problem (one line)> >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.0-alpha-standard (Official MySQL-standard binary) >C compiler: 2.95.3 >C++ compiler: 2.95.3 >Environment: <machine, os, target, libraries (multiple lines)> System: Linux pinguin 2.4.18-bf2.4 #1 Son Apr 14 09:53:28 CEST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Oct 3 13:31 /lib/libc.so.6 -> libc-2.2.5.so -rwxr-xr-x 1 root root 1153784 Apr 28 2002 /lib/libc-2.2.5.so -rw-r--r-- 1 root root 2390922 Apr 28 2002 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Apr 28 2002 /usr/lib/libc.so -rw-r--r-- 1 root root 716080 Jan 13 2002 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc' --------------------my.cnf----------------------- # You can copy this to one of: # /etc/mysql/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password = my_password port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram [safe_mysqld] err-log = /var/log/mysql/mysql.err [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 # # You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log # for backward compatibility. Both location gets rotated by the cronjob. #log = /var/log/mysql/mysql.log log = /var/log/mysql.log basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-locking # # The skip-networkin option will no longer be set via debconf menu. # You have to manually change it if you want networking i.e. the server # listening on port 3306. The default is "disable" - for security reasons. skip-networking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K # # Here you can see queries with especially long duration #log-slow-queries = /var/log/mysql/mysql-slow.log # # The following can be used as easy to replay backup logs or for replication #server-id = 1 #log-bin = /var/log/mysql/mysql-bin.log #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name # # Read the manual if you want to enable InnoDB! skip-innodb [mysqldump] quick set-variable = max_allowed_packet=1M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] set-variable = key_buffer=16M --------------mysql------------------------- #!/bin/sh -e # # MySQL daemon start/stop script. # # Debian version. Based on the original by TcX. # test $DEBIAN_SCRIPT_DEBUG && set -v -x test -x /usr/local/mysql/bin/mysqld || exit 0 SELF=$(cd $(dirname $0); pwd -P)/$(basename $0) CONF=/etc/mysql/my.cnf MYADMIN="/usr/local/mysql/bin/mysqladmin" # Safeguard (relative paths, core dumps..) cd / umask 077 PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/mysql/bin export PATH # mysqladmin likes to read /root/.my.cnf. This is usually not what I want # as many admins e.g. only store a password without a username there and # so break my scripts. export HOME=/etc/mysql/ is_mysqld_alive () { if [ -n "`$MYADMIN ping 2>/dev/null`" ]; then return 0; else return 1; fi } case "$1" in 'start') # Start daemon echo -n "Starting MySQL database server: mysqld" /usr/local/mysql/bin/safe_mysqld > /dev/null 2>&1 & for i in 1 2 3 4 5 6; do if is_mysqld_alive; then break; fi sleep 1 done if is_mysqld_alive; then echo "." else echo "...failed." fi ;; 'stop') # * As a passwordless mysqladmin (e.g. via ~/.my.cnf) must be possible # at least for cron, we can rely on it here, too. (although we have # to specify it explicit as e.g. sudo environments points to the normal # users home and not /root) echo -n "Stopping MySQL database server: mysqld" if is_mysqld_alive; then set +e $MYADMIN shutdown r=$? set -e if [ "$r" -ne 0 ]; then echo "...failed" echo -n "Killing MySQL database server by signal: mysqld" for i in 1 2 3 4 5 6; do killall -15 mysqld sleep 1 killall -9 mysqld if is_mysqld_alive; then break; fi done fi fi if is_mysqld_alive; then echo "...failed." echo "Please stop the daemon yourself!" exit -1 else echo "." fi ;; 'restart') set +e; $SELF stop; set -e $SELF start ;; 'reload'|'force-reload') echo -n "Reloading MySQL database server: mysqld" $MYADMIN reload echo "." ;; 'status') $MYADMIN version ;; *) echo "Usage: $SELF start|stop|restart|reload|force-reload" exit 1 ;; esac __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]