Solved

SELECT command denied to user?

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Importing and exporting data Magento 1.x ? 4 98
How to send multiple emails at the same time in PHP 12 70
two ways encryption with php 3 37
MySQL Query Using Up Memory 6 43
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
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…

792 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