Permission problem? SELECT command denied to user
Permission problem? SELECT command denied to user
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?
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?
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.
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.