adspace


What is the datatype for password in mysql?

Answer Posted / Kum Anshu Gupta

In MySQL, the password field should typically be of type VARCHAR or BLOB. However, for storing hashed and salted passwords securely, it's recommended to use the blob type (such as BINARY(40) or BLOB) with a hashing algorithm like SHA-256.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is current version of mysql?

1084


How to Change a users password from unix shell.

1223


What is the current mysql version?

1105


Which statement is used in a select query for partial matching?

1247