How to encrypt my password in phpMyAdmin for my own cms website

Question

I am creating a login system for my own website so I can update it via a form. I have manually added myself to a table in the database I called users, although there will only ever be me, and I added my password plain text. However, I have since being reading about hashing passwords, but from what I can see this is only done from a php function, can I do it in phpMyAdmin using just the sql section?

Answer 1

If you edit the structure of your table, there should be a column called "Function". There you can select MD5, and any value stored in that Field will become hashed. So if you already have a password stored in your table, it will become hashed aswell.

Like this: http://www.xodino.it/wp-content/uploads/file/ubuntuftp/pureftpd-02.png

Answer 2

Have a look here: http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html

But if you want to do it with PHP take a look here. That's a good article about password hashing: http://phpsec.org/articles/2005/password-hashing.html