develOOp another fine develOOpment

Setup :

• Ubuntu 7.04
• installed Xampp 4 linux manually using the steps provided at that page. Default credentials is root without a password
  
• Installed Mysql Browser by selecting it in the easy to use software install tool. Application > Add/Remove > Programming (make sure you have selected 'All Open Source Applications' in top right selection box)

Problem:

• Started xampp through a shortcut 'gksu /opt/lampp/lampp restart'
• Started Mysql Browser through Application > Programming > Mysql browser
  • Create a new connection
    
•   Server : localhost
  
•   Port : 3306
  
•   Username : root
•   Password :
•   Default schema :
• Press Connect
• Get an error like
  Could not connect to host 'localhost'.
  MySQL Error Nr. 2002
  Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Solution:

For a standard Xampp installation the socket file is NOT located at /var/run/ ... but inside the /opt/lampp installation.

• open /opt/lamp/etc/my.cnf and read that the socket is located at /opt/lampp/var/mysql/mysql.sock
• In the connection box of mysql browser click the "Details" button and fill in the above value in the 'Connect using Socket file' box
• Press Connect again.
• You're connected !!