Re: mysql admin user problem
Howdy all, just wanted to say what worked. Dominik's suggestion to
'purge' the mysql packages with apt-get did the trick. One final
reinstall had everything working fine. Not sure where the sanfu was...
thanks guys!
On Mon, Jun 30, 2003 at 05:03:36PM -0600 or thereabouts, David Wilk wrote:
> 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
>
>
> --
> To UNSUBSCRIBE, email to debian-isp-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>
--
*******************************
David Wilk
System Administrator
Community Internet Access, Inc.
myca@cia-g.com
Reply to: