Ubuntu® Linux® Secrets

Chapter 24. Database Server

Secrets in This Chapter

• The MySQL Database

• The PostgreSQL Database

• Using Databases in Ubuntu

The world runs on data. Just about every application you use needs to store data in some form or another. The Ubuntu server provides two popular open-source database servers for your data storage applications. This chapter first looks at the MySQL database server. The MySQL database server is quite possibly the most popular open-source database server available. It's the database engine behind many popular web sites, and it is used by hobbyists and corporations around the world. The second database server we'll look at is PostgreSQL. Although not as popular as MySQL, PostgreSQL has gained following in the open-source database world, mostly because of its commercial-quality features. Both of these database servers can be invaluable in your data storage applications.

The MySQL Server

Chapter 21, "Web Server," described the MySQL database server and showed the basics of how to use it as part of the Linux-Apache-MySQL-PHP (LAMP) environment. This section digs deeper into the operation of the MySQL database server, showing the files that the MySQL server needs to operate and walking through the mysql command-line interface, which provides a simple environment for interacting with your MySQL database server.

Note

If you didn't install the LAMP server on your Ubuntu server, or if you want to install MySQL on your Ubuntu workstation, you can do so using either the apt-get program ...