Well, I am migrating a zend application from localhost to hosting. I have copied application form another server which was running successfully, but some issue with old server so i need to move...i have configured zend application on my local system and its working perfectly. the PHP version is 5.5.15. When i move the application to new server (PHP version 5.5.18). I am getting error:-
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'user'@'localhost' for table 'page'' in /home/spreadca/public_html/library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /home/spreadca/public_html/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /home/spreadca/public_html/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #2 /home/spreadca/public_html/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/spreadca/public_html/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBE
sprea...', Array) #4 /home/spreadca/public_html/library/Zend/Db/Adapter/Pdo/Mysql.php(171): Zend_Db_Adapter_Pdo_Abstract->query('DESCRIBE
sprea...') #5 /home/spreadca/public_html/library/Zend/Db/Table/Abstract.php(836): Zend_Db_Adapter_Pdo_Mysql->describeTable('page', 'spreadcashback_...')...
I have given mysql user full permission. i have also tried with custom mysql php script to run select query from this user. and its working fine. Changed many PHP version into 5.3 to 5.5 to check. Same application is working fine with my localhost in 5.5.15 PHP version.
When i have copied application from old server there was no Zend folder into library. so i have installed Zend 1.12.9 and copy there's Zend folder into application. It is working like charm in localhost. I dont know why it is happening i have so many time in stackoverflow to resolve my issue. As i am newbie in Zend.
Thanks in Advance guys. Looking for your answers very desperately.
Edit:
The application is working fine in my localhost (PHP version 5.5.15, OS:- Win7) And my webhosting is linux. Is there any issue with OS in Zend.