Skip to content

Instantly share code, notes, and snippets.

@skihero
Created March 1, 2011 15:36
Show Gist options
  • Save skihero/849303 to your computer and use it in GitHub Desktop.
Save skihero/849303 to your computer and use it in GitHub Desktop.
Storing password in mysql db
mysql> insert into user values ( 'host' , 'user', PASSWORD('SOMEPASS') ) ;
Query OK, 1 row affected (0.18 sec)
mysql> select * from user;
+------+------+-------------------------------------------+
| Host | User | Password |
+------+------+-------------------------------------------+
| host | user | *E16D008B9B8AD7E8509A5655514EC731A0F9A6A6 |
+------+------+-------------------------------------------+
1 row in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment