Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    63

    Unanswered: About updat password

    Hi folks,


    I have run following command;
    Code:
    GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* 
    TO 'mail_admin'@'localhost' IDENTIFIED BY 'mail_admin_password';

    Now I need changing password.


    Whether run following command;
    Code:
    mysql> UPDATE mysql.user SET Password = PASSWORD('new_password')
        ->     WHERE User = 'mail_admin@localhost';
    mysql> FLUSH PRIVILEGES;
    TIA


    B.R.
    satimis

  2. #2
    Join Date
    Mar 2008
    Posts
    11
    I'm sorry, I didn't see a question explicitly stated and I'm not sure exactly what you're asking. Can you be more specific about what your actual question is?

  3. #3
    Join Date
    Jun 2006
    Posts
    63
    Quote Originally Posted by nineinchnailgun
    I'm sorry, I didn't see a quenineinchnailgunstion explicitly stated and I'm not sure exactly what you're asking. Can you be more specific about what your actual question is?
    Hi nineinchnailgun,


    I was mistakenly typing
    Code:
    ...... IDENTIFIED BY 'mail_admin_password'
    Actually I need to change 'mail_admin_password' to 'mypassword' which is the password I'm going to use.


    B.R.
    satimis

Posting Permissions

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