MySQL not starting Debian 3.1 Sarge Control panel is DirectAdmin

MySQL not starting
#############

Here are the details.......... Please advise.

server:/usr/src# mysql -V
mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686)
server:/usr/src#


server:/usr/src# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
server:/usr/src#


server:/usr/src# mysqld --skip-grant-tables --user=root
070510 14:17:44 [Warning] Ignoring user change to 'root' because the user was set to 'mysql' earlier on the command line

mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
070510 14:17:44 [ERROR] Aborting

070510 14:17:44 [Note] mysqld: Shutdown complete

server:/usr/src# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

server:/usr/src# mysql -u root mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)


I tried to upgrade system mysql using the following steps
################################################


apt-get update
apt-get install mysql-server mysql-client

But the upgrade didnot complete.. well.. and left the server with the old version.

Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
Setting up mysql-client (5.0.38-3) ...
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.0; however:
Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.0
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)



How can I re-install the same version of mysql on the Debian 3.1 Sarge server which hosts a DirectAdmin Control Panel without breaking any settings on the server?



How can I install updated version of mysql on the Debian 3.1 Sarge server which hosts a DirectAdmin Control Panel without breaking any settings on the server?




Thanks

Hi,

when you installed DA, in install own mysql-bin version, and setup random password to mysql:

Passwords found:

/usr/local/directadmin/scripts

and there is setup.txt

and line(password for root to mysql): mysql=*******

Also same folder you found mysql.sh install script, but if install it delete old databases (manually need backup them):

install script:
/usr/local/directadmin/scripts/mysql.sh