Solved

SELECT command denied to user?

Posted on 2008-10-07
1
741 Views
Last Modified: 2012-05-05
can someone please help i don't know that much about mysql server and this problem is driving me mad....

I am using a free CMS system and when i try to add a new page or a new comment etc i get the following error:
SELECT command denied to user 'savaega1e1'@'ICSERVER-cf1.lnc.net' for table 'tables'

now i have emailed the CMS company and they have stated that they dont have a table called 'tables' (which i have checked and they dont) and the version i am using is stable so it must be something to do with my permissions, it has nothing to do with the CMS. ok so its a mysql issues then....

I have my own dedicated server, but use a remote database server from my hosting company, i have never had permission issues before. why would the error be asking for a table which does not exist nor does the code ask for?

no one can give me the answer or fix this issue here, even our database host say i have remote permissions and all should work.

Thanks
0
Comment
Question by:pigmentarts
1 Comment
 
LVL 50

Accepted Solution

by:
Steve Bink earned 500 total points
ID: 22665853
>>> they have stated that they dont have a table called 'tables'

The better question is what is causing your app to access table 'tables'.  If the CMS does not include or use it, you need to find out what is.

In the meantime, use 'SHOW GRANTS' to see what users and permissions have been set up.  You can use the same syntax to add grants for a specific user/host.  See here for the full syntax:

http://dev.mysql.com/doc/refman/5.1/en/grant.html
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Creating and Managing Databases with phpMyAdmin in cPanel.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now