I am hoping someone has had this before as this one is baffling me
We did a MySQL database move from one machine to another one last
The O/S versions are the same and so are the database version
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
However when I used the /etc/init.d/mysql script to restart the
database, I started getting errors during shutdown and startup
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):
/usr/bin/mysqladmin: connect to
server at 'localhost' failed
error: 'Access denied for user
'debian-sys-maint'@'localhost' (using password:
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 root@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.