Using MySQL Server 5.5 with Snofyre

[Jay Kola]

Using MySQL Server 5.5 with Snofyre

• We recommend using MySQL Server version 5.1 with Snofyre version 1.8
• MySQL workbench has a known issue creating user accounts when using MySQL Server version 5.5.

However, if you are interested in using Snofyre with MySQL Server 5.5, there is a workaround for the above bug. In order to use MySQL Server 5.5, you need to disable 'strict-mode' on the server. Here is the procedure for doing this:

1. Click on the Configuration tab in the MySQL Workbench.
2. Under Configuration, click on Advanced tab.
   
3. Scroll down to where you see the SQL Mode field.
   
4. Edit this value (by deleting STRICT_TRANS_TABLES).
   
5. Apply your changes and restart MySQL server. You should now be good to go!
   

A more elaborate step by step guide (with screenshots) can be found on my blog. I'm linking out to my blog, because Google groups seems to mess up the layout, when using images. I'll move this info to the Snofyre site, if the MySQL Workbench bug does not get fixed soon....