copy the /etc/init.d/mysql file from your old m/c to the new and try the start/stop.
regards anandkl On Wed, Dec 8, 2010 at 2:21 PM, Machiel Richards <machi...@rdc.co.za> 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 > > > > > >