Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Password Problem with User Manager

forums › forums › SQLyog › Using SQLyog › Password Problem with User Manager

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • April 23, 2003 at 2:19 pm #14131
      CalEvans
      Member

      It's not supposed to be necessary but have you tried a

      FLUSH PRIVILEGES;

      just to make sure everything gets committed?

      =C=

    • April 23, 2003 at 7:05 pm #14132
      lennyh
      Member

      Yes, I've tried Flush Privileges. I've also tried completely exiting SQLYog and restarting it. I've also tried stoppping MySQL and restarting it. In all cases the results are the same — I can't login using the new username and its password, but I can login using the new username w/ a blank password.

      Here's some more info: After exiting SQLyog, I tried logging in from the mysql cmd line. As it turns out, in this case as well I cannot login with the new username and its password. But once again I can login with the new username and a blank password. So this login anomaly is not restricted to logging in via SQLyog. It's like MySQL itself is not interpreting the password portion of the user table???

      I must be overlooking something simple.

      Lenny

    • April 23, 2003 at 11:41 pm #14133
      lennyh
      Member

      I finally figured it out. My problem had nothing to do wtih SQLyog.

      My MySQL user table contained a blank username and blank password entry (anonymous entry). The anonymous entry takes precedence over the new entires containing passwords, so entering a password with the new username results in a mismatch.

      I'm sure this is an error frequently made. It sure puzzled me for quite a while.

      Lenny

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.