Error: select command denied to user '<userid>'@'<ip-address>' for table '<table-name>'

MysqlMysqldatareaderMysql Error-1142

Mysql Problem Overview

In my website, I am using MySQL database. I am using a webservice where in I do all my database related manipulations.

Now In one of the methods of that webservice, I get the following Error.

> select command denied to user '<userid>'@'<ip-address>' for table '<table-name>'

What could be wrong?

Below is the code where I get that error. I tried debugging and found that it fails at the line

MySqlDataReader result1 = command1.ExecuteReader();

Here is my code:

        String addSQL = "Select Max(`TradeID`) from `jsontest`.`tbl_Positions";
        MySqlConnection objMyCon = new MySqlConnection(strProvider);
        MySqlCommand command = objMyCon.CreateCommand();

        command.CommandText = addSQL;
         MySqlDataReader result = command.ExecuteReader();
        //int j = command.ExecuteNonQuery();
         while (result.Read())
             MaxTradeID = Convert.ToInt32(result[0]);
        for (i = 1; i <= MaxTradeID; i++)
            String newSQL = "Select `Strike`,`LongShort`,`Current`,`TPLevel`,`SLLevel` from `json`.`tbl_Position` where `TradeID` = '" + i + "'";
            MySqlConnection objMyCon1 = new MySqlConnection(strProvider);
            MySqlCommand command1 = objMyCon1.CreateCommand();

            command1.CommandText = newSQL;
            MySqlDataReader result1 = command1.ExecuteReader();

Mysql Solutions

Solution 1 - Mysql

I'm sure the original poster's issue has long since been resolved. However, I had this same issue, so I thought I'd explain what was causing this problem for me.

I was doing a union query with two tables -- 'foo' and 'foo_bar'. However, in my SQL statement, I had a typo: ''

So, instead of telling me that the '' table doesn't exist, the error message indicates that the command was denied -- as though I don't have permissions.

Hope this helps someone.

Solution 2 - Mysql

database user does not have the permission to do select query.

you can grant the permission to the user if you have root access to mysql

Your second query is on different database on different table.

 String newSQL = "Select `Strike`,`LongShort`,`Current`,`TPLevel`,`SLLevel` from `json`.`tbl_Position` where `TradeID` = '" + i + "'";

And the user you are connecting with does not have permission to access data from this database or this particular table.

Have you consider this thing?

Solution 3 - Mysql

> select command denied to user ''@'' for table ''

This problem is a basically generated after join condition are wrong database name in your join query. So please check the your select query in join table name after database.

Then solve it for example its correct ans ware

string g = " SELECT `emptable`.`image` , `applyleave`.`id` , `applyleave`.`empid` , `applyleave`.`empname` , `applyleave`.`dateapply` , `applyleave`.`leavename` , `applyleave`.`fromdate` , `applyleave`.`todate` , `applyleave`.`resion` , `applyleave`.`contact` , `applyleave`.`leavestatus` , `applyleave`.`username` , `applyleave`.`noday` FROM `DataEMP_ems`.`applyleave` INNER JOIN `DataEMP_ems`.`emptable` ON ( `applyleave`.`empid` = `emptable`.`empid` ) WHERE ( `applyleave`.`leavestatus` = 'panding' ) ";

The join table is imputable and applyleave on the same database but online database name is diffrent then given error on this problem.

Solution 4 - Mysql

This problem happened to me because I had the hibernate.default_schema set to a different database than the one in the DataSource.

Being strict on my mysql user permissions, when hibernate tried to query a table it queried the one in the hibernate.default_schema database for which the user had no permissions.

Its unfortunate that mysql does not correctly specify the database in this error message, as that would've cleared things up straight away.

Solution 5 - Mysql

You need to grant SELECT permissions to the MySQL user who is connecting to MySQL. See:

Solution 6 - Mysql

I had the exact same error message doing a database export via Sequel Pro on a mac. I was the root user so i knew it wasn't permissions. Then i tried it with mysqldump and got a different error message: Got error: 1449: The user specified as a definer ('joey'@'') does not exist when using LOCK TABLES

Ahh, I had restored this database from a backup on the dev site and I hadn't created that user on this machine. "grant all on . to 'joey'@'' identified by 'joeypass'; " did the trick.


Solution 7 - Mysql

If you are working from a windows forms application this worked for me

"server=localhost; user id=dbuser; password=password; database=dbname; Use Procedure Bodies=false;"

