shopkod
2/6/2020 - 10:02 AM

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

mysql> use mysql;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1';
mysql> FLUSH PRIVILEGES;

-- Change password for root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';