SQL Error (1045): Access denied for user 'root'@'localhost' (using password: YES)

When I try to connect to Heidi SQL for my World of Warcraft private server, I get this error message:

SQL Error (1045): Access denied for user 'root'@'localhost' (using password: YES)

Ive tried putting in NO password, I've tried ascent, AND I've tried root. Nothing works at all! Can somebody please help me fix this, this is very stressful.

If you can connect local with phpmyadmin it seams that your credentials don't have remote access ( or mysql server its self doesn't accept remote access)

Try connecting through ssh tunneling where users don't have to be granted spacial remote access (read my posts for who to configuration plink+putty). If you don't want to use tunneling give remote access to your user reload privileges and try again.

I assume you have forgotten the password you chose when you installed MySQL. Try this: How to Reset the Root Password