mySQL setup on XP localhost?

[Paul Muns]

I have got the server working on Win XP Pro according to Winmysqladmin.exe.
I have a password in my.ini but when I go to CMD to login to root, it gives
me: "ERROR 1045: Access denied for user: 'root@localhost' <Using password:
YES>"

I am the system admin. I am however not using 'localhost' as such since I
am behind a router that has assigned this workstation: 192.168.0.3. The
USER and HOST are clearly shown in winmysqladmin.exe, like it knows about
it, but the mySQL.user database shows only root USERS on "Build & Localhost"
and two blanks also...the only way I can currently log on.

Is this a no Win situation? I've been at this for 3 days going in circles
and I suspect UNIX developers are exceeding happy to hear this. Yeah, I'm
using IIS 5.1 instead of Apache too.

Paul

[Aggro]

Paul Muns wrote:

I have a password in my.ini
What do you mean by this? I don't understand what .ini has to do with
passwords.
me: "ERROR 1045: Access denied for user: 'root@localhost' <Using password:
YES>"

Have you tried logging in without password? For example:

c:\mysql\bin\mysql -u root