SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Jan 2002
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy 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.

  2. #2
    SitePoint Zealot
    Join Date
    Nov 2001
    Location
    Earth
    Posts
    103
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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
    http://www.serverexpert.com/ Discuss servers and the software that makes them work.
    http://www.webmasters-resources.com/ Resources for webmasters.

  3. #3
    SitePoint Member
    Join Date
    Jan 2002
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  4. #4
    SitePoint Zealot
    Join Date
    Nov 2001
    Location
    Earth
    Posts
    103
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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
    http://www.serverexpert.com/ Discuss servers and the software that makes them work.
    http://www.webmasters-resources.com/ Resources for webmasters.

  5. #5
    SitePoint Member
    Join Date
    Jan 2002
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •