This almost seems like some sort of firewall issue.Are you running a firewall (Windows has one by default and will complain loudly if disabled)? If so could you briefly disable it and try if you can connect then? (Make sure you are behind a NAT router, another firewall or just disconnected before doing this)
Mautirz, thanks for the reply.However, the trouble machine and MySql server are in the same subnet, there is no firewall between them.(-) Sniffer log shows successful two way communication, and to me, Toad already successfully login the DB.(-) It is running good with MySql workbench 5.2 CE from the SAME Windows 7 64bit to access the same MySql DB using the same account.But I still like to use Toad. Hope the sniffer log attached in the original email could give you hint, which additional TCP segment Toad is still waiting? Is this optional from MySql side? Thanks.
This happens when you try to make connection withMySql database from within .NET and is a privileges issues. For resolution, please follow these steps,
1- Run > Command Prompt
Move to C:\Program Files\MySql\bin folder. Path for me appears as following,
C:\Program Files\MySQL\MySQL Server 5.5\bin>
2- Log into My Sql by exeucting the following command,
mysql -u root -p
You will be prompted for password.
On successfull password input you will log into mySql console,
3- Grant All Privileges
Execute following command under my sql console,
grant all privileges on *.* to `root`@`%` identified by 'password';
Upon successfull completion of command you will recieve confirmation simialr to this,
Query OK, 0 rows affected (0.05 sec)
Note: Pay special heed to position of apostrophe vs. commas. Usernameis enclosed within apostrophy(`) where as password within commas (').
4- Flush Privileges
Execute following command to ensure the privileges take affect,
which will result in notification similar to this,
Query OK, 0 rows affected (0.11 sec)
You are done. Switch back to Visual Studio to test your settings are properly taking affect. To exit mysql console type exit and press enter. Above steps are summarized in figure below,