Cannot select from new view in MySQL (can select from everything else)

Question

I am a newbie to MySQL, being more accustomed to MSSQL. However, we have recently purchased the LabTech management software, which uses a MySQL back end. While writing a custom report to keep track of the status of the network, I added a new view. The new view works just fine when executed as root, but when running it as a user I get:

Error Code: 1142 SELECT command denied to user 'username'@'remote_address' for table 'new_view'

I am using MySQL Workbench to administer the database and I cannot see anywhere to view the permissions of the view. I have tried

GRANT SELECT ON labtech.new_view TO 'username'@'localhost'; flush privileges;

but that has not helped. What am I missing?

Answer 1

Make sure that you recognize that mysql recognizes the address as part of the username.