Installing MySQL Workbench 6.0.9 on Ubuntu 12.10

Installing MySQL Workbench from the Ubuntu Software Center of Ubuntu 12.10 (quantal) will give you a very old version 5.4.0 that's buggy - when you exit the app, it freezes. After a bit of trial and error, here's how I installed the latest (as of the date of this writing, at version 6.0.9) -

1. Downloaded the deb file for Ubuntu 12.04 (as there was no deb package for 12.10) from the MySQL downloads page
2. Downloaded the libctemplate0_0.97-1_i386.deb file. This package is a dependency of the MySQL Workbench 6, and isn't in Ubuntu 12.10 by default. I got this tip about the flaw from the good people of the MySQL Workbench community.
3. Go in terminal and install the packages - 

sudo dpkg -i libctemplate0_0.97-1_i386.deb

sudo dpkg -i mysql-workbench-community-6.0.9-1ubu1204-i386.deb

The output goes:

Selecting previously unselected package mysql-workbench-community.
(Reading database ... 247682 files and directories currently installed.)
Unpacking mysql-workbench-community (from mysql-workbench-community-6.0.9-1ubu1204-i386.deb) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libpcrecpp0 (>= 7.7); however:
  Package libpcrecpp0 is not installed.
 mysql-workbench-community depends on libtinyxml2.6.2; however:
  Package libtinyxml2.6.2 is not installed.
 mysql-workbench-community depends on python-paramiko; however:
  Package python-paramiko is not installed.
 mysql-workbench-community depends on python-pysqlite2; however:
  Package python-pysqlite2 is not installed.

So the final step to resolve and fix the unmet dependencies was to issue this command:

sudo apt-get -f install

It will appear under your applications Development menu as MySQL Workbench. Those Workbench guys have really improved the UI, totally new look :-)

Installing LAMP on Ubuntu 11.04

Followed the instructions in this link to install LAMP.
If you get this message while restarting apache - “apache2: Could not determine the server’s fully qualified domain name, using 127.0.0.1 for localhost”
Type this in the terminal to fix the problem:

echo "ServerName localhost" | sudo tee /etc/apache2/conf.d/fqdn

and reload apache

sudo /etc/init.d/apache2 reload

mysql stuff - setting up a (super) user

1. Install mysql-server package
2. Create a super user

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     WITH GRANT OPTION;

3. Install phpmyadmin package

4. Go ahead and import Excel tables!