I just spent an hour on this and post this here as a reference so if someone needs or myself..

OS: Deb Lenny

Error was 2002 Mysql cannot connect.

What i did.

/etc/mysql/my.cnf rename it to my.cnf.bk

then /etc/init.d/mysqld start

once there the mysql server started but needed a new password for root.

Next you execute

Code: 
mysql --user=`grep "^user=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --password=`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2`

use mysql;
UPDATE user SET password=PASSWORD('newpass') WHERE user='root';
FLUSH PRIVILEGES;
quit
And you're good to go..

I guess..
EvilGenius Reviewed by EvilGenius on . Direct Admin + Mysql + 2002 Error I just spent an hour on this and post this here as a reference so if someone needs or myself.. OS: Deb Lenny Error was 2002 Mysql cannot connect. What i did. /etc/mysql/my.cnf rename it to my.cnf.bk Rating: 5