Hi, in my search i only found one thread on this which seemed pretty good but when i tried it, my mysql crashed on restart.
Here is what i tried.
i opened etc/my.cnf in ssh and added
then restarted mysql, it failed
so i removed that line and restarted again, and it came up fine.
I wonder why it does not like that line of code. Isnt that how you change the mode?
when i checked the mode it gave me this
which i have no clue what that means lol
Here is what i tried.
i opened etc/my.cnf in ssh and added
Code:
sql_mode="TRADITIONAL,NO_AUTO_CREATE_USER"
so i removed that line and restarted again, and it came up fine.
I wonder why it does not like that line of code. Isnt that how you change the mode?
when i checked the mode it gave me this
Code:
mysql -e 'select @@GLOBAL.sql_mode;'
+-------------------+
| @@GLOBAL.sql_mode |
+-------------------+
| |
+-------------------+