Error Code 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 site About Us Learn more about Stack Overflow the
Mysql Error 1142 Create Command Denied To User
company Business Learn more about hiring developers or posting ads with us Stack Overflow select command denied to user ''@'localhost' for table 'user' mysql Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7
Error 1142 (42000)
million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL Error: #1142 - SELECT command denied to user up vote 13 down vote favorite 3 I'm having troubles with select command denied to user 'root'@'localhost' for table 'user' 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 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: mysql trigger command denied to user 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 question edited Jun 8 '12 at 21:30 asked Jun 8 '12 at 21:22 Seph 1371111 what is bt2 in bt2.projecten ? –Raphaël Althaus Jun 8 '12 at 21:25 privilege problem? –khaled_webdev Jun 8 '12 at 21:30 A typo of mine from mine since I copied it to here from my
here for a quick overview of the site Help Center Detailed answers to any questions you might have
Mysql Error 1142 Insert Command Denied To User
Meta Discuss the workings and policies of this site About Us select command denied to user for table 'proc' Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with
Error 1142 Junos Pulse
us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, http://stackoverflow.com/questions/10956195/mysql-error-1142-select-command-denied-to-user just like you, helping each other. Join them; it only takes a minute: Sign up User cannot execute select error 1142 up vote 3 down vote favorite My phpmyadmin or MySQL commandline will not let me execute the following query: SELECT customer.First, customer.Last, login.Username, login.Password, customer.Addrln1, customer.Addrln2, customer.Postcode, customer.County, customer.Country, customer.Phone, customer.Email, employee.EmpFirst, employee.EmpEmail, move.MoveID, move.CityOrig, http://stackoverflow.com/questions/10734176/user-cannot-execute-select-error-1142 move.CityDest, move.CountryOrig, move.CountryDest, move.EnquiryDate, move.Surveydate, move.QuoteDate, move.DepEst, move.DepAct, move.ArrEst, move.ArrAct, move.ClearEst, move.ClearAct, move.DelEst, move.DelAct, move.Port, move.Method, move.Status FROM customer LEFT JOIN oim2.login ON customer.CustID = login.CustID LEFT JOIN oim2.move ON customer.CustID = move.CustID LEFT JOIN oim2.employee ON move.EmpID = employee.EmpID WHERE customer.First = 'dave' and customer.Last='smith' 1142 - SELECT command denied to user 'oceanai3'@'localhost' for table 'login' Dave smith is just an example first and last name, the user can perform the following queries: SELECT * from login SELECT * FROM move SELECT * FROM customer If I remove the references to login out of the original query I then get the error #1142 - SELECT command denied to user 'oceanai3'@'localhost' for table 'move'. I have pastebin'd the full sql file of the db and it can be found here at: http://pastebin.com/H6aTS74m I have trawled through a lot of other peoples posts to find an answer but I couldnt find anything that helped me. Thanks C mysql phpmyadmin share|improve this question asked May 24 '12
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Triggers http://forums.mysql.com/read.php?99,597525,597525 :: ERROR 1142 (42000): TRIGGER command denied to user New Topic Advanced Search ERROR 1142 (42000): TRIGGER command denied to user Posted https://forums.phplist.com/viewtopic.php?f=34&t=39501 by: Alex Matthews () Date: October 15, 2013 05:14AM I am unable to create triggers using any user other than root. I command denied 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 the root user it works... create trigger trg1 before insert on members for command denied to 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, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `ucac_joomla_v2` .* TO 'ucac_joomla_v2'@'localhost' WITH GRANT OPTION | +----------------------------------------------------------------------
does not exist. Board index The team • Delete all board cookies • All times are UTC Quick Links Anti-spam Policy Terms & Conditions Privacy Policy Resources Forums Documentation Contact Us e: info@phplist.com Twitter RSS Boring Bit phpList is a registered limited company UK Company No. 07582966 VAT Registration 122 0788 37 © phpList 2013 Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group The phpList forums are now closed, and only available for reference. Discussion continues at discuss.phplist.org