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.
Subscribe