One possible option.
Generally you would use a programming language that includes database support.
For example PHP.
You can added PHP modules for mysql or any database easily.
Then you use apache to host the web page.
After that you have your PHP output HTML (the webpage GUI), and interact with the database in the background.
PHP has frameworks which can ...