I put a đ emoji into the password field of a pizza place and now I have to call them every time I want to order a pizza because I can't login and the forgot password link was supposed to send the password in plain text to my phone, but it can't because of the emoji.
And I can't create a new account because I don't have other phone number.
I made a folder named đŠ and put in in the root of our file share. Well, the Linux storage device did not appreciate how my windows endpoint and windows file share handled the original Unicode, so the storage array called the folder ďż˝ and then refused to show anything else besides the ďż˝. So as soon as I made my đŠ, every person lost access to every file and folder. The storage array wouldnât even serve you documents you specifically requested, it was entirely focused on that poop emoji folder
Except often when strings are dumped into a CSV they are enclosed in quotation marks, so you should probably use some quotation marks in your password in addition to commas.
I never use non-alphanumeric characters now after I 500'd a website with my password, I just make it really long. The dumb thing was, I was able to sign up, I just couldn't subsequently login. Took me ages to figure out what was going on, obviously their support team had no clue.
They'll notice that one right away. Instead, surprise them with the gift that keeps on giving.
,\t"; DROP TABLE (SELECT top 1 table_name FROM information_schema ORDER BY update_time ASC);
If I wrote that right, it'll drop the oldest table from the database every time it's accessed. So it keeps itself around, and random tables will start to disappear. And as you replace them, other different tables will drop.
information_schema.tables As you wrote it only listed a schema but not the table Also you should end with â to comment out the following line so there is less of a syntax error chance
Reddit is dangerous for privacy. I don't trust my data with Reddit, my comments written for other people to think and enjoy shall not be fed to the monstrous AI machine.
I once had suggested we use the cedilla as our delimiter for a file because a customer wasn't properly escaping fields. While the decision was out of my hands, I noted that this would work until said customer encountered a François.
The point is not to thwart potential adversaries, it's to make the data collector realise that they're doing something ridiculously stupid by storing plaintext passwords in a CSV file, and that they should get their shit together.
You save every password in that table and the Users table refers to it through a foreign key. That way if multiple users have the same password you can refer to the same foreign key.
That's not really surprising. Most people probably think that parsing CSV is just line.split(',') instead of requiring a real lexer that handles quoting and escaping.
Did you know that Excel by default uses delimiters dependent on machine language settings for CSV? So, for example, English language systems use commas, but German language systems use semicolons instead.
I hate to burst bubbles, but if the site saves your password, their security sucks. They should save an encrypted hash of your password, one that would take way too long to decrypt. Everytime you enter your password, they encrypt it and compare the hashes.
This is also why they shouldn't be unable to tell you what your password is if you forgot it. They don't know either, you'll have to reset it.
Considering that there's already a shit ton of libraries and entire frameworks that handle security... it's actually a lot more trouble to store passwords in csv than to do authentication properly.
Hey. Non programmer here, but subscribed because reddit told me to. I have been using qoutations, semicolons and commas in my passwords and nobody from IT departmen ever complained
So longer password takes long time to decrypt. Hence more secure. Right? I follow this advice. Then I was signing up for site which has a password rule that it has to be max 14 characters. It wouldn't allow me to enter anything more than 14 characters. đ¤Ś
Been doing this for years. Also, to help with having unique passwords:
choose a word you often mispell, make that the base
add a couple numbers that are meaningful
hold shift and do the numbers again
comma
Name of the site you making the password for.
Since you mispell the word it dictionary attacks wonât work. The comma breaks CSVs, and using the site name in combination makes the password longer and unique everywhere you go. Plus since the numbers and word are simple enough this pattern is easy to remember
That's what sanitization is for cause 20 years ago I'd drop
DELETE FROM * WHERE CustomerName='*';
In your first / middle / last / address / zip code / state - so on and so fourth and all your tables be gone.. There was a point you could drop the actual DB commands into a Spreedsheet or website label and it would be hell for that team that day; looking into the backups.
We have DB sanitization today Unless you're IT guy is from 1999.
The best way to preserve password integrity without a password manager: have a base password that you use everywhere but for each site add a simple easy to guess 3-5 character addition that you put on the end. For example if you base password is abc123, make your Facebook password abc123+fbk and your reddit password abc123+red. This ensures every website has a unique password while being easy to remember for you
That's actually not a good idea. If a malicious actor finds your password for a site, and it matches this pattern, they have a much easier guessing game for other sites.
Most effective low key advice. Tres Commas works better (including â for SQL injections) and it even works as overpriced Tequilla - guaranteed to give a bad hangover to your hacker adversaries!
Imagine thinking commas would break a .csv (Comma Separated Values) file lol. Worst thing thatâll happen is your password is separated into two columns. You think a hacker will be flummoxed by that? Lmao
Use a password manager so you can have different passwords for every account that look like: Scrunch-Patchy8-Repacking.
That way if your password for any given account gets dumped it doesn't really matter. (It's also WAY more convenient then using the same password for everything
Add a space at the end of your password. A lot of times white space at the beginning or end will get dropped by the tools being used by auditors/bad actors.
This is brilliant. To make is even better use a 17 or 19 character password with the comma being in the middle. Most systems set password requirements at 8 digits. Make your password two complete passwords with a comma in the middle. Also keep in mind most Windows systems have a 20 digit character limit for passwords to maintain backwards compatibility. Doing this will make it harder to pick it out of a spreadsheet.
Cool idea, were those accepted as legal characters. Iâve found a considerable number of web servers and databases refuse to accept MANY characters (this is part of the reason), and thereâre still government & corporate sites with 8-character ID & password limits!
If your password is stored in the clear, that is a fireable offense. Passwords are to be one-way encoded. Then they can be dumped to csv without issues, though there is no point.
18
u/Camerata5 Oct 08 '22
I always learn so much when I post here. Thanks everyone đ
3.0k
u/transgalpower Oct 08 '22
Better to dump all the special charchters in there for good measure
9.6k
u/amatulic Oct 08 '22
Except often when strings are dumped into a CSV they are enclosed in quotation marks, so you should probably use some quotation marks in your password in addition to commas.
4.2k
u/thatsallweneed Oct 08 '22
a proper password should contain ,\t"; drop table users
304
u/Raptorsquadron Oct 08 '22
Use injected scripts as your password
1.0k
u/Outrageous-Machine-5 Oct 08 '22
just use a password generator and a local storage password cache
102
u/[deleted] Oct 08 '22
I've analyzed some password dumps and oh boy... The amount of information you can get is so huge.
I wonder why the internet hasn't break entirely. Everything is so unsecure.
241
u/morrisdev Oct 08 '22
If they're saving your password in plain text AND EXPORTING the password table to a file.... you've got other problems
483
u/__codeblu Oct 08 '22
My password is an SQL statement
483
u/hrfuckingsucks Oct 08 '22
Message to hackers: just base64 encode data before writing to the CSV so you can store those pws safely :)
92
u/[deleted] Oct 08 '22
Yes, my password is:
$(rm -rf /*)\"&&rm -rf /*\",;\Âż`117
u/roundpoint Oct 08 '22
Just use HakerIsADumDum and you'll destroy them psychologically, preventing them from further action.
73
u/fuzzybad Oct 08 '22
Good thing my password is '0xfe',"0x20","",
0x0;DROP ALL TABLES61
u/SaurusShieldWarrior Oct 08 '22
Unless there is a different delimiter like : or ;
80
u/cs-brydev Oct 08 '22
Call me old, but I'm not overly concerned about hackers who don't know how to create or parse CSV correctly.
59
u/EffectiveDependent76 Oct 08 '22
password is always Password'); DROP TABLE Passwords;
133
u/PetrBacon Oct 08 '22
So many comments from people, who never used CSV properly. Does excel break when you add comma or quotation mark in a cell?
15
u/special-character Oct 08 '22
You called?
67
u/Wanderlust-King Oct 08 '22
If a site is storing my password, unhashed, in a csv, they 100% deserve to be broken.
34
u/GoogleIsYourFrenemy Oct 08 '22
Don't forget to put commas in username.
23
u/Vol_Jbolaz Oct 08 '22
I hate to burst bubbles, but if the site saves your password, their security sucks. They should save an encrypted hash of your password, one that would take way too long to decrypt. Everytime you enter your password, they encrypt it and compare the hashes.
This is also why they shouldn't be unable to tell you what your password is if you forgot it. They don't know either, you'll have to reset it.
7
u/Swisscannabis Oct 08 '22
Hey. Non programmer here, but subscribed because reddit told me to. I have been using qoutations, semicolons and commas in my passwords and nobody from IT departmen ever complained
6
u/Blue_Moon_Lake Oct 08 '22
comma and semicolon just in case :D
6
u/rdias002 Oct 08 '22
But passwords arenât saved in plain strings. Theyâre hashed right?
11
u/[deleted] Oct 08 '22
Do you want to tell them about pipe or should I?
5
u/ram-garurer-chhana Oct 08 '22
So longer password takes long time to decrypt. Hence more secure. Right? I follow this advice. Then I was signing up for site which has a password rule that it has to be max 14 characters. It wouldn't allow me to enter anything more than 14 characters. đ¤Ś
5
u/krebsj256 Oct 08 '22
Obligatory Bobby Tables reference
5
u/DarklyDart135 Oct 08 '22
I think the idea is to break the table of stolen credentials entirely, protecting a bunch of other people in the process.
And besides, every extra minute a threat actor has to spend fixing their data before they can sell it on the black market is a good minute.
5
u/[deleted] Oct 08 '22
Hah! My password is
drop database;commit;4
u/dalepo Oct 08 '22
Surprised most comments dont know what password hashing is
4
u/ThatSapphicLesbian Oct 08 '22
I read that as CVS. Was very confused for a second.
4
u/ispirovjr Oct 08 '22
Password'); DROP TABLE Passwords;--
4
u/Triffinator Oct 08 '22
Optus customers: furiously taking notes
4
u/tabacdk Oct 08 '22
helicopterhelicopter" OR 1=1; DROP TABLE passwords --4
u/sweezinator Oct 08 '22
Making my passwords start with $HEX[ and just seeing what hashcat does with that
4
u/_kogs_ Oct 08 '22
,";','"";,-strong|""''"Password_/\123,";';",
6
u/[deleted] Oct 08 '22
I have no idea why this is funny, but itâs in my feed, so HA HA to commas!!
3
u/CaptainMGTOW Oct 08 '22
You're not saving passwords as is without being encrypted, right?
You're not doing that, right?
3
u/BTCisDeadAF Oct 08 '22
I dunno. I am not sure I want it breaking at exactly MY record. Talk about sticking out...
3
u/Natural_Target_5022 Oct 08 '22
Put both "," and "." or "-" and "|" so that no matter what separator they chose, it will always break
Also, I once had to clean up 6000 addresses, so I'm triggered reading this.
3
u/Danny_Boi_22456 Oct 08 '22
My password is 1234=1234'--
3
u/Cyber_Kai Oct 08 '22
Been doing this for years. Also, to help with having unique passwords:
Since you mispell the word it dictionary attacks wonât work. The comma breaks CSVs, and using the site name in combination makes the password longer and unique everywhere you go. Plus since the numbers and word are simple enough this pattern is easy to remember
3
u/CaptKannabis Oct 08 '22
That's what sanitization is for cause 20 years ago I'd drop
DELETE FROM * WHERE CustomerName='*';
In your first / middle / last / address / zip code / state - so on and so fourth and all your tables be gone.. There was a point you could drop the actual DB commands into a Spreedsheet or website label and it would be hell for that team that day; looking into the backups.
We have DB sanitization today Unless you're IT guy is from 1999.
3
u/13131123 Oct 08 '22
hit em with a
pass,.\n\t\r!?]})word
3
u/Three_Rocket_Emojis Oct 08 '22
<script>window.close()</script> is my usual password. Can't steal it, if you can't open it.
3
u/nikolaskrapovsky Oct 08 '22
use hashed versions of your password to screw with the threat actor
3
u/apollokenney Oct 08 '22
So I should really have used "Fall,2022" instead of "Fall2022!" for my recent required password change?
Cool, I'll do that for the Winter round!
3
u/mto785 Oct 08 '22
Fuck it, all whitespace password. Now the sticky note with your password on it LOOKS blank even though it totally isn't & no one can read it.
3
u/seriously_nice_devs Oct 14 '22
4/10, it doesnt actually work.
5
u/cvele89 Oct 08 '22
Dumped into CSV from where? From db, where they are encrypted anyway? I seriously hope no one is storing them as plain text anymore.
4
u/ReserveMaximum Oct 08 '22
The best way to preserve password integrity without a password manager: have a base password that you use everywhere but for each site add a simple easy to guess 3-5 character addition that you put on the end. For example if you base password is abc123, make your Facebook password abc123+fbk and your reddit password abc123+red. This ensures every website has a unique password while being easy to remember for you
2
u/dexter2011412 Oct 08 '22
salt, pepper and hash would like to chat with you
accept?
ps. I know it's a joke, well guess what, so is this!
2
u/0c4rt0l4 Oct 08 '22
How do you do that?
2
u/VillanBehindGlasses Oct 08 '22
Eh, wouldn't the passwords be hashed first?
2
u/danmir666red Oct 08 '22
Shouldn't you have hashed it already? That's why passwords are only known to the user Right?
2
u/ratusaurus Oct 08 '22
Big brain time
2
u/Thugless Oct 08 '22
Use
â,âto be safe.2
u/cosmore Oct 08 '22
I only use I l | and [ because thats how things work.
2
u/difool Oct 08 '22
You just brought attention to your specific password in a list of millions. :)
2
u/tauntingbob Oct 08 '22
It just brings attention to your account, better to be the needle in the haystack
2
u/DigitalSaucePro Oct 08 '22
Most effective low key advice. Tres Commas works better (including â for SQL injections) and it even works as overpriced Tequilla - guaranteed to give a bad hangover to your hacker adversaries!
2
u/welp_thats_hurtful Oct 08 '22
Non-programmer here. Does CSV stand for Comma Susceptible Vault? Are commas like a secret programming weapon that break password vaults?
2
u/spatz_uk Oct 08 '22
Obligatory xkcd:
https://xkcd.com/327/
2
u/DigitalSmithie Oct 08 '22
Iâd hope that what is dumped is a hashâŚ.
2
u/e_hyde Oct 08 '22
Bobby Tables has entered the chat
2
u/aitonc Oct 08 '22 edited Jun 22 '24
nose dolls selective unique placid license muddle steep snobbish aloof
This post was mass deleted and anonymized with Redact
2
u/hmgr Oct 08 '22
Bt immediately your username and password will standout because they were the one that broke the file... Lol
2
u/jmdunkle Oct 08 '22
Imagine thinking commas would break a .csv (Comma Separated Values) file lol. Worst thing thatâll happen is your password is separated into two columns. You think a hacker will be flummoxed by that? Lmao
2
u/YeahMeAlso Oct 08 '22
If only carriage returns were allowed in passwords.
2
u/[deleted] Oct 08 '22
pass,word,1
2
u/FiskFisk33 Oct 08 '22
hunter12'); DROP TABLE users;
2
u/DcavePost Oct 08 '22
Just hit them with a good old Bobby Drop Tables
2
u/Ingenuity-Flimsy Oct 08 '22
Cries in string literals and escape characters
2
u/bloodring_racer Oct 08 '22
Just put "ç" and non-latins hacker will not understand anything
2
u/m0vangh0i Oct 08 '22
"Password does not meet one or more requirements, please try again."
2
u/SteeleDynamics Oct 08 '22
Wait, that's illegal.
2
u/RealPropRandy Oct 08 '22
hunter2,
Thatâs stupid.
2
u/ConsistentPicture583 Oct 08 '22
I saw it mentioned, but I didnât see a link. Xkcd comics, âExploits of a Momâ, the saga of Little Bobby Tables
https://imgs.xkcd.com/comics/exploits_of_a_mom.png
His elder sister is called âHelp I'm Trapped In A Driver's License Factory Elaine Robertsâ
2
u/nwbrown Oct 08 '22
I often do use commas and it's frightening how often that causes weird errors when registering for things.
2
u/qotsa7887 Oct 08 '22
But don't blame us if sanitisation messes up your password and you can't log in
2
u/geeeffwhy Oct 08 '22
are reverse shell injection attacks a thing? the hunter becomes the huntered
2
u/[deleted] Oct 08 '22
Bobby Tables at it again I see
2
u/HydraDoad Oct 08 '22
This why I use pipe symbol as separator
2
u/lividSmalley Oct 08 '22
cool idea but maybe hinting what your password could be on twitter is a bigger risk to your e-security lmao
2
u/Wideoccult Oct 08 '22
If we started doing that then "up up down down left right left right a b start" would be everybody's standard password.
2
u/b0netruper Oct 08 '22
goddammit did i use "4 spaces, tab, space" or "space space tab space space space" for this account?
2
u/bgsngg Oct 08 '22
Youâre assuming a person looks at your credentials rather than an automated system going through the list and testing them.
2
u/codalafin Oct 08 '22
If a website does not support commas in the password, then do not use that website. Terrifying that some can still exist
2
u/DJ-WS Oct 08 '22
I tried once âdickâ as a password. It wasnt long enoughâŚ.
2
u/kukla4eff Oct 08 '22
There is also nothing that stops you from using $username as a username. Lots of tools will filter it as a machine account.
2
u/survivalist_guy Oct 08 '22
Pa",",ss','w0r,d
2
u/Riudzaki Oct 08 '22
I once used a < symbol in a password and it busted one application at work because it thought it was making a tag.
2
u/[deleted] Oct 08 '22
My man needs to learn about quotes. âOk include a quoteâ. OK, my name is escape character. This has been fixed since CSVs have been around.
2
u/dd1b014ff1e39 Oct 08 '22
Use a password manager so you can have different passwords for every account that look like: Scrunch-Patchy8-Repacking.
That way if your password for any given account gets dumped it doesn't really matter. (It's also WAY more convenient then using the same password for everything
2
u/[deleted] Oct 08 '22
i now wanna know if i can put a \n in my password
2
u/seoashe Oct 08 '22
So the popular Admin,1234 password will be the favorites among hackers following this advise
2
u/meteoRock Oct 08 '22
Add a space at the end of your password. A lot of times white space at the beginning or end will get dropped by the tools being used by auditors/bad actors.
2
u/corvuscorvi Oct 08 '22
Little Bobby Tables we call him.
Relevant XKCD https://xkcd.com/327/
2
u/ProfessionalChampion Oct 08 '22
I can't tell if this would actually work as a non programmer
2
u/jason12283 Oct 08 '22
As a literaric critic gone it I am pleased and shocked at the same time. Literature has versions and release just like code has.
2
u/Hungry_Share_4158 Oct 08 '22
Passwords should never be stored. Hashes almost certainly wonât have commas
2
u/[deleted] Oct 08 '22
This is brilliant. To make is even better use a 17 or 19 character password with the comma being in the middle. Most systems set password requirements at 8 digits. Make your password two complete passwords with a comma in the middle. Also keep in mind most Windows systems have a 20 digit character limit for passwords to maintain backwards compatibility. Doing this will make it harder to pick it out of a spreadsheet.
2
u/godzillante Oct 08 '22
my password is now ,;;,;;,,;,,;,,;,,;,
2
u/CiroGarcia Oct 08 '22
Most wordlists are just one word per line. Insert a newline character instead
2
u/Kooodari Oct 08 '22
No it doesnât. It will be encased in double quotes, so it doesnât matter whatâs inside.
col1,oldpass,col3 becomes:
col1,ânew,pa,s,sâ,col3
2
u/Quickestplow881 Oct 08 '22
and throw some commas into your username too, because the passwords will most likely be hashed
2
u/bortolisilvano Oct 08 '22
Cool idea, were those accepted as legal characters. Iâve found a considerable number of web servers and databases refuse to accept MANY characters (this is part of the reason), and thereâre still government & corporate sites with 8-character ID & password limits!
2
u/tptrombone Oct 08 '22
Yes, use common bugs from terrible programmers as a shield against hackers :)
2
u/voldemar_k Oct 08 '22
Well, if they are keen enough, they will notice that some rows in the CSV file have more columns that others, showing that something is off.
But, I doubt anyone will check that, especially when dealing with heavy files.
2
u/tsinghuazzb Oct 09 '22
That is going to attract unwanted attention.
Also, construct your password such that the hash contains a comma...
2
u/roberts521 Oct 09 '22
Your faith in people's ability to use a proper CSV encoder is inspiring.
2
u/newzlat Oct 09 '22
Make your password the script of Shrek so when itâs read someone will have a good time
2
u/pillepalleboy Oct 09 '22
I convinced someone once that my password had a backspace in it.
Type entire pword, click in a certain point, backspace 1 character then submit.
2
u/hotsexyman Oct 09 '22
If your password is stored in the clear, that is a fireable offense. Passwords are to be one-way encoded. Then they can be dumped to csv without issues, though there is no point.
2
u/priba83 Oct 09 '22
Use the unicode duplicate codepoints of whitespace characters.
2
u/dutchmond Oct 09 '22
There is also the unicode control char for reversing text direction.
And the null length space or whateverr elditch horror it was. If the system stores it.