My apologize, this question may seem obvious...but I'm not an expert in system administration.
I have a Windows server (on my Intranet) running Apache 2.2 and MySQL 5.1. The server has PHPMyAdmin installed.
When I open http://servername/phpmyadmin I can see, edit the SQL database (note that I'm not asked for any login/password but I see in PHPMyAdmin that I'm logged as root@localhost).
Now, when I try to open the database from a tool installed on y machine (HeidiSQL), I can't get the connection right.
When I specify no user name, it reports
Access denied for 'ODBC'@'my local machine name'. I tried to specify
root@%....but 'my local machine name' always gets appended to the name I enter and connexion is refused.
How can I get this HeidiSQL tool be able to connect the database? What user name should I specifiy?