SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    Mar 2007
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Why doesn't it work??

    Frustrating... I expect the error's mine, but I can't see it.

    I followed Kevin Yank's instructions exactly on the Lynda.com PHP tutorial. Everything went exactly as shown, UNTIL I got to the very last item: setting a password.

    When at the prompt, I typed (even using the same simple password):

    >>>>
    UPDATE mysql.user SET Password=PASSWORD<"mypassword"> WHERE User="root";

    I only get:

    ERROR 1064 <43000>: you have an error in your SQL syntax: check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE User="root"' at line 1

    What am I not doing right??????

  2. #2
    SitePoint Wizard bronze trophy Kailash Badu's Avatar
    Join Date
    Nov 2005
    Posts
    2,560
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    UPDATE mysql.user SET Password=PASSWORD<"mypassword"> WHERE User="root";
    Is that how your query exactly looks like?

    Code:
    It's supposed to be like this:
    UPDATE mysql.user SET Password='mypassword' WHERE User='root';

  3. #3
    SitePoint Addict
    Join Date
    Oct 2003
    Location
    United States
    Posts
    281
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    And if you use the password function, it'll be surrounded by parenthesis.

    ie.
    Code:
    UPDATE mysql.user SET Password=password('mypassword') WHERE User='root';

  4. #4
    SitePoint Member
    Join Date
    Mar 2007
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Kailash Badu View Post
    Is that how your query exactly looks like?

    Thanks much for the response.

    Yes-- that's exactly the way it was entered in the tutorial.

    But going back to try the again with what's been posted here, I now get the "Enter password:" prompt, but ENTER just causes the window to close.

    Apparently somehow what I did last night-- even though I was getting constant errors at everything I tried (and ENTER was working) set a password that I don't know.

    Back to square one. Now what? Is there any way to blow out whatever it's looking for now and start over??

  5. #5
    SitePoint Member
    Join Date
    Mar 2007
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Ok, got it

    Forgot the MySQL service had been set to start manually. Guess it would help to turn it on? Sheesh...

    Working now. After many years working with Cold Fusion scripts, this PHP/MySQL stuff is new...


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
  •