Having problems getting MySQL Gui Tools to work with Xampp and would appreciate any help or pointers you guys could give (I'm new to linux)
Xampp is installed and fully working. Mysql going like a dream, but I really miss the gui tools so I have installed them. When I try to use SQL Administrator I get the following error:
Could not connect to host 'localhost'.
MySQL Error Nr. 2002
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
On further investigation, there is no such directory. It seems that Xampp installs MySQL to a "custom" directory and hence the socket is not at the location where the Gui Tools are looking for it. Xampp installed mysql.sock at opt/lampp/var/mysql/ on this machine (SUSE 10.0).
Is there any simple fix to this?