Re: Problem with my.cnf file

[anil alapati]

Hi Scott,

Jus now, Created a new cnf file as you suggested.

But failed to start with permission as 644. So, given as 777 and started the server. And now the file is under root ownership.

here was the error report:


130629 0:26:24 [Note] /usr/libexec/mysqld: Normal shutdown

130629 0:26:24 [Note] Event Scheduler: Purging the queue. 0 events
130629 0:26:26 [Warning] /usr/libexec/mysqld: Forcing close of thread 3649 user: ''

130629 0:26:26 [Warning] /usr/libexec/mysqld: Forcing close of thread 3648 user: ''

130629 0:26:26 [Warning] /usr/libexec/mysqld: Forcing close of thread 3647 user: ''

130629 0:26:26 [Warning] /usr/libexec/mysqld: Forcing close of thread 3646 user: ''

130629 0:27:06 InnoDB: Starting shutdown...
130629 0:27:10 InnoDB: Shutdown completed; log sequence number 2 838227014
130629 0:27:10 [Note] /usr/libexec/mysqld: Shutdown complete

130629 00:27:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130629 00:27:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 134217728 bytes!
130629 0:27:11 [ERROR] Plugin 'InnoDB' init function returned error.
130629 0:27:11 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130629 0:27:11 [ERROR] Unknown/unsupported table type: InnoDB
130629 0:27:11 [ERROR] Aborting

130629 0:27:11 [Note] /usr/libexec/mysqld: Shutdown complete

130629 00:27:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130629 00:27:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Warning: World-writable config file '/etc/my.cnf' is ignored
130629 0:27:28 InnoDB: Started; log sequence number 2 838227014
130629 0:27:28 [Note] Event Scheduler: Loaded 0 events
130629 0:27:28 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.52' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution