Squirting pain

I'm 33 and only learned I could squirt 2 yrs ago. It was done by fingers. At the same time I felt like I had serious water infection but nothing came up on tests and I even went to hospital for a scan. Nothing. I then began to realise it came after squirting. I assumed my partner was rubbing on my g-spot too roughly so I stopped him doing it and the pain eventually went away.
Since then it started happening during sex too. I can't stop it happening it just does. And then a short while later my insides start burning and stinging and it can last days.
Anyone else had this problem? There's thing I can do to stop it other than refraining from sex which isn't a great option. Any ideas what I can do to help it?
Obviously a penis rubbing it isn't causing too much friction like fingers may have, but the fluid is very acidic and did used to sting him if he had cuts or grazes (he's a farmer so it's common). It's obviously too acidic for my own body. :/