1142 - SELEC 中 CT command denied to user oceanai3 @ localhost for table login

Question

我的phpmyadmin 或 MySQL 命令不让我执行以下查询 :

SELEC 中 CT customer.First, customer.Last, login.Username, login.Password, customer.Addrln1,
    customer.Addrln2, customer.Postcode, customer.C 中 County, customer.C 中 Country, customer.Phone, customer.Email, 
    employee.EmpFirst, employee.EmpEmail, move.MoveID, move.C 中 CityOrig, move.C 中 CityDest, move.C 中 CountryOrig, 
    move.C 中 CountryDest, move.EnquiryDate, move.Surveydate, move.QuoteDate, move.DepEst, move.DepAct, move.ArrEst, move.ArrAct,
    move.C 中 ClearEst, move.C 中 ClearAct, move.DelEst, move.DelAct, move.Port, move.Method, move.Status
FROM customer
LEFT JOIN oim2.login ON customer.C 中 CustID = login.C 中 CustID
LEFT JOIN oim2.move ON customer.C 中 CustID = move.C 中 CustID
LEFT JOIN oim2.employee ON move.EmpID = employee.EmpID
WHERE customer.First =   dave  and customer.Last= smith

1142 - SELEC 中 CT 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: SELEC 中 CT * from login SELEC 中 CT * FROM move SELEC 中 CT * FROM customer

If I remove the references to login out of the original query I then get the error #1142 - SELEC 中 CT 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.

谢谢谢谢

C 中 C

Answer 1

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

用您的值替换占位符。

Answer 2

我想,也许吉文斯张贴:

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

may 需要用户周围的单引号, 如 :

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

至少对我有用,但我用了phpMyAdmin 3.5.2.2.2。不过,如果这能帮助某人,那才是最重要的:

1142 - SELEC 中 CT command denied to user oceanai3 @ localhost for table login

友情链接