Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

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

nickoo1234's profile image nickoo1234 posted 9 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 9 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 9 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.