Hello
I have following problem: I created a database from 'user level'. Then, I set new access host to my IP - to this point everything goes well: I can run queries on my new DB. The problem starts when I create a new view (CREATE VIEW myview AS SELECT ...) and then want to use it (SELECT * FROM myview). It fails with an error:
Access denied for user 'my_user_name'@'my_ip' (using
password: YES
So, after adding my IP to access list, I can do anything but not work with views. BUT when I add a wildcard (%) to database access hosts, it works fine. Why is my IP setting being ignored when I want to select from previously created view but it works with wildcard setting?
PS. Database user has all the possible privileges.
I have following problem: I created a database from 'user level'. Then, I set new access host to my IP - to this point everything goes well: I can run queries on my new DB. The problem starts when I create a new view (CREATE VIEW myview AS SELECT ...) and then want to use it (SELECT * FROM myview). It fails with an error:
Access denied for user 'my_user_name'@'my_ip' (using
password: YES
So, after adding my IP to access list, I can do anything but not work with views. BUT when I add a wildcard (%) to database access hosts, it works fine. Why is my IP setting being ignored when I want to select from previously created view but it works with wildcard setting?
PS. Database user has all the possible privileges.
