Would the server require a restart after this or not?
From: Johan De Meersman <vegivamp@stripped>
To: Machiel Richards <machielr@stripped>
Cc: mysql mailing list <mysql@stripped>
Subject: Re: Moving of databases from one server to another
Date: Wed, 8 Dec 2010 11:02:55 +0100
That's a very Debian-specific issue. The credentials for the
debian-sys-maint user are randomly generated at install, and stored
in /etc/mysql/debian.cnf. Either copy the file from the old to the new
machine, or update the user's password on the new machine to the one in
On Wed, Dec 8, 2010 at 9:51 AM, Machiel Richards <machielr@stripped>
I am hoping someone has had this before as this one is
We did a MySQL database move from one machine to another one
The O/S versions are the same and so are the database
The database was installed and configured on the new
was running perfectly. no issues.
Seeing that both versions would be exactly the same, we
to do a full backup including the mysql database in order to
all permissions etc... and then restore this to the new machine.
The backup and restore went through without any issues
However when I used the /etc/init.d/mysql script to
database, I started getting errors during shutdown and startup
Despite this the database did start up and was
however even when running /etc/init.d/mysql status command I get
as below (these are the same received during startup):
server at 'localhost'
error: 'Access denied for
'debian-sys-maint'@'localhost' (using password: YES)'
I have tried to look on the net for answers but
found to resolve this. I have reset the passwords for this user
getting the same error for root@localhost).
One site also suggested correcting the password in
the /etc/mysql/debian.cnf which I did, but still getting these
This is a production system and I am a bit concerned
fact that the startup script does not work properly.
Is there anyone who has had this issue before and
been able to resolve it?
Thank you in advance for any help on this matter.
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel