Mysql problem on Xampp

[rrmaverick]

Hi,

I have installed Xampp on ubuntu 8.04. The installation ran smoothly but when I try to connect to mysql, I get the following error

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[Wiedmann]

but when I try to connect to mysql,

With the shell, a PHP script, a Perl script, ... ?

[rrmaverick]

with the shell using mysql -u username -p

[Dave_L]

That's the error I get if the MySQL service is not running.

Check whether services are running:
# /opt/lampp/lampp status

Start services:
# /opt/lampp/lampp start

[Wiedmann]

with the shell using mysql -u username -p

This command is using the MySQL client from your OS, and not the MySQL client from XAMPP.

You must use:

Code: Select all

/opt/lampp/bin/mysql -u username -p

or:

Code: Select all

cd /opt/lampp/bin
./mysql -u username -p

[rrmaverick]

thanks,

that worked.

[sunandwavs]

Thank you Wiedmann, your answer worked for me also. On a guest F10 (via VBOX), I am trying to get Drupal up. My PATH is currently:

Code: Select all

[drupal@localhost bin]$ whereis mysqladmin
mysqladmin: /usr/bin/mysqladmin /opt/lampp/bin/mysqladmin /usr/share/man/man1/mysqladmin.1.gz

Is changing PATH to look in /opt/lampp/bin/ first a good decision or will that lead to other glitches?

[Nobbie]

>Is changing PATH to look in /opt/lampp/bin/ first a good decision or will that lead to other glitches?

You should not change the PATH, instead you should delete all software components which already have been installed by your linux installation and which you decided not to use and instead use the Xampp Package. That means, look out for Apache, MySQL und PHP local installation and de-install them properly.

This is by far better than struggling with different versions of the same software.