What is the datatype for password in mysql?



What is the datatype for password in mysql?..

Answer / 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

More MySQL Interview Questions

What is the use of concat() in mysql?

1 Answers  


How to copy data from one server to another using php?

1 Answers  


How to show table structure mysql?

1 Answers  


What is meant by sharding?

1 Answers  


What are the technical specifications of mysql?

1 Answers  


What are the two types of queries?

1 Answers  


How to include numeric values in sql statements?

1 Answers  


Is mysql an oracle product?

1 Answers  


What does mysql workbench do?

1 Answers  


What is a definer?

1 Answers  


How many ways we can we find the current date using MySQL?

3 Answers  


What are different TEXT data types in MySQL?

1 Answers  


Categories