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

Hello,
I am calling a view with the following select command:
SELECT * FROM vTarifasHoteles
WHERE
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
RAM: 4GB
Graphics: Intel GM45
OS: UBUNTU 18.04.4 LTS 64bits
GNOME 3.28.2
--
Best regards
Marco
Mexico City, Mexico

Options: ReplyQuote


Subject
Views
Written By
Posted
Error Code: 1045. Access denied for user 'user_name'@'host_ip' wher calling view
2515
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.