My box is redhat 9 and I installed xampp 1.6.6 for linux.
At homepage, I got "DB connection error", and I ran "mysqld_safe --user=mysql".
The result is,
root@:/opt/lampp/var/mysql>mysqld_safe --user=mysql&
[1] 16574
root@:/opt/lampp/var/mysql>Starting mysqld daemon with databases from /opt/lampp/var
STOPPING server from pid file /opt/lampp/var/MYSERVER.pid
090812 09:58:24 mysqld ended
[1]+ Done mysqld_safe --user=mysql
For more information, I ask this
root@:/opt/lampp/var/mysql>sh -x mysqld_safe --user=mysql
+ KILL_MYSQLD=1
+ MYSQLD=
+ trap '' 1 2 3 15
+ umask 007
+ defaults=
+ case "$1" in
++ pwd
+ MY_PWD=/opt/lampp/var/mysql
+ test -f ./share/mysql/english/errmsg.sys -a -x ./bin/mysqld
+ test -f ./share/mysql/english/errmsg.sys -a -x ./libexec/mysqld
+ MY_BASEDIR_VERSION=/opt/lampp
+ ledir=/opt/lampp/sbin
+ test -d /opt/lampp/data/mysql
+ test -d /opt/lampp/var/mysql
+ DATADIR=/opt/lampp/var
+ test -z ''
+ test -r /opt/lampp/my.cnf
+ test -r /opt/lampp/var/my.cnf
+ MYSQL_HOME=/opt/lampp
+ export MYSQL_HOME
+ user=nobody
+ niceness=0
+ pid_file=
+ err_log=
+ test -x ./bin/my_print_defaults
+ test -x /opt/lampp/bin/my_print_defaults
+ print_defaults=/opt/lampp/bin/my_print_defaults
+ args=
+ SET_USER=2
++ /opt/lampp/bin/my_print_defaults --loose-verbose mysqld server
+ parse_arguments --default-character-set=utf8 --init_connect=SET collation_connection = utf8_general_ci --init_connect=SET NAMES utf8 --default-character-set=utf8 --character-set-server=utf8 --collation-server=utf8_general_ci --skip-name-resolve --port=3306 --socket=/opt/lampp/var/mysql/mysql.sock --skip-locking --key_buffer=16M --max_allowed_packet=1M --table_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --default-storage-engine=innodb --server-id=1 --innodb_data_home_dir=/opt/lampp/var/mysql/ --innodb_data_file_path=ibdata1:10M:autoextend --innodb_log_group_home_dir=/opt/lampp/var/mysql/ --innodb_log_arch_dir=/opt/lampp/var/mysql/ --innodb_buffer_pool_size=16M --innodb_additional_mem_pool_size=2M --innodb_log_file_size=5M --innodb_log_buffer_size=8M --innodb_flush_log_at_trx_commit=1 --innodb_lock_wait_timeout=50 --default-character-set=utf8 --init_connect=SET collation_connection = utf8_general_ci --init_connect=SET NAMES utf8 --default-character-set=utf8 --character-set-server=utf8 --collation-server=utf8_general_ci --skip-name-resolve --port=3306 --socket=/opt/lampp/var/mysql/mysql.sock --skip-locking --key_buffer=16M --max_allowed_packet=1M --table_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --default-storage-engine=innodb --server-id=1 --innodb_data_home_dir=/opt/lampp/var/mysql/ --innodb_data_file_path=ibdata1:10M:autoextend --innodb_log_group_home_dir=/opt/lampp/var/mysql/ --innodb_log_arch_dir=/opt/lampp/var/mysql/ --innodb_buffer_pool_size=16M --innodb_additional_mem_pool_size=2M --innodb_log_file_size=5M --innodb_log_buffer_size=8M --innodb_flush_log_at_trx_commit=1 --innodb_lock_wait_timeout=50
+ pick_args=
+ test --default-character-set=utf8 = PICK-ARGS-FROM-ARGV
+ for arg in '"$@"'
+ case "$arg" in
+ test -n ''
+ for arg in '"$@"'
+ case "$arg" in
++ echo --port=3306
++ sed -e 's;--port=;;'
+ mysql_tcp_port=3306
+ for arg in '"$@"'
+ case "$arg" in
++ echo --socket=/opt/lampp/var/mysql/mysql.sock
++ sed -e 's;--socket=;;'
+ mysql_unix_port=/opt/lampp/var/mysql/mysql.sock
+ for arg in '"$@"'
+ case "$arg" in
+ test -n ''
+ for arg in '"$@"'
+ case "$arg" in
+ test -n ''
+ for arg in '"$@"'
+ case "$arg" in
++ echo --port=3306
++ sed -e 's;--port=;;'
+ mysql_tcp_port=3306
+ for arg in '"$@"'
+ case "$arg" in
++ echo --socket=/opt/lampp/var/mysql/mysql.sock
++ sed -e 's;--socket=;;'
+ mysql_unix_port=/opt/lampp/var/mysql/mysql.sock
+ for arg in '"$@"'
+ case "$arg" in
+ test -n ''
+ for arg in '"$@"'
+ case "$arg" in
+ test -n ''
+ test 2 -eq 2
+ SET_USER=0
++ /opt/lampp/bin/my_print_defaults --loose-verbose mysqld_safe safe_mysqld
+ parse_arguments
+ pick_args=
+ test '' = PICK-ARGS-FROM-ARGV
+ parse_arguments PICK-ARGS-FROM-ARGV --user=mysql
+ pick_args=
+ test PICK-ARGS-FROM-ARGV = PICK-ARGS-FROM-ARGV
+ pick_args=1
+ shift
+ for arg in '"$@"'
+ case "$arg" in
++ echo --user=mysql
++ sed -e 's;--[=]*=;;'
+ user=mysql
+ SET_USER=1
+ safe_mysql_unix_port=/opt/lampp/var/mysql/mysql.sock
++ dirname /opt/lampp/var/mysql/mysql.sock
+ mysql_unix_port_dir=/opt/lampp/var/mysql
+ '[' '!' -d /opt/lampp/var/mysql ']'
+ test -z ''
+ test -x /opt/lampp/sbin/mysqld-max
+ MYSQLD=mysqld
+ test '!' -x /opt/lampp/sbin/mysqld
+ test -z ''
++ /bin/hostname
+ pid_file=/opt/lampp/var/MYSERVER.pid
+ test -z ''
++ /bin/hostname
+ err_log=/opt/lampp/var/MYSERVER.err
+ test -n /opt/lampp/var/mysql/mysql.sock
+ args='--socket=/opt/lampp/var/mysql/mysql.sock '
+ test -n 3306
+ args='--port=3306 --socket=/opt/lampp/var/mysql/mysql.sock '
+ test 0 -eq 0
+ NOHUP_NICENESS=nohup
+ nohup nice
++ nice
+ normal_niceness=0
++ nohup nice
+ nohup_niceness=0
+ numeric_nice_values=1
+ for val in '$normal_niceness' '$nohup_niceness'
+ case "$val" in
+ for val in '$normal_niceness' '$nohup_niceness'
+ case "$val" in
+ test 1 -eq 1
++ expr 0 - 0
+ nice_value_diff=0
+ test 1 -eq 0
+ USER_OPTION=
+ test -w / -o root = root
+ test mysql '!=' root -o 1 = 1
+ USER_OPTION=--user=mysql
+ touch /opt/lampp/var/MYSERVER.err
+ chown mysql /opt/lampp/var/MYSERVER.err
+ test -n ''
+ test -n ''
+ test -f /opt/lampp/var/MYSERVER.pid
+ echo 'Starting mysqld daemon with databases from /opt/lampp/var'
Starting mysqld daemon with databases from /opt/lampp/var
++ date '+%y%m%d %H:%M:%S mysqld started'
+ echo '090812 10:02:52 mysqld started'
+ true
+ rm -f /opt/lampp/var/mysql/mysql.sock /opt/lampp/var/MYSERVER.pid
+ test -z '--port=3306 --socket=/opt/lampp/var/mysql/mysql.sock '
+ eval 'nohup /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var --user=mysql --pid-file=/opt/lampp/var/MYSERVER.pid --skip-external-locking --port=3306 --socket=/opt/lampp/var/mysql/mysql.sock >> /opt/lampp/var/MYSERVER.err 2>&1'
++ nohup /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var --user=mysql --pid-file=/opt/lampp/var/MYSERVER.pid --skip-external-locking --port=3306 --socket=/opt/lampp/var/mysql/mysql.sock
+ test '!' -f /opt/lampp/var/MYSERVER.pid
+ echo 'STOPPING server from pid file /opt/lampp/var/MYSERVER.pid'
STOPPING server from pid file /opt/lampp/var/MYSERVER.pid
+ break
++ date '+%y%m%d %H:%M:%S'
+ echo '090812 10:02:53 mysqld ended'
+ tee -a /opt/lampp/var/MYSERVER.err
090812 10:02:53 mysqld ended
+ echo ''
+ tee -a /opt/lampp/var/MYSERVER.err
Please help for solving this problem.
Any comment would appreciated.
