MySQL Basics In Pictures

Running MySQL

You can run MySQL one of two ways:

  • Locally, on a desktop computer running Linux.
  • Remotely, on a Linux-based Web server.

Locally
This tutorial assumes that you're using a desktop computer running Linux. Just make sure you've got the Apache Web server and MySQL installed on your computer. Most Linux distributions have instructions on how to do this, such as the ones at Ubuntuguide.org.

Remotely
To run MySQL remotely, over the Web, coordinate with the people who manage your Web server.

To give commands to MySQL running on the Web server, just replace localhost in the instructions that follow with the IP address of the Web server, such as

10.0.1.10

or the domain name of the Web server, such as

mysql.domain.com

Provided you have an Internet connection with the Web server, and the proper username/password to access it, your commands will work.