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 <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 > > > > > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
