Mysql Error No 1142
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this select command denied to user ''@'localhost' for table 'user' mysql site About Us Learn more about Stack Overflow the company Business Learn
Mysql Error 1142 Create Command Denied To User
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question mysql workbench sql error 1142 x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL mysql trigger command denied to user Error: #1142 - SELECT command denied to user up vote 13 down vote favorite 3 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. It's about the following SQL: SELECT facturen.id AS fid, projecten.id AS pid, titel, facturen.totaal_bedrag
Error 1142 (42000)
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 command denied to user 'marco'@'localhost' for table 'projecten' The tables: facturen: 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 ; projecten: 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 ; 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. mysql select command denied share|improve this qu
Community Podcasts MySQL.com Downloads Documentation Section Menu: select command denied to user 'root'@'localhost' for table 'user' MySQL Forums :: Triggers :: ERROR 1142 (42000): select command denied to user for table 'proc' TRIGGER command denied to user New Topic Advanced Search ERROR 1142 (42000):
Mysql Error 1142 Insert Command Denied To User
TRIGGER command denied to user Posted by: Alex Matthews () Date: October 15, 2013 05:14AM I am unable to create http://stackoverflow.com/questions/10956195/mysql-error-1142-select-command-denied-to-user triggers using any user other than root. I have attempted to enable all privileges both via Navicat and via the MySQL command line. I've even gone as far as enabling table specific privileges. When I try the following command using http://forums.mysql.com/read.php?99,597525,597525 the root user it works... create trigger trg1 before insert on members for each row set @a:=memberid.a; ... but using another user, with 'SUPER' set, I get the following error: - ERROR 1142 (42000): TRIGGER command denied to user 'ucac_joomla_v2'@'localhost' for table 'members' I am using a local database installed on Windows 7. *****MYSQL VERSION****** Server version: 5.5.13 MySQL Community Server (GPL) *****SHOW GRANTS FOR USER****** mysql> SHOW GRANTS FOR 'ucac_joomla_v2'@'localhost'; +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------+ | Grants for ucac_joomla_v2@localhost | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------+ | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'ucac_joomla_v2'@'localhost' IDENTIFIED BY PASSWOR D '*20A2A8935ED57D3B66D540F0937F952A5BD87C76' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENC
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: Error No. 1142 - Create http://forums.mysql.com/read.php?11,90689,96031 command denied New Topic Advanced Search Re: Error No. 1142 - Create command denied Posted by: Bob Field () Date: June 13, 2006 08:39AM What GRANT command did you execute? What do you see when you do SHOW GRANTS? Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted Error No. 1142 - Create command denied command denied Picco Morton 05/18/2006 07:53AM Re: Error No. 1142 - Create command denied Francisco Maleitas 06/13/2006 07:51AM Re: Error No. 1142 - Create command denied Nguyen Phuc 11/27/2007 08:40PM Re: Error No. 1142 - Create command denied Bob Field 06/13/2006 08:39AM Sorry, you can't reply to this topic. It has been closed. command denied to powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Partners Job Opportunities Site Map Documentation MySQL Reference Manuals MySQL Workbench Expert Guides Topic Guides MySQL Cluster Legal Legal Policies Your Privacy Rights Terms of Use Trademark Policy Contributor Agreement © 2015, Oracle Corporation and/or its affiliates