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.
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
where user = "root"
That will give you a list of the host names that the root user can access the server from.
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.
login into mysql on the machine where it is installed. Once you are in mysql, enter the following:
select user, host
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.
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.