Magento error with pdo_mysql
Magento is a great Free / Open source eCommerce script, is much more prettier and yet complex than Prestashop or osCommerce or Virtuemart. Take sometimes to upload it to hosting server, but if your hosting provider have Automatic script installer like Installatron or Softacolous, you can install it in a breeze. So Installation of Magento is no longer problem.
But after a succesful installation, I even get this error saying that I dont have pdo_mysql installed on the server.
pdo_mysql extension is not installed
Trace:
#0 /home/store/public_html/lib/Zend/Db/Adapter/Abstract.php(441):
Varien_Db_Adapter_Pdo_Mysql->_connect()
#1 /home/store/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(230):
Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)
#2 /home/store/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(281):
Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)
#3 /home/store/public_html/app/code/core/Mage/Core/Model/Resource/
Type/Db/Pdo/Mysql.php(45):
Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')
#4 /home/store/public_html/app/code/core/Mage/Core/Model/
Resource.php(87): Mage_Core_Model_Resource_Type_Db_Pdo_Mysql-
>getConnection(Object(Mage_Core_Model_Config_Element))
#5 /home/store/public_html/app/code/core/Mage/Core/Model/Resource/
Setup.php(62): Mage_Core_Model_Resource->getConnection('core_setup')
#6 /home/store/public_html/app/code/core/Mage/Core/Model/Resource/
Setup.php(120): Mage_Core_Model_Resource_Setup->__construct('core_setup')
#7 /home/store/public_html/app/code/core/Mage/Core/Model/Config.php(263):
Mage_Core_Model_Resource_Setup::applyAllUpdates()
#8 /home/store/public_html/app/code/core/Mage/Core/Model/App.php(263):
Mage_Core_Model_Config->init(Array)
#9 /home/store/public_html/app/Mage.php(434):
Mage_Core_Model_App->init('', 'store', Array)
#10 /home/store/public_html/app/Mage.php(455):
Mage::app('', 'store', Array)
#11 /home/store/public_html/index.php(65): Mage::run()
#12 {main}
I don’t get it, when I check with function
<?php phpinfo(); ?>
pdo and pdo_mysql is there.
'--enable-pdo=shared' '--with-pdo-mysql=shared'
So, it’s time for searching and lurking into Google and Magento forum/docs
Almost an hour, until I found this thread, it says I need to add these lines into php.ini. I have root access to server so it does not problem for me, but about other who just using shared hosting?
; added when pdo_mysql is shared (or missing) extension=pdo.so extension=pdo_mysql.so extension=pdo_sqlite.so
Turns out, it’s not necessary system php.ini, I was misunderstand, and when I look on magento install dir, I found php.ini file, edit the file with above line. Open Magento URL, and there you go, Magento installation running succesfully. 
Related posts:
- SQL Error: Table ‘mysql.proc’ doesn’t exist Today I upgraded my HeidiSQL into version 4, but when...
- Skip Replication Error This is happen long time ago when Mysql Replication stop...