MySQL Forums
Forum List  »  Views

Error Code: 1045. Access denied for user 'user_name'@'host_ip' wher calling view
Posted by: Marco Rios
Date: September 23, 2016 12:16PM

I am calling a view with the following select command:
SELECT * FROM vTarifasHoteles
razon_comercial_rcht LIKE 'Melia Cohiba%'
AND fecha_inicio_fe00 BETWEEN '2016-10-30' AND '2016-11-02'
AND adultos = 2
AND menores_compartiendo = 1

and got the following error message:
Error Code: 1045. Access denied for user 'user_name'@'host_ip'

I am accessing a remote server on a Hosting service from MySQL Workbench, and as user, have all privileges on Database.
I created the view with this same user, but evidently, from a different host_ip, because my ip address is assigned dynamically.
Maybe I need to give user privileges

How can I do to avoid host check when executing views?

Thanks in advance for your valuable help.

Acer LENOVO G450
CPU: Pentium(R) Dual-Core CPU T4400 @ 2.20GHz × 2
Graphics: Intel GM45
OS: UBUNTU 18.04.4 LTS 64bits
GNOME 3.28.2
Best regards
Mexico City, Mexico

Options: ReplyQuote

Written By
Error Code: 1045. Access denied for user 'user_name'@'host_ip' wher calling view
September 23, 2016 12:16PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.