Wednesday, May 30, 2018

ERROR 1827 (HY000): The password hash doesn't have the expected format

When creating a user with Grant option we have received below error message

ERROR 1827 (HY000): The password hash doesn't have the expected format
That means you have to use hash password. Here is the simple solution that you can use

Enter the password that you want to set and you will get HASH password.
mysql> select password(‘enter password you want');
+-------------------------------------------+
| password(‘enter password you want') |
+-------------------------------------------+
| *B535BN128KK03E74BE2AC0EE23D07ABX6AD8165E |
+-------------------------------------------+
1 row in set (0.00 sec)

Use the has password while creating the user

mysql> GRANT ALL ON *.* TO 'admin'@'%' IDENTIFIED BY PASSWORD '*B535BN128KK03E74BE2AC0EE23D07ABX6AD8165E ' WITH GRANT OPTION;

Query OK, 0 rows affected (0.01 sec)

Thanks
Satishbabu Gunukula, Oracle ACE

5 comments:

  1. I concede, I have not been on this page in quite a while... then again it was another satisfaction to see It is such a critical point and overlooked by such a large number of, even experts. experts. I thank you to help making individuals more mindful of conceivable issues.
    I CAN SEE YOUR VOICE JUNE 2 2018

    ReplyDelete
  2. This is exceptionally instructive substance and composed well for a change. It's decent to see that a few individuals still see how to compose a quality post!
    go pinoy tv
    pinoy watch
    pinoy ako

    ReplyDelete
  3. New updated list of Offline Games :0 check it out
    vex 3
    fnaf

    ReplyDelete
  4. hi!! Exceptionally fascinating examination happy that I ran over such instructive post. Keep doing awesome. Happy to be a piece of your net group.
    BS-CBN generated
    Nets P2.4
    ABS-CBN
    Fire occurrence that murders their parents.
    Full Episode
    Asintado February merely
    Fresh Collection
    Channel Drama
    Pinoy TV

    ReplyDelete