Re: Cannot restart mysql server. [RESOLVED]

[arun jayapal]

Hi,

This was resolved.

But it is definitely a sort of a bug or an overlooked problem. Initially mysql was setup such that any new tables we've created uses the MyISAM storage engine by default. So prior to posting into the forums about this issue, we did try to change that setting; we wanted any new table created to use the InnoDB storage engine by default. We had changed the settings. We had set the log files to be saved to another location somewhere in the root (/) directory. The service did not have the privilege to access those files as mentioned in the log.

But the server wasn't restarted immediately after this action. We restarted it a lot later, and encountered this issue. To resolve this problem we somehow had to revert the config data inside my.cnf to its pristine format and then re-start the server.