ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Problem
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Solution

$mysql -u root -p

GRANT ALL PRIVILEGES ON *.* TO user@ip-address IDENTIFIED BY 'password';
commit;