mysqlcheck: Got error: 1045: Access denied for user ‘root’@‘localhost’ (using password: YES) when trying to connect
I have no clue where the MAMP GUI tries to take the credentials from when running checks and repairs. It just never seems to work.
The solution that worked for me, however, is to simply run
mysql_upgrade -uroot -p on the command line. Don’t forget to check that MAMP’s mysql binary is in your PATH, because it is not by default. To do so add to your shell’s config (that’s
.zhsrc for me) and restart your terminal:
Upgrade process completed successfully.
Checking if update is needed.