MySQL Proxy

MySQL Proxy provides possibilities to log and rewrite SQL Querries. As the name suggests, it is used as a proxy between the application and the database. A good Tutorial and further techniques can be found here.

##MySQL Proxy and Enterprise Architect Follow these steps to use MySQL Proxy with Enterprise Architect (Tested with Version 12):

1. Download the latest release of MySQL Proxy and extract the archive.
2. Go into the bin Folder and create a file named code.lua - To get started, insert the following lines:

function read_query(packet)
  if string.byte(packet) == proxy.COM_QUERY then
    print(string.sub(packet, 2))
  end
end

This is a basic logging script that writes all querries to the console output. 3. Launch MySQL-Proxy with the the following command: