Check mysql syntax error in /etc/my.cnf

To check for any syntax error in /etc/my.cnf. I added a non-existent option to –log-warnings9 to /etc/my.cnf.

# /usr/sbin/mysqld --help --verbose 1>/dev/null
120413 23:18:36 [ERROR] /usr/sbin/mysqld: unknown option '--log-warnings9'

I corrected it to –log-warnings and ran again. It showed no warning. So we are safe to restart mysql.

[root@]# /usr/sbin/mysqld --help --verbose 1>/dev/null
[root@]#
Advertisements
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: