Racket can probably do everything you want (i.e. serve as its own 'LAMP stack').

Clojure with whatever the standard libraries are nowadays is easy to get setup and running.

I'm sure there's a common Common Lisp set of libraries for web apps too.

And there's a variety of smaller Lisp projects for various other runtime environments, e.g. various Lisp-to-JavaScript transpilers that you could run on top of Node.js.

> Racket can probably do everything you want (i.e. serve as its own 'LAMP stack').

Here's a quick tutorial on web applications in Racket: https://docs.racket-lang.org/web-server/index.html

Here's a run through a simple Clojure web app http://www.luminusweb.net/docs

and here is some documentation on deployment http://www.luminusweb.net/docs/deployment.html

To add to this, I have found the source code of 'grumpy.website' a nice example project: https://github.com/tonsky/grumpy

For Common Lisp you have a lot of options. I think https://lisp-journey.gitlab.io/web-dev/ serves as a good overview of entry points for them. There's also a short and relatively recent pay-what-you-want ebook available that might be useful: https://leanpub.com/lispweb (And while I'm at it I appreciated this ebook https://www.darkchestnut.com/book-common-lisp-application-de... for its relevance to the professional programmer who is used to how things are done in JavaLand; it also briefly covers server-side app development and deployment)

The closest to literally LAMP would just be LAML. Configure Apache to reverse-proxy to your Lisp application running its own web server (Hunchentoot is a popular base choice to get up and running) on some local port and use CLSQL to talk to MySQL.