How should I store data into my Mysql database, what type should I assign to a column storing salt values?

Salt is used to store your data securely. If we have to store user password securely, we need to use salt.

$pwd=hash(hash($password) + salt)

then store $pwd in your system instead of the real password.

So, the question is, how to define the salt value. Here is how:

// if (saltBytes == null)
{
   // Define min and max salt sizes.
   int minSaltSize = 4;
   int maxSaltSize = 8;

   // Generate a random number for the size of the salt.
   Random random = new Random();
   int saltSize = random.Next(minSaltSize, maxSaltSize);

   // Allocate a byte array, which will hold the salt.
   saltBytes = new byte[saltSize];

   // Initialize a random number generator.
   RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();

   // Fill the salt with cryptographically strong byte values.
   rng.GetNonZeroBytes(saltBytes);
}

Prasanna Kotamraju

Updated on 27-Jun-2020 06:24:57

• Related Questions & Answers
• How should I manage my life?
• My girlfriend never appreciates me, what should I do?
• Best data type for storing currency values in a MySQL database?
• Why should we not store a number into a MySQL ENUM column?
• Being a girl should I give importance to my looks?
• Should I include type=“text/javascript” in my SCRIPT tags?
• What Should I Do If My IP Address Is Exposed?
• How should I display MySQL database that is currently in use?
• Which one should I use? The datetime or timestamp data type in MySQL?
• What should I do if someone copies my website/blog content?
• Should I store a field PRICE as an int or as a float in the database?
• When should I use MySQL compressed protocol?
• What type of datatype should I use (MySQL) with a mix of string and number?
• What is SIP and How should i start?
• What should one use CHAR data type or VARCHAR data type in MySQL?