I can do this for the backend/frontend machine, but not on the frontend. Basically, I can't get into the mysql prompt for the separate frontend machine. I used the correct host (even just tried 127.0.0.1) with the same mysql/myth database password.
The database is on the backend machine, it is not replicated on the frontend. You can get all the information you need from the prompt that works.