MySQLInstance Configuration

Posted by Tuga on Server Fault See other posts from Server Fault or by Tuga
Published on 2009-11-09T13:06:36Z Indexed on 2010/03/14 13:05 UTC
Read the original article Hit count: 209

Filed under:

Hi guys,

i am using this line to configure MySQL 5.1

MySQLInstanceConfig.exe -i -q -lmysql_config.log ServerType=SERVER DatabaseType=MIXED ConnectionUsage=DSS Port=3306 AddBinToPath=yes ConnectionCount=10 SkipNetworking=no StrictMode=no RootPassword=password

it configures the server and the service is started fine, but the StrictMode is enabled even though i am disabling it in the configuration above...

if i look at my.ini i find

Set the SQL mode to strict sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

which i think is not supposed to be there...

am doing anything wrong? i am using the parameter wrong?

Vladimir,

© Server Fault or respective owner

Related posts about mysql