Solved

SELECT command denied to user?

Posted on 2008-10-07
1
746 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

740 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