When we think of a database on a Linux machine, the first thing that often comes to our mind is MySQL. It is the first choice because it is free, open source, and reliable, and comes with a rich tool set. However, you have to remember that the Pi is not a server, and you might just want to use SQLite instead.
According to Wikipedia, as of July 2013, MySQL is the world's second most widely used open-source relational database management system.
The most popular tool to manage MySQL is phpMyAdmin. We will install these two and then test the installation. This can take up to 15 minutes.
sudo apt-get update sudo apt-get install mysql-server
You will be presented with blue-background screens asking you for the root user password. You should write these down or store them in an application like KeePass.
The MySQL root user must never be used by web applications, especially production ones available on the Internet. The phpMyAdmin application needs to run with...