While trying to start or stop MySQL I get:
1 | 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 |
Logon:
1 | mysql -u root -p |
Execute:
1 | 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' |