Access denied for user debian sys maint pada linux

Pernahkah kalian mengalami masalah MySQL: “Access denied for user ‘debian-sys-maint’@’localhost'” pada server linux Anda?
   

root@fkip:~$ sudo /etc/init.d/mysql restart

Muncul error

Stopping MySQL database server mysqld [fail]Starting MySQL database server mysqld [ OK ]¨/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

Berikut cara mengatasi permasalahan MySQL: “Access denied for user ‘debian-sys-maint’@’localhost'”

1. Ketikan perintah berikut pada terminal
   

   root@fkip:~$ cat /etc/mysql/debian.cnf

2. Selanjutnya akan tampil sebagai berikut
   

   # Automatically generated for Debian scripts. DO NOT TOUCH[client]host     = localhost
user     = debian-sys-maint password = n4aSHUP04s1J32A1¨socket   = /var/run/mysqld/mysqld.sock¨[mysql_upgrade]¨user     = debian-sys-maintpassword = n4aSHUP04s1J32A1socket   = /var/run/mysqld/mysqld.sock basedir  = /usr

3. Lihat password, pada script diatas passwordnya yaitu: n4aSHUP04s1J32A1
4. Masuk ke sql dengan menggunakan user dan password
   

   root@fkip:~$ mysql -u root -p

   Masukkan password mysql Anda
5. Gunakan fungsi grant pada mysql
   

   mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'n4aSHUP04s1J32A1';

6. Keluar dari editor sql (tekan tombol Ctr + C).
7. Restar mysql.
   

   root@fkip:~$ sudo /etc/init.d/mysql restart