Devart Forums

I am getting an error message when trying to perform a select query from server A running ASP.NET and server B running mysql. What is strange is that it mentioned username@localhost which is not the user for this database connection.

SELECT command denied to user 'username'@'localhost' for table 'tablename'

I have insured that this user has been granted all permissions on this database from any host and I have been able to run a mysql client on server A and perform the select query without an issue. This error only appears when the query is performed through the corelabs driver.

Any thoughts?

Where is MySQL database and where do you run SELECT query from?

Sorry I was not more specific. The query is being run from server A (ASP.NET) and the mysql server is running on server B. I am able to run 'mysql' on server A and connect to the mysql on server B using the same credentials as the ASP.NET application and perform the select query without issue. However the same query when run through the core labs driver results in a permision denied error.

Judging from the error message, i think that you try to connect to MySQL Server on server A (localhost). Check your connection string in ASP.NET application.
What is the table mentioned as 'tablename'?

I have verified the ASP.NET application is connecting to the mysql server on B by shutting down the server and refreshing the page that generates the error. The erorr message changes from a permissions error to a 'can not connect' error. In addition on the ASP.NET server a mysql server does not run.

What query are you trying to execute? And what is "tablename"?

I apologize for not following up sooner. We have decided to go with another solution and have no need to resolve this problem. Thanks for the assistance thus far.

Not at all.