Ubuntu Quickie: Installing MySQL and PostgreSQL

• June 21, 2007
• James Skemp
• article, tutorials / guides

For SQL on Ubuntu Linux, I decided it was easiest to just use the repositories to just install MySQL and PostgreSQL.

There was a couple of reasons for this. First, MySQL docs recommend it.

Second, there's not that much that I really want to configure in SQL.

So ...

MySQL

sudo apt-get install mysql-server

At the time of this writing, this will install;

libdbd-mysql-perl
libdbi-perl
libnet-daemon-perl
libplrpc-perl
mysql-client-5.0
mysql-server
mysql-server-5.0

Suggested packages:

dbishell
libcompress-zlib-perl
tinyca

Recommended packages:

mailx

There's some official GUIs that you can also install:

sudo apt-get install mysql-admin mysql-query-browser

At the time of this writing, this will install;

libcairomm-1.0-1
libglibmm-2.4-1c2a
libgtkhtml3.8-15
libgtkmm-2.4-1c2a
mysql-admin
mysql-admin-common
mysql-query-browser
mysql-query-browser-common

Suggested packages:

libgtkhtml3.8-dbg

PostgreSQL

For PostgreSQL, it's a bit longer of a string, since there's four packages, but it's still easy enough.

sudo apt-get install postgresql-8.2 postgresql-client-8.2 postgresql-client-common postgresql-common

You may as well also go from pgAdmin III, which "is the most popular and feature rich Open Source administration and development platform for PostgreSQL."

sudo apt-get install pgadmin3

At the time of this writing, this will install:

libpq4
libwxbase2.6-0
libwxgtk2.6-0
pgadmin3
pgadmin3-data

Recommended packages:

pgagent (adds functionality to schedule PostgreSQL jobs)

Next time ...

Next time we'll configure databases for both MySQL and PostgreSQL on Ubuntu.

• ubuntu
• mysql
• postgresql