View Single Post
Old 07-19-2005, 10:15 AM   #11 (permalink)
DistantWords
Registered User
 
Join Date: Jul 2005
Posts: 1
DistantWords is on a distinguished road
I've been having this same problem, which is what brought me to this thread... And site...

I found one thing that might help. I was having the exact same problem as mentioned in this thread, but I figured something out. Sort of...

If you go into your mysql folder on the computer running MySQL, and go to the "bin" folder. Double click on "winmysqladmin.exe" (or at least that's what it's called for me..). There is a tab called "my.ini Setup". Click that tab.

You will see something that says:

#bind-address=*.*.*.*

(I blocked out the IP address)

Anyway, for me at least, the IP address that was there is different from my current IP address. So, I tried using that instead, and I at least got to the "denied" page instead of the flat out "can't connect" page.

However, here's the problem. The username is being displayed as "root@tricia-pc" (my computer's name) instead of "root@localhost", so I'm getting denied. I tried putting "root@localhost" as the username, but then it came up as "root@localhost@tricia-pc" isntead.

Is there any way to force the username to be "root@localhost"?

Did all that make sense?

Thanks,

Robert
DistantWords is offline   Reply With Quote