Connecting NetBeans 6.7 to SVN on Ubuntu

These are the steps I had to take to establish a connection from within NetBeans 6.7 to my Subversion Repository via a https connection.

Install svn -> sudo apt-get install svn
Install an svn client, I chose RapidSVN -> sudo apt-get install rapidsvn
In NetBeans select Team > SVN>Check out… and fill in the Form. The path to the RapidSVN executable is /usr/sbin.
Restart NetBeans and you should be able to proceed in the wizard.

MySQL Basics on Ubuntu 8.10

Information taken from help.ubuntu.com

Starting  mysql  shell

mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');

With password

mysql -u root -p

Create a mysql database

mysql> CREATE DATABASE database1;

Create a mysql user

mysql> GRANT ALL PRIVILEGES ON *.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON database1.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword';

Postgres Basics on Ubuntu 8.10

Installation
sudo apt-get install postgresql postgresql-client postgresql-contrib

Changing the User Password
sudo -u postgres psql postgres
ALTER USER postgres WITH ENCRYPTED PASSWORD ‘<***password***>';
q

Creating a New DB
sudo -u postgres createdb dev

Setting up PgAdmin III
Don’t know exactly what this is good for, better performance?
sudo -u postgres psql < /usr/share/postgresql/8.3/contrib/adminpack.sqll

Installing PgAdmin III
sudo aptitude install pgadmin3