I see there is a mock mysql functionality out of the box from mysql installation and it is documented here
It involves, setting up a mock tcp port with binary called ./mysql_server_mock but I couldn't find this in my installation. I installed MySQL 8.0.30 (Windows) and also the MySQL Router but couldn't find this binary. Are there are any other easy way, where a MySQL client sends a request, we in local machines intercept that request and respond with some other results? (Similar to Burp for Web, all locally)