#1
  1. No Profile Picture
    Stephen Cobb
    Guest
    Devshed Newbie (0 - 499 posts)
    Am I missing something with this attempt to change the password on mysql (this is on NT):

    SET PASSWORD FOR root = PASSWORD("newpass");

    gives error

    parse error near PASSWORD FOR root = PASSWORD("newpass");

    Any ideas?

    Thanks...Stephen
  2. #2
  3. No Profile Picture
    Marcelo
    Guest
    Devshed Newbie (0 - 499 posts)
    Hello,
    Try this one:

    Update user set Password=Password('xxxxxxx') where user='root';

    ...and then restart the server for it to take effect.

Similar Threads

  1. MySQL password problems NOT root
    By braveheart in forum MySQL Help
    Replies: 2
    Last Post: February 15th, 2004, 08:18 AM
  2. password generation on user auth.
    By nacho_c in forum PHP Development
    Replies: 14
    Last Post: January 16th, 2004, 04:55 AM
  3. Need Help on setting up apache password protect for vhost
    By GoodSuSe in forum Apache Development
    Replies: 0
    Last Post: May 2nd, 2003, 03:50 PM
  4. setting a password to a cookie.
    By extrovertive in forum PHP Development
    Replies: 2
    Last Post: July 26th, 2002, 02:36 AM
  5. setting root password
    By Nezi in forum MySQL Help
    Replies: 2
    Last Post: July 27th, 2001, 02:27 AM

IMN logo majestic logo threadwatch logo seochat tools logo