Mysql error!

[Tony White]

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