cancel
Showing results for 
Search instead for 
Did you mean: 

Authentication plugin 'mysql_clear_password' cannot be loaded

Authentication plugin 'mysql_clear_password' cannot be loaded

Hello, 

 

I'm trying to move my magento installation to another host but getting this problem:

 



SQLSTATE[HY000] [2059] Authentication plugin 'mysql_clear_password' cannot be loaded: plugin not enabled
Trace: #0 /mnt/web318/a3/78/5824078/htdocs/shopnew/lib/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 /mnt/web318/a3/78/5824078/htdocs/shopnew/lib/Varien/Db/Adapter/Pdo/Mysql.php(396): Zend_Db_Adapter_Pdo_Mysql->_connect() #2 /mnt/web318/a3/78/5824078/htdocs/shopnew/lib/Zend/Db/Adapter/Abstract.php(460): Varien_Db_Adapter_Pdo_Mysql->_connect() #3 /mnt/web318/a3/78/5824078/htdocs/shopnew/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array) #4 /mnt/web318/a3/78/5824078/htdocs/shopnew/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array) #5 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Resource.php(179): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8') #6 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection('pdo_mysql', Array) #7 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320): Mage_Core_Model_Resource->getConnection('core_write') #8 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(350): Mage_Core_Model_Resource_Db_Abstract->_getConnection('write') #9 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(335): Mage_Core_Model_Resource_Db_Abstract->_getWriteAdapter() #10 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(360): Mage_Core_Model_Resource_Db_Abstract->_getReadAdapter() #11 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(134): Mage_Core_Model_Resource_Db_Abstract->getReadConnection() #12 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Config.php(1357): Mage_Core_Model_Resource_Db_Collection_Abstract->__construct(Object(Mage_Core_Model_Resource_Website)) #13 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Config.php(1389): Mage_Core_Model_Config->getModelInstance('core_resource/w...', Object(Mage_Core_Model_Resource_Website)) #14 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/Mage.php(491): Mage_Core_Model_Config->getResourceModelInstance('core/website_co...', Object(Mage_Core_Model_Resource_Website)) #15 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Abstract.php(208): Mage::getResourceModel('core/website_co...', Object(Mage_Core_Model_Resource_Website)) #16 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/Abstract.php(213): Mage_Core_Model_Abstract->getResourceCollection() #17 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/App.php(619): Mage_Core_Model_Abstract->getCollection() #18 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/App.php(477): Mage_Core_Model_App->_initStores() #19 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/code/core/Mage/Core/Model/App.php(360): Mage_Core_Model_App->_initCurrentStore('', 'store') #20 /mnt/web318/a3/78/5824078/htdocs/shopnew/app/Mage.php(683): Mage_Core_Model_App->run(Array) #21 /mnt/web318/a3/78/5824078/htdocs/shopnew/index.php(83): Mage::run('', 'store') #22 {main}

 I have the development version installed on a VPS but moving it to a shared webhost. 

 

2 REPLIES 2

Re: Authentication plugin 'mysql_clear_password' cannot be loaded

Hi @laztrix,

 

That error is Mysql related.

Maybe you could ask your hosting provider about the problem.

Re: Authentication plugin 'mysql_clear_password' cannot be loaded

Another good example you should not go with a shared hosting provider as **bleep**ty as strato.de

 

Bad service and absolutely no tolerans in terms of providing with solutions. They didn't even bother to read my ticket properly and just shut down nicely.