Amitava's Technical Diary

Software Architect

Friday, June 24, 2011

Generate MySQL PASSWORD using command line


$ echo -n foo | openssl sha1 -binary | openssl sha1 | tr 'a-z' 'A-Z' | sed 's/^/\*/'


Make sure old_passwords=0 in your /etc/my.cnf
Posted by Amitava Shee at 12:09 PM

No comments:

Post a Comment

Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2011 (9)
    • ▼  June (5)
      • Generate MySQL PASSWORD using command line
      • Minimal CentOS packages
      • Qemu creates a spurious 23.1 MB ATA QEMU HARDDISK
      • Solution to jruby bug# 5730 - gem update --system ...
      • KVM bare metal as non-privileged user
    • ►  April (3)
    • ►  February (1)
  • ►  2010 (22)
    • ►  August (4)
    • ►  July (1)
    • ►  June (3)
    • ►  May (3)
    • ►  April (1)
    • ►  February (5)
    • ►  January (5)
  • ►  2009 (8)
    • ►  December (3)
    • ►  November (1)
    • ►  July (3)
    • ►  February (1)
  • ►  2008 (7)
    • ►  May (1)
    • ►  February (6)

About Me

Amitava Shee
View my complete profile
Simple theme. Powered by Blogger.