Solved Mysql password hashing vs2022

sdowney717 · Jun 8, 2024

hard time posting this
looking at hashing documentation for MYSQL .
MySQL :: MySQL 8.0 Reference Manual :: 14.13 Encryption and Compression Functions

@key_str, @init_vector, @crypt_str, are they COLUMN NAMES?

And those values are being set into a table's column names? In a row?

sdowney717 · Jun 8, 2024

Continued here after 10 fails to post

I figure this is just a db command, not a column name
mysql> SET block_encryption_mode = 'aes-256-cbc';

sdowney717 · Jun 8, 2024

And these are column names being assigned values

Code:

mysql> SET @key_str = SHA2('My secret passphrase',512);
mysql> SET @init_vector = RANDOM_BYTES(16);
mysql> SET @crypt_str = AES_ENCRYPT('text',@key_str,@init_vector);

sdowney717 · Jun 8, 2024

It wont let me post the code in a select statement
Well the thread wont make any sense as I can not post example text for select statement, it is blocked by the site

Then this must be the data retrieval statement here to compare to a user password?
mysql> no one gets to see the code

Catnip · Jun 9, 2024

You might want to ask these questions at a place like Stack Overflow (Stack Overflow - Where Developers Learn, Share, & Build Careers)

You'll probably get more useful answers there.

sdowney717 · Jun 10, 2024

Catnip said:
You might want to ask these questions at a place like Stack Overflow (Stack Overflow - Where Developers Learn, Share, & Build Careers)

You'll probably get more useful answers there.

yes can do that thanks.

Conceptually what does 'My secret pass phrase' represent.
What does 'text' represent?

Which one is the 'key'?

If someone can explain the truth of those, that will help give a clue as to what is what here.

I also found you can select the @vars and get results and I they are not column names, just values.

a picture of the code

sdowney717 · Jun 10, 2024

Those 5 code lines run fine in command window for MariaDB and show the same results.

sdowney717 · Jun 10, 2024

Resolved with some help over here.

I can now understand what that was and also enough to implement salted hashes into my program.
It may actually be a little easier than I thought being it's all a functional part of the DB server.

[RESOLVED] Hashing Mysql example MySQL gives you. Like to know how its used-VBForums

https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_aes-encrypt About the hashing Mysql example they give. I am trying to understand what 'My Secret Passphrase' represents. And what 'text' represents. And how to use this functionality of this DB functions...

www.vbforums.com

Solved Mysql password hashing vs2022

sdowney717

Well-known member

My Computer

System One

sdowney717

Well-known member

My Computer

System One

sdowney717

Well-known member

My Computer

System One

sdowney717

Well-known member

My Computer

System One

Catnip

Forum Nitwit

My Computer

System One

sdowney717

Well-known member

My Computer

System One

sdowney717

Well-known member

My Computer

System One

sdowney717

Well-known member

[RESOLVED] Hashing Mysql example MySQL gives you. Like to know how its used-VBForums

My Computer

System One

Latest Support Threads

Latest Tutorials