How to connect & query MySQL from within Lua?

How can I connect to a MySQL database from using Lua programming language?

If a good/popular library exists, what is it?