Re: mysql admin user problem
I have had a similar problem some time ago, too. I succeded by purging*
the mysql-packages before reinstalling them.
The reason why you can't stop the mysql-server is obvious:
The debian-sys-maint user can't login so the init-script which utilizes
this mysql-user can't shutdown the server.
* "apt-get --purge remove mysql-server mysql-common"
(I don't know if it's necessary to remove mysql-common, too)
David Wilk <myca@cia-g.com> wrote on Mon, 30 Jun 2003 17:03:36 -0600:
> 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
Mit freundlichen Gruessen / Best regards
Dominik Schulz
Reply to: