In the data directory for MySQL, you should find a file titled
.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:
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support |
extended email support ]
>Synopsis:
>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:
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:
lrwxrwxrwx1 root root 13 Oct 3
13:31 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x1 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
te