+- Sinisterly (https://sinister.li)
+-- Forum: Hacking (https://sinister.li/Forum-Hacking)
+--- Forum: Tutorials (https://sinister.li/Forum-Tutorials)
+---- Forum: Requests (https://sinister.li/Forum-Requests--826)
+---- Thread: Read SQL File? (/Thread-Read-SQL-File)
Read SQL File? - Tentacion - 04-10-2019
Is there any way to read the text in a SQL file? Like passwords for example.
RE: Read SQL File? - FreightTrain - 04-10-2019
There's a lot of ways to do it, but I'd recommend using an actual database program. Something like MySQL or SQlite are both free and relatively user friendly. Depending on how large your file is, you may want to explore other options as well. Run through the setups, open your file, and use a command like "SELECT *;" and everything should be displayed. SQL basics are pretty easy to google and come up with the right answers, so I'd start there if you run into issues. If you need extra help, you're welcome to message me.
RE: Read SQL File? - FreightTrain - 04-11-2019
(04-10-2019, 09:59 PM)Tentacion Wrote: Is there any way to read the text in a SQL file? Like passwords for example.
Your inbox is full, but I'll post my reply here.
Yes it's very easy to retrieve usernames and passwords. That's mainly why I said to user an actual database program. Everything should be organized already. Your query will essentially be "SELECT USERNAME, PASSWORD FROM -TABLE NAME-;" You may have to use a JOIN though if they are in separate tables, just depends on how the db is setup. It's hard to just say what query you'll use without seeing the db though. "SHOW TABLES;" may help you figure that out. I'd just look through W3School's SQL tutorials to learn a few basic commands. SQL is pretty easy to understand and learn the basics of. There's a lot to it though if you really get into it.
If you mess around and still have issues, let me know specifically and I'll see what I can come up with.
RE: Read SQL File? - Tentacion - 04-11-2019
(04-11-2019, 01:35 AM)FreightTrain Wrote:(04-10-2019, 09:59 PM)Tentacion Wrote: Is there any way to read the text in a SQL file? Like passwords for example.
Your inbox is full, but I'll post my reply here.
Yes it's very easy to retrieve usernames and passwords. That's mainly why I said to user an actual database program. Everything should be organized already. Your query will essentially be "SELECT USERNAME, PASSWORD FROM -TABLE NAME-;" You may have to use a JOIN though if they are in separate tables, just depends on how the db is setup. It's hard to just say what query you'll use without seeing the db though. "SHOW TABLES;" may help you figure that out. I'd just look through W3School's SQL tutorials to learn a few basic commands. SQL is pretty easy to understand and learn the basics of. There's a lot to it though if you really get into it.
If you mess around and still have issues, let me know specifically and I'll see what I can come up with.
Thank you man. Appreciate you posting here even though my inbox was full. I will try downloading the program and see how it goes. Do you have discord by any chance?