All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
494 views

How to convert hex chars to byte array in mysql

Got sha1 checksum in hexadecimal format(40 characters). Need help to convert hex chars to byte array in mysql. Thanks.
0
votes
1answer
1k views

MySQL passwords SHA512 using AES_ENCRYPT instead of ENCRYPT?

A tutorial is asking me to encrypt passwords using SHA512 in the following manner: INSERT INTO `vir_users` (`id`, `domain_id`, `password` , `email`) VALUES ('1', '1', ENCRYPT('pw1', CONCAT('$6$', ...
1
vote
0answers
61 views

MySQL partitioning by hash not repeatable

I have a MySQL (5.6.17) table with a few million records that I wish to partition. In order to do this, I use this query: ALTER TABLE tablename PARTITION BY HASH(id) PARTITIONS 8; Seems to ...
0
votes
1answer
2k views

Mysql How to insert a variable as field value in a table

I have created a variable named hash as a password hash. How can this variable be inserted a a field value in a table? hash = pbkdf2_sha256.encrypt("password", rounds=200000, salt_size=16) cur....
0
votes
2answers
187 views

How can user determine which hash their password uses?

Is there a query that a MySQL user that does not have admin rights can run to determine if they are using the old (pre-4.1) hash or the new (4.1-and-later) hash? This user was explicitly granted ...