After 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;
Recent comments
15 weeks 12 hours ago
17 weeks 3 days ago
18 weeks 1 day ago
18 weeks 1 day ago
18 weeks 1 day ago
19 weeks 1 day ago
20 weeks 4 days ago
31 weeks 1 day ago
31 weeks 6 days ago
31 weeks 6 days ago