Home > Desktop, Linux, Servers > Access denied for user ‘debian-sys-maint’@'localhost’

Access denied for user ‘debian-sys-maint’@'localhost’

Debian have their own way for doing things. Here is a quick fix up if mess with the mysql-maintain user.

If you end up having error like that one when restarting your mysql server:

armed:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld failed!
Starting MySQL database server: mysqld already running.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

First you need to find out what is the password for your system:

armed:~# cat /etc/mysql/debian.cnf | grep pass
password = x4FStDr29DDshTFqsf

and than add the user:

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '' WITH GRANT OPTION;
Categories: Desktop, Linux, Servers Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.
You must be logged in to post a comment.