I did the following, as a test its working,
I installed socat,
I have hapoxy configured on my server which is then proxy to a AWS Aurora serverless db.
socat UNIX-LISTEN:/var/lib/mysql/mysql.sock,reuseaddr,fork,unlink-early,mode=777,su=nobody,user=mysql,group=mysql tcp4:localhost:3306