How to insert PwnedPasswordsTop100k.txt into MySQL

Asked Nov 01 '20 at 12:13

Active Nov 01 '20 at 12:29

Viewed 47 times

-2

I obtained the PwnedPassword list of the 100K most common passwords from https://www.ncsc.gov.uk/static-assets/documents/PwnedPasswordsTop100k.txt

How can I insert this list into a MySQL table?

asked Nov 01 '20 at 12:13

Gdev

167
1
11

Do you want to add a blacklist of passwords to MySQL? – silverstorm Nov 01 '20 at 12:17
You can use PHP script like here: https://phpize.online/?phpses=2626c8d6600623c869ba8c616a028433&sqlses=b9cf05a0813143145660112d07cb3b6b&php_version=php7&sql_version=mysql57 – Slava Rozhnev Nov 01 '20 at 12:38
Thanks Slava Rozhnev. That script worked nicely. – Gdev Nov 01 '20 at 17:48

1 Answers1

-2

Use the LOAD DATA LOCAL INFILE

https://dev.mysql.com/doc/refman/8.0/en/loading-tables.html

answered Nov 01 '20 at 12:29

Spectre

1
1

1

It could have been nice if you could have provided an example instead of the direct link. Might have been more useful. – Sajan Nov 01 '20 at 13:09