Mysql Error Number 1142
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might
Select Command Denied To User ''@'localhost' For Table 'user' Mysql
have Meta Discuss the workings and policies of this site About mysql error 1142 create command denied to user Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads
Mysql Trigger Command Denied To User
with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million mysql workbench sql error 1142 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 a certain query on one of my servers. On all other places I've tested it it works completely fine but error 1142 (42000) 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: 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`
here for a quick overview of the site Help Center Detailed
Select Command Denied To User 'root'@'localhost' For Table 'user'
answers to any questions you might have Meta Discuss mysql error 1142 insert command denied to user the workings and policies of this site About Us Learn more about Stack Overflow the
Select Command Denied To User For Table 'proc'
company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss http://stackoverflow.com/questions/10956195/mysql-error-1142-select-command-denied-to-user 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 User cannot execute select error 1142 up vote 3 down vote favorite My phpmyadmin or MySQL commandline will not let http://stackoverflow.com/questions/10734176/user-cannot-execute-select-error-1142 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, 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
Lost Password? Remember me MyBB Community Forums › Community Archive › Archived Forums › Archived Development and Support › MyBB 1.6 › 1.6 General Support « Previous 1 ... 1500 1501 1502 1503 1504 ... 1701 Next » Solved: [SQL Error: 1142] Thread Rating: https://community.mybb.com/thread-85978.html 0 Vote(s) - 0 Average 1 2 3 4 5 Thread Modes Solved: [SQL Error: 1142] Arka Senior Member Posts: 269 Threads: 54 Joined: Jan 2011 Reputation: 2 #1 01-10-2011, 10:07 AM (This post was last modified: 01-10-2011, 10:46 PM by Arka.) Hi there, hope you can help me. This morning when we try to access the forum we get the following message: Quote:MyBB has experienced an internal SQL error and cannot continue. SQL Error: 1142 - UPDATE command denied command denied to user 'Sql313220'@'62.149.141.166' for table 'users' Query: UPDATE users SET `unreadpms`='0' WHERE uid='6' We have done nothing (that I know of...) and last night everything was just fine. Unfortunately I cannot access the admin control panel as we usually do it from the main page of our forum (meaning that I am not sure of the version of MyBB we are using, but I think it is the latest one) Not sure what other info you might need; at this moment command denied to I can think of nothing else. Thanks for your help. A. Find Yaldaram 1000 Rep+ Point. U Jelly? Posts: 12,864 Threads: 160 Joined: Oct 2010 Reputation: 1,281 #2 01-10-2011, 10:15 AM (This post was last modified: 01-10-2011, 10:16 AM by Yaldaram.) Your MySQL database does not have the privileges to use the command "UPDATE". If you have cPanel, go into your MySQL Database settings and change it. If not, contact your webhost. You may want to check as well that your other privileges are allowed (MyBB also needs 'ALTER' for example) MyBBsmsAPP | MyStatus | ProProfile Website Find Arka Senior Member Posts: 269 Threads: 54 Joined: Jan 2011 Reputation: 2 #3 01-10-2011, 10:21 AM Hem, thanks for your reply, although I am not sure I understand it. For a start, how can I access the panel? I am sure there is a way that is not through the forum, but I don't think I know it... In any case, has this happened because of some sort of automatic update? We've been using this forum for about a year and never had the slightest glitch. Find - G33K - Posting Freak Posts: 2,482 Threads: 38 Joined: Mar 2009 Reputation: 172 #4 01-10-2011, 10:24 AM If you didn't do anything then it seems your host has edited the permissions of your mysql user and denied them the update command. Contact your host and ask them to check the privileges of your mysql use