MySQL Trouble need help

[Andrew Mathenge]

Your client is looking for the MySQL socket in /var/run/mysqld

Check your my.cnf. In my installation, this file is in /etc/mysql

Inside this file is a line that reads:

socket = /var/run/mysqld/mysqld.sock

Based on your installation this line may say something else.

Something else you can do is search for the file my.cnf. You can
use the following command to search for the file:

find / -name "my.cnf" -print

Let me know how many files are actually found. Depending (again)
on your installation, your MySQL may be using a different my.cnf
which is using a mysqld.sock that's in a different location.

Hope that this makes sense.

Andrew.

On Wed, Mar 26, 2008 at 7:37 AM, Antony Kipingor <kipingor at gmail.com> wrote:

> This email is from a ubuntu-ke subscriber to other subscribers inluding
> you:)
> Hi all,
>
> I hope you have been well, I resently attempted to upgrade Mysql server.
> The
> server is now giving me issues, I believe the root of the problem is the
> my.cnf is a  different version than the server itself.
>
> When I attempt to login i.e.
> #mysql -u root -p
> etc
> I receive the following error message:
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (2)
>
> Can anyone help me
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> https://lists.ubuntu.com/archives/ubuntu-ke/attachments/20080326/0f43de26/attachment.htm
> --
> Ubuntu-ke mailing list
> Ubuntu-ke at lists.ubuntu.com
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-ke
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ubuntu.com/archives/ubuntu-ke/attachments/20080326/78c88692/attachment.htm