Mysql error!

[Enigma]

Allan,
by any chance did this error happen after you attempted an upgrade of
your ubuntu?

On 5/20/09, Tony White <tony.mzungu at gmail.com> wrote:
> This email is from a ubuntu-ke subscriber to other subscribers inluding
> you:)
> Hi Allan,
>
> Some information would be useful:
> 1) what version of ubuntu? - and is it desktop or server version?
> 2) when you did the apt-get, did that go all the way through successfully?
>
> Personally, I prefer aptitude to apt-get, due to better dependency
> handling - but that shouldn't make a difference in this case.
>
> Also, I think it's best to install the meta-package - mysql-server -
> and let that pull in the current version, rather than explicitly
> installing - but again, that's not going to cause this kind of
> problem.
>
> Without more information, I can only suggest you remove, and purge
> (using apt-get) - this will clear it out completely - then do a fresh
> apt-get of the package and see how it goes.
>
> Tony
>
>
> 2009/5/17 allan oware <lumtegis at gmail.com>:
>> This email is from a ubuntu-ke subscriber to other subscribers inluding
>> you:)
>> Hi Guys
>> I installed mysql-server5 using apt-get but havent been able to start
>> mysql since then;
>>
>> root at HEAT:/# /etc/init.d/mysql start
>>  * Starting MySQL database server mysqld
>> [fail]
>> root at HEAT:/# /usr/bin/mysql start
>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>> '/var/run/mysqld/mysqld.sock' (2)
>> root at HEAT:/# /usr/bin/mysql -u root mysql
>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>> '/var/run/mysqld/mysqld.sock' (2)
>>
>> A snapshot of 'my.cnf' is below
>>
>> [client]
>> port            = 3306
>> socket          = /var/run/mysqld/mysqld.sock
>>
>> [mysqld_safe]
>> socket          = /var/run/mysqld/mysqld.sock
>> nice            = 0
>>
>> [mysqld]
>> #
>> # * Basic Settings
>> #
>>
>> user            = mysql
>> pid-file        = /var/run/mysqld/mysqld.pid
>> socket          = /var/run/mysqld/mysqld.sock
>> port            = 3306
>> basedir         = /usr
>> datadir         = /var/lib/mysql
>> tmpdir          = /tmp
>> language        = /usr/share/mysql/english
>>
>> I've searched for 'mysqld.sock' but cant find it.Is any way I can make
>> mysql start successfully?
>> FYI ; user 'mysql' exists with neccessary permisssions.
>>
>> --
>> Ubuntu-ke mailing list
>> Ubuntu-ke at lists.ubuntu.com
>> https://lists.ubuntu.com/mailman/listinfo/ubuntu-ke
>>
>
>
>
> --
> Tony White
>
> --
> Ubuntu-ke mailing list
> Ubuntu-ke at lists.ubuntu.com
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-ke
>


-- 
Kind regards,
Antony Kipingor
+254720321222