Hi Johan
Would the server require a restart after this or not?
Machiel
-----Original Message-----
From: Johan De Meersman <[email protected]>
To: Machiel Richards <[email protected]>
Cc: mysql mailing list <[email protected]>
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
the file.
On Wed, Dec 8, 2010 at 9:51 AM, Machiel Richards <[email protected]>
wrote:
HI All
I am hoping someone has had this before as this one is
baffling me
entirely.
We did a MySQL database move from one machine to another one
last
night.
The O/S versions are the same and so are the database
version
(5.1.22).
The database was installed and configured on the new
machine and
was running perfectly. no issues.
Seeing that both versions would be exactly the same, we
decided
to do a full backup including the mysql database in order to
preserve
all permissions etc... and then restore this to the new machine.
The backup and restore went through without any issues
whatsoever.
However when I used the /etc/init.d/mysql script to
restart the
database, I started getting errors during shutdown and startup
procedure.
Despite this the database did start up and was
accessible,
however even when running /etc/init.d/mysql status command I get
errors
as below (these are the same received during startup):
/etc/init.d/mysql status
/usr/bin/mysqladmin:
connect to
server at 'localhost'
failed
error: 'Access denied for
user
'debian-sys-maint'@'localhost' (using password: YES)'
*
I have tried to look on the net for answers but
nothing was
found to resolve this. I have reset the passwords for this user
(also
getting the same error for r...@localhost).
One site also suggested correcting the password in
the /etc/mysql/debian.cnf which I did, but still getting these
messages.
This is a production system and I am a bit concerned
to the
fact that the startup script does not work properly.
Is there anyone who has had this issue before and
have
been able to resolve it?
Thank you in advance for any help on this matter.
Regards
Machiel
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
