When you have a MySQL error, you can copy past the statement and check if it works in a PHPMyAdmin that theorically has a root permission (not always but frequently).
This will confirm you that when you provide a correct MySQL login and password you can execute the statement.
In the statement in tells you that you don't have "access denied for user".

You can also use a PHPMyAdmin with a root login and modify the permission of your MySQL user to give it all the permissions like a root.