/ProxyServer

Primary LanguageC#

ProxyServer

A proxy server for MySQL.

Prerequisites

MySQL Docker Container

Image (latest): https://hub.docker.com/_/mysql

Configuration

docker run --rm --network host --name mysql -e MYSQL_ROOT_PASSWORD=foobar mysql:latest --authentication-policy="*,,"

Start

Server

dotnet run --project MySqlProxyServer

Client

Mysql Console

mysql --ssl-mode=DISABLED --default-auth=mysql_native_password --host=127.0.0.1 --port=8080 --user=<any username> --password=<any password>

Features

Login & Query

image

Login with any account

Only works if the auth method is mysql_native_password.

image

Multiconnections

image

Reject Query if contains CHEQUER

image

Logging

Log files are located at MySqlProxyServer/bin/Debug/net5.0/logs.

Format of the log file name is: YY-MM-DD.

image

Random Masking

Simply put RANDOM_MASK at the end of your query.

SELECT user from mysql.user RANDOM_MASK;

image

Limitations

  • Currently only mysql_native_password authentication is supported.

  • Graceful exit on socket is not implemented.

Known Issues

  • Socket is not released when socket connection finishes.