How do I display a newline in a mysql prompt?

Question

I'm trying to make my mysql prompt look like this:

root@localhost:3306 database
$ [mysql commands…]

How might I place the dollar sign on a newline? Here's my current prompt configuration, in which the '\n' seems to be broken:

prompt = '\u@\h:\p\s\d\n$\s'