Debugging of MySQL stored procedures

I ran into problem earlier today with an SP. I had no clue how to find out what was wrong. I started to search for some debugger for MySQL's SPs, but found ones for a Windows only. Then I found following post. I found it most helpful: http://gilfster.blogspot.com/2006/03/debugging-stored-procedures-in-mysql.html