You will need to use more than MySQL to display on web pages (PHP + MySQL, for example).

The easiest way will be to install easyPHP. This program includes all that you need to work from your standalone computer to learn PHP, MySQL etc. Just google it and install. You may need to do a little reading on how to use it (access the pages, for example), but it’s pretty simple.

By installing it.

You can install Apache, PHP and MySQL on your own system, and fiddle with it til your heart’s content.

The whole package in a single installer is called WAMP (Windows Apache, MySQL, PHP), and can be found here:

You can install a server on your computer for practicing (recommended) or you can get an account at a free hosting site with MySQL, like and use that.

As I said, I recommend the first option. There are several WAMP packages (Windows) or LAMP packages (Linux) that you can install to get everything you need, hence the acronym.
WAMP = Windows + Apache + MySQL + PHP
LAMP = Linux + Apache + MySQL + PHP
Just search your favorite search engine to find one.

Alternatively you can install each individual component yourself which is a little more difficult but at least you know your getting the latest version of everything. If you’re going to do that then you want to install Apache, then PHP, then MySQL.

[edit]
Also, if you install a server on your computer I would recommend looking into PHPMyAdmin. It’s a tool that allows you to manage your MySQL databases and tables from a web interface. I would still recommend trying to learn the MySQL commands but PHPMyAdmin can be very useful. Also, any time you do anything with PHPMyAdmin, like delete a table or row or create a new table, it shows the command it used to perform that task and the MySQL response, so it can help you learn the commands.

you can simply download mysql for personal pc and then setup in your pc.