I've just switched my WHM to start using mySQL 5.0.27-standard. Unfortunately, mySQL defaults to being incredibly stupid, and doing things like 'truncating' a string if you try and insert it into a numeric column. hint: it should fail and return an error.
However, it does have a strict mode that can be enabled by, according to the documentation, passing the argument --sql-mode="TRADITIONAL" to the mysql daemon when it starts. I guess cPanel handles the starting of the mySQL daemon, but unsurprisingly I have no idea how it does it. Does anyone know whether uses the instance manager (in which case this could probably be configured using the /etc/my.cnf file) or whether cPanel manually launches the mySQL daemon?
In any case, how can I force mySQL into its 'traditional' mode on startup on my cPanel system? I want mySQL always to be in strict mode.
However, it does have a strict mode that can be enabled by, according to the documentation, passing the argument --sql-mode="TRADITIONAL" to the mysql daemon when it starts. I guess cPanel handles the starting of the mySQL daemon, but unsurprisingly I have no idea how it does it. Does anyone know whether uses the instance manager (in which case this could probably be configured using the /etc/my.cnf file) or whether cPanel manually launches the mySQL daemon?
In any case, how can I force mySQL into its 'traditional' mode on startup on my cPanel system? I want mySQL always to be in strict mode.