MySQL 错误:#1142 - SELECT 命令拒绝用户 [英] MySQL Error: #1142 - SELECT command denied to user

问题描述

我的一台服务器上的某个查询出现问题.在我测试过的所有其他地方它工作得很好，但在我想使用它的服务器上它不工作.

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 命令拒绝用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！