Magento Error: SQLSTATE[HY000] [1045] Access denied for user 'MYSITE_magento'@'localhost' (using password: YES) -


i have copied magento site 1 server another, hoping make carbon copy of shop.

i exported/imported database via myphpadmin , zipped , unzipped site files.

everything there. have doubled checked db passwords , details. have checked of file/folder permissions correct. still error.

this error says ...

 there has been error processing request  exception printing disabled default security reasons.

here contents of magento error log:

a:4:{i:0;s:97: "sqlstate[hy000] [1045] access denied user 'mysite_magento'@'localhost' (using password: yes)" ;i:1;s:2792:" #0 /home/mysite/public_html/lib/zend/db/adapter/pdo/mysql.php(96): zend_db_adapter_pdo_abstract->_connect() #1 /home/mysite/public_html/lib/varien/db/adapter/pdo/mysql.php(251): zend_db_adapter_pdo_mysql->_connect() #2 /home/mysite/public_html/lib/zend/db/adapter/abstract.php(448): varien_db_adapter_pdo_mysql->_connect() #3 /home/mysite/public_html/lib/zend/db/adapter/pdo/abstract.php(238): zend_db_adapter_abstract->query('set names utf8', array) #4 /home/mysite/public_html/lib/varien/db/adapter/pdo/mysql.php(333): zend_db_adapter_pdo_abstract->query('set names utf8', array) #5 /home/mysite/public_html/app/code/core/mage/core/model/resource/type/db/pdo/mysql.php(45): varien_db_adapter_pdo_mysql->query('set names utf8') #6 /home/mysite/public_html/app/code/core/mage/core/model/resource.php(93): mage_core_model_resource_type_db_pdo_mysql->getconnection(object(mage_core_model_config_element)) #7 /home/mysite/public_html/app/code/core/mage/core/model/mysql4/abstract.php(297): mage_core_model_resource->getconnection('core_read') #8 /home/mysite/public_html/app/code/core/mage/core/model/mysql4/abstract.php(312): mage_core_model_mysql4_abstract->_getconnection('read') #9 /home/mysite/public_html/app/code/core/mage/core/model/mysql4/abstract.php(332): mage_core_model_mysql4_abstract->_getreadadapter() #10 /home/mysite/public_html/app/code/core/mage/core/model/mysql4/collection/abstract.php(97): mage_core_model_mysql4_abstract->getreadconnection() #11 /home/mysite/public_html/app/code/core/mage/core/model/config.php(1206): mage_core_model_mysql4_collection_abstract->__construct(object(mage_core_model_mysql4_website)) #12 /home/mysite/public_html/app/code/core/mage/core/model/config.php(1239): mage_core_model_config->getmodelinstance('core_mysql4/web...', object(mage_core_model_mysql4_website)) #13 /home/mysite/public_html/app/mage.php(460): mage_core_model_config->getresourcemodelinstance('core/website_co...', object(mage_core_model_mysql4_website)) #14 /home/mysite/public_html/app/code/core/mage/core/model/abstract.php(208): mage::getresourcemodel('core/website_co...', object(mage_core_model_mysql4_website)) #15 /home/mysite/public_html/app/code/core/mage/core/model/abstract.php(213): mage_core_model_abstract->getresourcecollection() #16 /home/mysite/public_html/app/code/core/mage/core/model/app.php(532): mage_core_model_abstract->getcollection() #17 /home/mysite/public_html/app/code/core/mage/core/model/app.php(393): mage_core_model_app->_initstores() #18 /home/mysite/public_html/app/code/core/mage/core/model/app.php(299): mage_core_model_app->_initcurrentstore('', 'store') #19 /home/mysite/public_html/app/mage.php(596): mage_core_model_app->run(array) #20 /home/mysite/public_html/index.php(80): mage::run('', 'store') #21 {main} ";s:3:"url";s:10:"/~mysite/";s:11:"script_name";s:19:"/~mysite/index.php";}

obviously replaced site name above mysite.

thank guys.

this issue can created local.xml .first,check database username ,database name,datauser password..... etc in local.xml (path yourmagentodir/app/etc/)

check there have local.xml.bak.if exits delete local.xml.bak.

check database permission issue database user.

clear cache cache folder (path yourmagentodir/var/cache/)


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more