DBeaver: Access denied for user 'root'@'localhost' (using password: YES)
Create new user with password and full privileges as described here:
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'the_password_you_wish_here';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;

...and login with this user for further usages.