0

As we know mysql-proxy can be used as make a proxy address for MySQL server and also to change any query or results using lua script.

My question is how can I make the proxy address as the ONLY point of access to MySQL server and so if a client tries to communicate with server directly gets a ACCESS DENIED. i.e

authentication fail if direct access and success if through proxy.

Is it possible to do so only using MYSQL server and mysql-proxy or I MUST go for some third part software?

Thank You

Majid NK
  • 311
  • 1
  • 3
  • 16
  • 1
    Simply by using a firewall before the MySQL server or by using the internal permission handling in that server. – arkascha Nov 04 '16 at 09:54
  • 1
    Put mysql=proxy on a server and only allow user access from that ip – Mihai Nov 04 '16 at 09:55
  • Thanks, Both are good ideas but that will be applicable to all, I don't' want all users get this access denied. for example I want admin to have direct access to MySQL at all the time from any place and other users get access denied if query rather than proxy. – Majid NK Nov 04 '16 at 10:03

0 Answers0