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

[expired user #5454]'s profile image [expired user #5454] posted 13 years ago in Creating a connection Permalink
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.
Rapid-eraser's profile image Rapid-eraser posted 13 years ago Permalink
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.
kalvaro's profile image kalvaro posted 13 years ago Permalink
I assume you have forgotten the password you chose when you installed MySQL. Try this: How to Reset the Root Password

Please login to leave a reply, or register at first.