MySQL server on Ubuntu fails to start after changes made to my.cnf in Windows

Question

I have MySQL 5.5 running on Ubuntu Server 12.10. When I run /etc/init.d/mysql restart, I get the following:

mysql start/running, process 2754

However, when I open /etc/mysql/my.cnf in Windows via a Samba share and save the file without any changes, I get the following when running the exact same command, /etc/init.d/mysql restart:

start: Job failed to start

What is causing the mysql from restarting? How can I make edits in windows without breaking my config file?

Answer 1

It could it be Windows line endings vs Unix line endings?

Answer 2

You can make changes in Windows but you have to use other editor than Notepad. Try Notepad++, PsPad or similar software. Windows notepad always change line endings to Windows style and it causes problem.