mysql 1142,mysql-用户无法执行选择错误1142

我的phpmyadmin或MySQL命令行不允许我执行以下查询：

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-表’login’的用户’oceanai3’@’localhost’的SELECT命令被拒绝

Dave smith是名字和姓氏的示例,用户可以执行以下查询：

选择*从登录

选择*从移动

选择*来自客户

如果我从原始查询中删除要登录的引用,则会收到错误#1142-表’move’的用户’oceanai3’@’localhost’的SELECT命令被拒绝.我已经粘贴了数据库的完整sql文件,可以在这里找到它：http://pastebin.com/H6aTS74m

我已经浏览了很多其他人的帖子以找到答案,但是我找不到任何可以帮助我的东西.

谢谢

C

解决方法:

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

用您的值替换占位符.

标签：phpmyadmin,mysql

来源： https://codeday.me/bug/20191101/1982524.html