[TYPO3-install] Using Mysql5 in MYSQL40 mode without changing sql-mode in my.ini

[Michiel Roos [netcreators]]

Hi Franz,

I guess you should be able to run mysqld in a second instance on another
port. Then you woult have to tweak either of the applications to use
that mysqld instead of the one behind the default port.

You should be able to do something like:
shell> mysqld --sql_mode="some mode stuff"

It's hackery though . . .

Regards,


Michiel

Franz mAIER schreef:
> Hi,
> 
> We're trying to install Typo3 on Mysql 5 and PHP 5. This causes some troubles because we normally use Mysql in strict Mode. This prevents me from logging in to the BE, and creating new pages and so on.
> Google brought up that setting sql-mode="MYSQL40" would solve the problem. This really worked, but it's no real solution, because our other Applications using the mysql-Database prefer strict-mode...
> Is there a way to set the mysql sql-mode to 'MYSQL40' without setting it globally in my.ini? 
> 
> Any help would be highly appreciated.
> 
> 
> Best regards
> Johannes
> 
> 
> 
>       __________________________________________________________
> Gesendet von Yahoo! Mail.
> Dem pfiffigeren Posteingang.
> http://de.overview.mail.yahoo.com


-- 
Netcreators BV :: creation and innovation
www.netcreators.com

Interesse in werken bij Netcreators?
http://www.netcreators.com/bedrijf/vacatures/