Mysql: Stored procedures vs. inline SQL?

Question

We are evaluating whether we should write stored procedure OR write inline queries. I read this link to get an opinion.

I want to know pros and cons from mysql perspective as the above question is for sql-server.