MYSQL update
Hal Burgiss
hal at burgiss.net
Thu Nov 13 16:10:24 UTC 2008
On Thu, Nov 13, 2008 at 10:13:40PM +0800, Chris Jeffries wrote:
> >
> > It almost sounds like the mysql system user is gone missing. Do you
> > still have a mysql account like 'debian-sys-maint', and does it have
> > the password it needs? Also, have you checked syslog for a better
> > error message?
>
> Spot on. Thank you. I had hacked the user file to transfer users
> over from a Windows system (not all that successfully) and trashed
> the debian maint. user (I did not realise there was one) in the
> process.
>
> Since I rarely use mysqladmin, I had also used the stop command
> instead of the shutdown command. I shall really have to learn what I
> am doing before doing it!!!
AFAIK, this is a debian convention. I learned mysql elsewhere and got
bit by this right off the bat with Ubuntu.
It is one serious gotcha about moving databases around from one system
to another.
--
Hal
More information about the ubuntu-users
mailing list