I have followed the steps given by Stephen Powell and tried to install again. It is showing same error. Out of curiousity I have run
*# dpkg -s mysql-server-5.0* **and the output of the above command is : *# dpkg -s mysql-server-5.0* Package: mysql-server-5.0 Status: install ok half-configured Priority: optional Section: misc Installed-Size: 81708 Maintainer: Debian MySQL Maintainers < pkg-mysql-ma...@lists.alioth.debian.org> Architecture: i386 Source: mysql-dfsg-5.0 Version: 5.0.51a-24+lenny3 Replaces: mysql-enterprise-server-5.0, mysql-server (<< 5.0.51a-24+lenny3) Provides: mysql-community-server-5.0, mysql-server, virtual-mysql-server Depends: mysql-client-5.0 (>= 5.0.51a-24+lenny3), libdbi-perl, perl (>= 5.6), libc6 (>= 2.7-1), libgcc1 (>= 1:4.1.1), libmysqlclient15off (>= 5.0.27-1), libncurses5 (>= 5.6+20071006-3), libreadline5 (>= 5.2), libstdc++6 (>= 4.1.1), libwrap0 (>= 7.6-4~), zlib1g (>= 1:1.2.3.3.dfsg), debconf (>= 0.5) | debconf-2.0, psmisc, passwd, lsb-base (>= 3.0-10) Pre-Depends: mysql-common (>= 5.0.51a-24+lenny3), adduser (>= 3.40), debconf Recommends: mailx, libhtml-template-perl Suggests: tinyca Conflicts: mysql-server (<< 5.0.51a-24+lenny3) Conffiles: /etc/mysql/debian-start 4272e4d740c8ae651ac35bbf4d2ed6dc /etc/logrotate.d/mysql-server 64e209fe34f73fbf10c9479bf30947c4 /etc/init.d/mysql 246ab7d69e00af14f03d12c54465b59c /etc/init.d/mysql-ndb-mgm becae0693dae627e6960249ae17bae19 /etc/init.d/mysql-ndb 25ad87aee00cf24aea5daf7ad4ed899f /etc/logcheck/ignore.d.server/mysql-server-5_0 20ccf274886d8f2897a10d9288579410 /etc/logcheck/ignore.d.workstation/mysql-server-5_0 20ccf274886d8f2897a10d9288579410 /etc/logcheck/ignore.d.paranoid/mysql-server-5_0 e8dbe35695437354553e61fd65b702ba Description: MySQL database server binaries MySQL is a fast, stable and true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular database query language in the world. The main goals of MySQL are speed, robustness and ease of use. . This package includes the server and ndb-cluster binaries. Homepage: http://dev.mysql.com/ The above output might make some sense to resolve the issue. thank u :)
