MySQL - ERROR 1045: Access denied for user 'debian-sys-maint' @ 'localhost'

/etc/init.d/mysql start
Starting MySQL database server: mysqld ..
Checking for corrupt, not cleanly closed and upgrade needing tables..
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
nvieking1:/# ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

The solution

The file / etc / mysql / debian.cnf open and the password for the user debian-sys-maint read and copy.

Connect to the root user to the database:

mysql -u root -p

The password of the user debian-sys-maint with the following command (change <<password>> is to replace the read password to):

mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '<<passwort>>' WITH GRANT OPTION;

Now you can start your MySQL database again.

/etc/init.d/mysql start
Starting MySQL database server: mysqld ..
Checking for corrupt, not cleanly closed and upgrade needing tables..


Similar items:

1. MySQL user password change
2. Web server (LAMP) installation in Debian 5 (Lenny) and Ubuntu
3. Icinga - Open Source Monitoring - Installing on Debian 5 (Lenny) with IDOUtils and MySQL database
4. MySQLDump - Can not open file (errno: 24) when using LOCK TABLES
5. Sequel Pro - MySQL with SSH Tunnel Manager for MAC OS X

Tags: database , database , debian , debian-sys-maint , error , mysql