[Scenario]

If you use phpMyAdmin, you can log in via the root account and click on the "users" tab. It will show you next to each user something like "localhost" or "@". The @ would mean that it will accept connections from anywhere.

localhost means it only accepts connections from localhost; although I don't believe this includes 127.0.0.1 on Windows Vista/7.