Jump to content

Access denied on sql query


otuatail

Recommended Posts

SELECT EntryDate, Input, Output, Comment, Tag, Bank_Reason.Reason AS Reason
FROM Bank_Data.Reason INNER JOIN Bank_Reason.ReasonID
WHERE Tag = '55ad7d70397665cdf6bd175bcf55eda83d45feb96';

#1142 - SELECT command denied to user 'otookr692'@'10.3.4.92' for table 'Reason'

DROP TABLE IF EXISTS `Bank_Data`;
CREATE TABLE IF NOT EXISTS `Bank_Data` (
  `EntryDate` date DEFAULT NULL,
  `Input` decimal(6,2) NOT NULL DEFAULT '0.00',
  `Output` decimal(6,2) NOT NULL DEFAULT '0.00',
  `Reason` tinyint(1) NOT NULL DEFAULT '0',
  `Comment` varchar(32) NOT NULL DEFAULT '',
  `Tag` varchar(45) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `Bank_Reason`;
CREATE TABLE IF NOT EXISTS `Bank_Reason` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ReasonID` tinyint(1),
  `Reason` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

I have 2 table Bank_Data and Bank_Reason. I can do a select on both in phpmyadmin.

 

The following query fails with a kind of access denied statement

 

 

 

 

Link to comment
https://forums.phpfreaks.com/topic/297417-access-denied-on-sql-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.