ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

The problem is that your init scripts use debian-sys-maint, and that record in the db is either gone or changed.

You need to put it back.

 1.
    Kill off all running mysql processes
 2.
    Get the password from /etc/mysql/debian.cnf
 3.
    sudo mysqld –skip-grant-tables –user=root
 4.
    UPDATE mysql.user SET Password = PASSWORD('thepassword') WHERE User = 'debian-sys-maint';
 5.
    quit out, then restart mysql. This can also be handy for setting/resetting the mysql root user pass
 
dump.txt · Last modified: 2010/02/18 06:18 by admin
 
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki