zeldor.biz

Linux, programming and more

Copyright © 2023
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

Categories

Archives

Tags

apache2 Apple arduino ARM Automation backup bash Cisco Cluster Corosync Database Debian Debian squeeze DIY DNS Fedora FTP Fun Icinga Ipv6 KVM Linux LVM MAC OS X Monitoring MySQL Nagios Nginx openSUSE OpenVPN PHP Proxy Python python3 qemu RAID rsync Samba security ssh Ubuntu virtualization Windows Windows 7 Wordpress

Leave a Reply

Your email address will not be published. Required fields are marked *