evil.czAfter power failure mysql refuses root login: Access denied for user 'root'@'' (using password: YES)
Try to log in WITHOUT a password: mysql -u root
If successfull, check users table content:
> use mysql;
> select * from user;
All passwords are probably empty - means login without password is poossible now ;-(
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'new_password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'machine_name' IDENTIFIED BY 'new_password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Change machine_name and new_password to suit your needs.
Check password for 'debian-sys-maint'@'localhost' !!! This row is probably corrupted too - see /var/log/syslog for message Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) after boot. More information here.
Recent comments
29 weeks 3 days ago
31 weeks 6 days ago
32 weeks 4 days ago
32 weeks 4 days ago
32 weeks 4 days ago
33 weeks 5 days ago
35 weeks 18 hours ago
45 weeks 4 days ago
46 weeks 2 days ago
46 weeks 2 days ago