I'm facing an issue with WampServer and phpMyAdmin and hoping you could help me out.
So, every time I restart WampServer, the "sql mode" variable in phpMyAdmin is getting reset to its default value instead of retaining the custom value I had set previously. Specifically, I had set the "sql mode" to "ONLY_FULL_GROUP_BY" to enforce strict SQL mode and avoid any potential issues with GROUP BY queries.
However, for some reason, WampServer seems to be ignoring this custom setting and reverting back to the default value after every restart. This is quite frustrating as I have to manually set it each time, which is quite time-consuming.
I'm using WampServer for my local development environment, and I rely heavily on phpMyAdmin for my database operations. Hence, it is crucial for me to have the "sql mode" value set correctly and persist between server restarts.
Has anyone else experienced this issue? Is there a way to make WampServer retain the custom "sql mode" value for phpMyAdmin even after restarting the server? I appreciate any insights or suggestions you may have.
Thanks in advance!