mysql admin user problem

[David Wilk <myca@cia-g.com>]

Howdy folks,

I have installed mysql a few times (from debian packages) and never had
any trouble, but this one just stumpes me.  I installed debian woody and
mysql on a server.  I screwed up /var/lib/mysql trying to copy over some
databases so I reinstalled mysql to bring things back to normal.  I
removed /var/lib/mysql first of course, but once installed, I would get
this error when trying to start mysql:

<snip>
Starting MySQL database server: mysqld...failed.
<snip>

cat /var/log/mysql/mysql.err gives:

<snip>
030630 16:59:46  mysqld started
/usr/sbin/mysqld: ready for connections
<snip>

but, cat /var/log/mysql.log gives:

<snip>
/usr/sbin/mysqld, Version: 3.23.49-log, started with:
Tcp port: 0  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
030630 16:59:47       1 Connect     Access denied for user:
'debian-sys-maint@localhost' (Using password: YES)
030630 16:59:48       2 Connect     Access denied for user:
'debian-sys-maint@localhost' (Using password: YES)
030630 16:59:49       3 Connect     Access denied for user:
'debian-sys-maint@localhost' (Using password: YES)
030630 16:59:50       4 Connect     Access denied for user:
'debian-sys-maint@localhost' (Using password: YES)
030630 16:59:51       5 Connect     Access denied for user:
'debian-sys-maint@localhost' (Using password: YES)
030630 16:59:52       6 Connect     Access denied for user:
'debian-sys-maint@localhost' (Using password: YES)
<snip>

The process list shows 4 mysql processes running (when none were running
before).  '/etc/init.d/mysql stop' does nothing.

I have removed mysql-server, and mysql-client and then removed
/etc/mysql and /var/lib/mysql before reinstalling both mysql-server and
mysql-client.  yet, still I get these errors.

if anyone has any ideas I'd love to hear them!

thanks,
Dave


-- 
*******************************
David Wilk
System Administrator
Community Internet Access, Inc.
myca@cia-g.com