Difference between revisions of "mysqld ambiguous error message"

From thelinuxwiki
Jump to: navigation, search
(Created page with " == Problem == mysqld fails to start. ==Errors == # /etc/init.d/mysql start * Checking mysqld configuration for mysql ... 2015-06-29 15:22:32 0 [ERROR] /usr/sbin/mysq...")
 
(Errors)
 
Line 10: Line 10:
 
  2015-06-29 15:22:32 0 [ERROR] /usr/sbin/mysqld: ambiguous option '--log=/var/log/mysql/mysql.log' (log-bin, log_slave_updates)
 
  2015-06-29 15:22:32 0 [ERROR] /usr/sbin/mysqld: ambiguous option '--log=/var/log/mysql/mysql.log' (log-bin, log_slave_updates)
 
  2015-06-29 15:22:32 0 [ERROR] Aborting
 
  2015-06-29 15:22:32 0 [ERROR] Aborting
 
 
  2015-06-29 15:22:32 0 [Note] Binlog end
 
  2015-06-29 15:22:32 0 [Note] Binlog end
 
  * mysql config check failed                               
 
  * mysql config check failed                               
 
  * ERROR: mysql failed to start                [ !! ]
 
  * ERROR: mysql failed to start                [ !! ]
 
 
  
 
== solution ==
 
== solution ==

Latest revision as of 13:23, 30 June 2015

Problem

mysqld fails to start.

Errors

# /etc/init.d/mysql start
 * Checking mysqld configuration for mysql ...
2015-06-29 15:22:32 0 [ERROR] /usr/sbin/mysqld: ambiguous option '--log=/var/log/mysql/mysql.log' (log-bin, log_slave_updates)
2015-06-29 15:22:32 0 [ERROR] Aborting
2015-06-29 15:22:32 0 [Note] Binlog end
* mysql config check failed                              
* ERROR: mysql failed to start                 [ !! ]

solution

Root cause is the use of a deprecated my.cnf configuration option. In this case it was the log setting.

Change the following old config line

log = /var/log/mysql/mysql.log

to

general-log = /var/log/mysql/mysql.log

restart mysqld