MySQL my.cnf自动重置

Question

When I modify the file mamp/tmp/mysql/my.cnf and then restart MySQL all changes are reverted back to the original state.

Does anyone know how to fix this? It seems that my.cnf is created every time MySQL starts.

Answer 1

File mamp/tmp/mysql/my.cnf is, as the path says, temporary. It's automatically generated on MySQL start based on other configs.

You should use MAMP/conf/my.cnf instead. If the file does not exist then create a new one.