[KLUG Members] help please with mysql gone awry on debian

[Richard Harding]

I have a woody server set up as a web server. I had it running php4, 
mysql, and apache. I tried to use the dotdeb sources to update to php5 
and I ended up having problems with those php5 packages.

So I decided to go back to stables packages. I removed apache, mysql, 
php and removed the sources. After and apt-get update I tried to install 
php4, mysql-server, and apache again.

All seemed to work except for mysql which was giving me an error about 
user.frm. So I uninstalled mysql again and searched out and removed 
mysql files such as the /var/log/mysql directory, /etc/mysql, and files 
such as /etc/init.d/mysql.

Then I tried to resintall the mysql packages. I am not able to get 
mysql-server to install now and I am getting the errors listed below.


    Debian:/etc# apt-get install mysql-server
    Reading Package Lists... Done
    Building Dependency Tree... Done
    The following NEW packages will be installed:
    mysql-server
    0 packages upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
    Need to get 0B/2801kB of archives. After unpacking 7561kB will be used.
    Preconfiguring packages ...
    Selecting previously deselected package mysql-server.
    (Reading database ... 25963 files and directories currently installed.)
    Unpacking mysql-server (from .../mysql-server_3.23.49-8.8_i386.deb) ...
    Setting up mysql-server (3.23.49-8.8) ...
    /var/lib/dpkg/info/mysql-server.postinst: line 10:
    /etc/init.d/mysql: No such file or directory
    update-rc.d: /etc/init.d/mysql: file does not exist
    dpkg: error processing mysql-server (--configure):
    subprocess post-installation script returned error exit status 1
    Errors were encountered while processing:
    mysql-server
    E: Sub-process /usr/bin/dpkg returned an error code (1)
    Debian:/etc#

    Debian:/etc# cat /var/log/mysql/mysql.err
    Installing all prepared tables
    041127 13:41:07 /usr/sbin/mysqld: Shutdown Complete


    PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
    This is done with:
    /usr/bin/mysqladmin -u root -p password 'new-password'
    /usr/bin/mysqladmin -u root -h Debian.msufame.msu.edu -p password
    'new-password'
    See the manual for more instructions.

    NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
    the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
    able to use the new GRANT command!

    Please report any problems with the /usr/bin/mysqlbug script!

    The latest information about MySQL is available on the web at
    http://www.mysql.com
    Support MySQL by buying support/licenses at https://order.mysql.com

    041127 13:41:07 /usr/sbin/mysqld: Shutdown Complete


Any ideas how I can get mysql-server going? I don't get why it seems 
like it can't replace the /etc/init.d/mysql files and such

Thanks a ton.

Rick