zeldor.biz

Linux, programming and more

Copyright © 2025
Log in

Access denied for user ‘debian-sys-maint’

March 29, 2011 by Igor Drobot Leave a Comment


While trying to start or stop MySQL I get:

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

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

Dabian has a own way to login to the MySQL database the credantials are listed in a file:

1
2
3
4
cat /etc/mysql/debian.cnf
[...]
user = debian-sys-maint
password = bodCNLUx0GGYm6F

cat /etc/mysql/debian.cnf [...] user = debian-sys-maint password = bodCNLUx0GGYm6F

Logon:

1
mysql -u root -p

mysql -u root -p

Execute:

1
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'bodCNLUx0GGYm6F' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'bodCNLUx0GGYm6F' WITH GRANT OPTION;

By the way set a new root passwort:

1
mysqladmin -u root password 'new-password'

mysqladmin -u root password 'new-password'

Filed Under: Debian, Linux, MySQL Tagged With: Access denied, debian-sys-maint, MySQL

Yeaaah Cookie! We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok