Local development environment for … Python?

It's time to re-use my web design skills and I need some help to get started.

In the past, I used XAMPP (since I'm in Windows) for PHP, MySQL, HTML, CSS, etc.

Being that I can start with a clean slate, Python seems an interesting avenue, combined with HTML5, CSS3 and JavaScript.

But is it really? If MySQL is for PHP, what exactly is … for Python? Can XAMPP be used with Python? If not, what local server environment would allow you to work with Python? And, by the way, the reason I find interesting for Python for the development of future applications. I heard that Python variations can be used to create applications for mobile devices after the code has been compiled.

As you can see, I'm floating. Any help is appreciated.