MySQL Forums
Forum List  »  Router & Proxy

Re: login problem
Posted by: Mark Leith
Date: July 27, 2012 04:33AM

When you log in via Proxy, the host defined for the user should match the host that MySQL Proxy is on - because from the MySQL server's perspective, the log in is coming via Proxy.

That is, if you have Proxy on '192.169.1.10', and connect from a host '192.168.1.50', as the user 'bob', you will need credentials on the MySQL server for the proxy host, rather than the originating host:

GRANT ... TO 'bob'@'192.168.1.10' ...;

Best regards,

Mark

--
Mark Leith
Senior Software Development Manager
MySQL Enterprise Tools @ Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
3641
July 26, 2012 05:28PM
2027
July 26, 2012 05:29PM
Re: login problem
2345
July 27, 2012 04:33AM
2174
July 27, 2012 11:30AM


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.