I am a PHP beginner, just started to study.
I’m trying at the moment create an Application that uses MYSQL on a Docker enviroment.
In the exercise I’m following it’s asking :
“Create a DB in MYSQL with a table holding: (a) a user name (acting as primary key), (b) a secured password, © an arbitrary textual information. The secured password must be pre-pended with a 6 character long salt, then hashed with the SHA-256 algorithm (note that MySQL provides a sha2 method that can be used to realize SHA-256). Both the salt and the hash value are then concatenated and stored in the resp. column of the table”.
My concern is about the password with 6 char long salt. Is there a type salt in mySql?
Can anyone address to a documentation for this or suggest me any hints?
Also: Both the salt and the hash value are then concatenated and stored in the resp. column of the table. Should I create a separate column for this?