When I'm trying to install MySQL 5.5 community edition on my Ubuntu 10.04 by compiling the source code, I met the following problem:

$ fg % 1
sudo ../bin/mysqld_safe --basedir=/usr/local/mysql_community_5.5/data --user=mysql --defaults-file=/etc/my.cnf  

[sudo] password for linnan:

Sorry, try again. [sudo] password for linnan: 121023 09:26:21
mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect.
Internal program error (non-fatal): unknown logging method
'/usr/local/mysql_community_5.5/log/mysql.log' 121023 09:26:21
mysqld_safe Logging to '/var/log/mysql/error.log'.
Internal program error (non-fatal): unknown logging method
'/usr/local/mysql_community_5.5/log/mysql.log' 121023 09:26:22
mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121023 09:26:23 mysqld_safe mysqld from pid file
/var/lib/mysql/ubuntu.pid ended

It seems that the problem is related to log configuration. I've noticed a bugfix related to this problem: http://bugs.mysql.com/bug.php?id=50083
But I still have no idea how to solve it.

The relative content in /etc/my.cnf:

[mysqld] port = 3306 socket = /tmp/mysql.sock
skip-external-locking key_buffer_size = 384M max_allowed_packet = 1M
table_open_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M
read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M
thread_cache_size = 8 query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 character-set-server=utf8

mysqld_safe_syslog.cnf: /etc/mysql/conf.d/mysqld_safe_syslog.cnf:


Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.