Learning MySQL- Encryption, Hashing, and Compressing

This episode covers a range of encryption, decryption, hashing, compressing and uncompressing functions in MySQL.

[atriraha]

Sir your voice is so deep you could have send shiver down the spine if you were narrating a story of the genre horror or mystery-thriller.
By the way great video on database encryption. Thanks.

[arthurlara]

Hey Steve, thanks for this content! About the key for encrypt/decrypt, i have a question...

Is it a good idea to create the key from the password itself using a salt value? Or is it better to have a general key for all of the encryptions?

[gillesvangeenen]

Hi Steve, wouldn't it be smarter to save the `hash_pass` as a char instead of a varchar? Because you know it will always be 128 chars long.

[ivanmoya]

Great video, I was wondering if this can be applied to all tables in my database, but I'm concern about performance issues, do you think is recomended?. Thank you

[Sahil_]

hey steve, is it fine that the key should stay in database
is database a safe place for the key

[robertbuckley]

Hey Steve, I like this video and think it's pretty helpful. Sorry if I completely missed this but I'm trying to implement what you've done here into a database table that I have (so the data gets encrypted) but it's not working. I'm thinking it has to do with the way I created the columns for hash_pass, compress_pass, and enc_pass. Is there a tutorial somewhere on how to create those? I have them in the correct place, I think it's just that I didn't configure them correctly. My other question is: can I set this up to run whenever new data comes in, so the data gets encrypted then have it run whenever the data is accessed? I'm building a website where people can sign up and use different online tools I've designed. Basically, I'm trying to create a password management tool where a person can store all their important login information for various platforms.

[samnaghavi]

can you please talk about the ways of protecting the key where should i put it?

[siddharthtiwari]

It's so frustrating to find out that I was doing everything right but my database column was of type varchar and it was not working as expected. Why can't this thing work with varchar data type? I have a huge database with enormous amount of tables and columns changing all will be a nightmare..any idea or suggestions?

[AmanYadav-fetk]

HEY, Steve... I want to learn front-end development .how to follow your channel, please suggest me ..step by step video series...thank you