Just add the "Use Procedure Bodies=false" at the end of your connection string.

Solution 8 - Mysql

For me, I accidentally included my local database name inside the SQL query, hence the access denied issue came up when I deployed.

I removed the database name from the SQL query and it got fixed.

Solution 9 - Mysql

The problem is most probably between a . and a _. Say in my query I put


instead of


So I think MySQL would think LOCATION as a database name and was giving access privilege error.

Solution 10 - Mysql

I had the same problem. This is related to hibernate. I changed the database from dev to production in hibernate.cfg.xml but there were catalog attribute in other hbm.xml files with the old database name and it was causing the issue.

Instead of telling incorrect database name, it showed Permission denied error.

So make sure to change the database name everywhere or just remove the catalog attribute

Solution 11 - Mysql


  • Backup first.
  • Check your query sentence before executing.
  • Make sure you've added a WHERE (filter) clause before updating.

In case you have root access or enough privileges, you can do the following directly:

Log into your MySQL as root,

$ mysql -u root -p

Show databases;


Select MySQL database, which is where all privileges info is located

mysql>USE mysql;

Show tables.


The table concerning privileges for your case is 'db', so let's see what columns it has:

mysql>DESC db;

In order to list the users' privileges, type the following command, for example:

mysql>SELECT user, host, db, Select_priv, Insert_priv, Update_priv, Delete_priv FROM db ORDER BY user, db;

If you can't find that user or if you see that that user has a 'N' in the Select_priv column, then you have to either INSERT or UPDATE accordingly:


INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv) VALUES ('localhost','DBname','UserName','Y' ,'N','N','N');


UPDATE db SET Select_priv = 'Y' WHERE User = 'UserName' AND Db = 'DBname' AND Host='localhost';

Finally, type the following command:



Solution 12 - Mysql

my issues got fixed after upgrading to MySQL workbench latest version 8.0.18

Solution 13 - Mysql

try grant privileges again.

GRANT ALL PRIVILEGES ON the_database.* TO 'the_user'@'%' WITH GRANT OPTION;

Solution 14 - Mysql

I had the same problem. I was very frustrating with it. Maybe this is not answering the question, but I just want to share my error experience, and there may be others who suffered like me. Evidently it was just my low accuracy.

I had this:

SELECT t_comment.username, FROM t_comment
	SELECT username,email FROM t_un
) a
ON t_comment.username,

which is supposed to be like this:

SELECT t_comment.username, FROM t_comment
	SELECT username,email FROM t_un
) a
ON t_comment.username=a.username

Then my problem was resolved on that day, I'd been struggled in two hours, just for this issue.

Solution 15 - Mysql

I am sure this has been resolved, just want to point out I had a typo in the database name and it was still throwing this error on the table name. So you might want to check for typos in this case.

Solution 16 - Mysql

Similar to other answers I had miss typed the query.

I had -

SELECT FROM t.table LEFT JOIN table2 AS t2 ON = t2.table_id

Should have been

SELECT FROM table AS t LEFT JOIN table2 AS t2 ON = t2.table_id

Mysql was trying to find a database called t which the user didn't have permission for.


All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionParth BhattView Question on Stackoverflow
Solution 1 - Mysqlpisces22View Answer on Stackoverflow
Solution 2 - MysqlShakti SinghView Answer on Stackoverflow
Solution 3 - MysqlMukesh kumarView Answer on Stackoverflow
Solution 4 - MysqlmuttonUpView Answer on Stackoverflow
Solution 5 - MysqlgregjorView Answer on Stackoverflow
Solution 6 - MysqlsuperaesomedadView Answer on Stackoverflow
Solution 7 - MysqlU. BustoView Answer on Stackoverflow
Solution 8 - Mysqlsajin tmView Answer on Stackoverflow
Solution 9 - MysqlRezaView Answer on Stackoverflow
Solution 10 - MysqldeepikaView Answer on Stackoverflow
Solution 11 - MysqlPathrosView Answer on Stackoverflow
Solution 12 - MysqlNarayan PView Answer on Stackoverflow
Solution 13 - MysqlMárcio RossatoView Answer on Stackoverflow
Solution 14 - MysqlJuna serbaserbiView Answer on Stackoverflow
Solution 15 - MysqlPeggyView Answer on Stackoverflow
Solution 16 - MysqlsebtucknottView Answer on Stackoverflow