Install Magento on Mysql5.6

Find a home foreign trade company, the site in Magento 1.6.2.

To cater for the needs of the company, install a copy locally for learning and use. In the installation link has been an error said InnoDB not installed.

Because the local environment is used for a long time, you can be sure to support InnoDB.

That must be the Magento version of the problem, hit a php5.4 patch (mine is php5.5), no

Another Google .... Finally found:

The Mysql5.6 version rejects the variable "Have_innodb".

And we look at this code /app/code/core/mage/install/model/installer/db/mysql4.php

 Public function Supportengine ()    {         $variables  $this-_getconnection ()            ->fetchpairs (' SHOW VARIABLES ');         return (! isset ($variables$variablesfalsetrue;    }

Still according to ' Have_innodb ' to judge whether to support InnoDB has not been feasible. So we're going to change this code and add the following code before return.

if (! isset ($variables[' Have_innodb ']))        {  $engines$this->_getconnection ()->fetchpairs (' SHOW engines ');  return (isset($engines[' InnoDB ']) && ($engines$engines [' InnoDB '] = = ' YES ');}

This way, you can install it smoothly.

Article reference:

• http://www.magentochina.org/blog/install-magento-on-mysql-5-6
• http://my.oschina.net/phpnew/ blog/113943