service mysql stop is being ignored. How to fix?

Hi. In general it depends on the way you have started mysql process.
If you have started mysql as

then

should help you to stop it.
In case you have started

So in this case you should stop bootstrapped node using