问题描述

我在我的一台服务器上遇到了某个查询的问题.在我测试过的所有其他地方，它完全正常，但在我想使用的服务器上，它不起作用.

I'm having troubles with a certain query on one of my servers. On all other places I've tested it it works completely fine but on the server i want to use it it isn't working.

关于以下 SQL:

SELECT facturen.id            AS fid, 
       projecten.id           AS pid, 
       titel, 
       facturen.totaal_bedrag AS totaal, 
       betaald, 
       datum 
FROM   facturen, 
       projecten 
WHERE  facturen.project_id = projecten.id 
       AND projecten.eigenaar = '1' 
ORDER  BY datum DESC 

这是我从中得到的错误代码:

This is the error code I get from it:

SELECT 命令拒绝用户 'marco'@'localhost' 用于表 'projecten'

表格:制作:

CREATE TABLE IF NOT EXISTS `facturen` (
  `id` int(11) NOT NULL auto_increment,
  `project_id` int(11) NOT NULL,
  `datum` int(11) NOT NULL,
  `lever_datum` int(11) NOT NULL,
  `totaal_bedrag` decimal(9,2) NOT NULL,
  `btw` decimal(9,2) NOT NULL,
  `bedrijf` varchar(40) NOT NULL,
  `contactpersoon` varchar(60) NOT NULL,
  `adres` varchar(60) NOT NULL,
  `postcode` varchar(7) NOT NULL,
  `plaats` varchar(30) NOT NULL,
  `betaald` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=201200006 ;

投影:

CREATE TABLE IF NOT EXISTS `projecten` (
  `id` int(11) NOT NULL auto_increment,
  `titel` varchar(80) NOT NULL,
  `eigenaar` int(11) NOT NULL,
  `creatie_datum` int(11) NOT NULL,
  `eind_datum` int(11) NOT NULL,
  `totaal_bedrag` decimal(9,2) NOT NULL,
  `btw` decimal(9,2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=201200004 ;

奇怪的是，'projecten' 表和 'facturen' 表上的所有其他查询都完全正常，这个查询在我的另外两台服务器上也能正常运行.

The strange part is that every other query on both the 'projecten' table and the 'facturen' table works completely fine, also this query works fine on two other servers of mine.

推荐答案

我遇到了同样的情况，但有趣的是，错误的原因是由于使用了不正确的数据库或架构名称.

I faced the same situation but its funny that reason for the error was due to the use of the incorrect database or schema name.

确实有多个问题会导致您提到的错误.

Its true that multiple issues can lead to error you have mentioned.

这篇关于MySQL 错误:#1142 - 拒绝用户的 SELECT 命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！