mySQL Login Problem

So I have purchased Kevin's book and am just starting. I have PHP and mySQL installed and working. I am doing this at work right now on our peer to peer network. I have them installed on a WIN2K machine with IIS 5.0. I can login to mySQL when I am on the machine locally, but when I try and login from my machine it tells me that I cannot. Here is the exact error message that I am recieving. Any help is appreciated.

Bill

error message:

e:\mysql\bin>mysql -h ben -u root -p
enter password: *****
ERROR 1045: Access denied for user: 'root@WIILIS'
(Using password: YES)

WILLIS is the name of my machine on the network. I am running WIN98 and have BEN's C drive where everything is installed mapped to E.

It's most likely how the user-id is setup within mysql. Root was prob. only authorized for localhost access.

Log into mysql from the local machine (into the mysql database). Then execute:

select user, host
from user
where user = "root"

That will give you a list of the host names that the root user can access the server from.

Frank

I am sorry, but I tried to do what you said and got no where. If you could tell me exactly what to do that would be wonderful. This is the first time that I have ever used mySQL and I have no idea what I am doing. Thanks again.

Bill

NP,

login into mysql on the machine where it is installed. Once you are in mysql, enter the following:

select user, host
from user
where user = "root";

That should return some output. There will be 2 columns of output. The first is the user name (root) and the second will be the hosts that root is allowd to access mysql from.

Frank

I believe that I did that the first time. I even had the ; on the last line. I believe that is the only thing missing from your first post. If I remember correctly it gave me a 1046 error...no database or something like that. I cannot get to the machine right now so I am not sure if that is exact.