Geek asks and answers

User cannot execute selection error 1142

My phpmyadmin or MySQL command line does not allow me to 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 for user 'oceanai3' @ 'localhost' for table 'login'

Dave Smith is just an example of the first and last name, the user can perform the following queries: SELECT * on behalf of the user SELECT * FROM move SELECT * FROM customer

If I remove the login links from the original query, I get error message # 1142 - the SELECT command is forbidden for the user 'oceanai3' @ 'localhost' for the table 'move'. I have a complete sql db file and can be found here: http://pastebin.com/H6aTS74m I made my way through many other people to find the answer, but I could not find anything that helped me.

thank

WITH

+3
source share
2 answers
GRANT SELECT ON database.* TO user@'localhost' IDENTIFIED BY 'password';

Replace the placeholders with your values.

+4
source

I think maybe Jivings publication:

GRANT SELECT ON database.* TO user@'localhost' IDENTIFIED BY 'password';

You may need a single quote around the user, for example:

GRANT SELECT ON database.* TO 'user'@'localhost' IDENTIFIED BY 'password';

This worked the least for me, but I am using phpMyAdmin 3.5.2.2. However, if this can help someone, all that matters :)

0

More articles:


All Articles