Magento Forum

   
Admin panel access denial
 
logeevaghela
Jr. Member
 
Total Posts:  2
Joined:  2013-02-19
 

Hello All,

When I am trying to access admin panel of occtrade : http://www.occtrade.co.uk/index.php/site_admin

its giving me below error:

SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user ‘xxxxxxxxxxx’@’ggg.hhh.www.uu’ for table ‘adminnotification_inbox’

Image Attachments
Error.png
 
Magento Community Magento Community
Magento Community
Magento Community
 
Rich Cleverley
Moderator
 
Avatar
Total Posts:  283
Joined:  2009-01-20
 

It’s a MySql permissions issue.  Check that user that is mentioned has the correct DB permissions on your DB.

Also, it may be a good idea to edit your post and remove your DB user and IP address from it fro security reasons.

 
Magento Community Magento Community
Magento Community
Magento Community
 
logeevaghela
Jr. Member
 
Total Posts:  2
Joined:  2013-02-19
 

Thank you so much for your advice. Can you please post me the steps to change the DB permission? I am using 1&1;servers. I called them up and they replied that this problem is due to I have exceeded limit of my usage and I am using shared database. I need dedicated server for the same. Can you please give me some advice on it.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Rich Cleverley
Moderator
 
Avatar
Total Posts:  283
Joined:  2009-01-20
 

Hmm, so that sound like 1&1;have limited your account then.  Magento shouldn’t really be run on shared hosting, it’s just far too resource intensive.  You either need to look at a dedicated server or at teh very least a VPS.  I use Webfusion which is fine for my needs if that’s any help. http://www.webfusion.co.uk/virtual-private-servers/

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top