Fix: mysql: Revert changes to default pidfile detection.

We can't determine anything about the default location of the
mysqld pid file from a directroy in the /var/run directory. This
logic did not need to be introduced in the first place.