Forum Replies Created
- Posts
Feel free to ignore my previous question. Just looked at the lecture again and Zaid does manage to change the password. I just realised that I was following the lecture with the security level set to high which is why it was doing something different and therefore the reason it didn’t work. I’ll have to do the lecture again but not today.
Sorry about that.
Regards
Nick
Ok, thanks for the response. How would I select a few of the columns at a time? Is there a particularly clever way of doing it in MySQL?
Regards
Nick
Well that’s a dilema as when I press the backslash key on my keyboard in metasploitable I get a greater than symbol. I still get a greater than symbol when I press the shift key as well. Not sure how to get a bar as I tried a whole range of other things including cut and pasting and so on. Do you have any other ideas?
Thanks and regards
Nick
I’m a little chuffed with myself and just thought I’d share with somebody who might understand. I cracked the problem of how to get the results to display page by page with the ‘pager less’ command before running my select command so then the results are displayed page by page. The only issue now and perhaps you could shed some light on this is the when I run the following commands in MySQL on the metasploitable VM
show databases;
use information_schema;
pager less;
select * from tables;The results whilst shown page by page are very chaotic and not all lined up neatly as in the results of show databases for example. Would you happen to know why?
Regards
Nick
Thanks for your reply, that certainly sheds a little light on the subject. The only problem or at least one of the many that I have remaining is how can I scroll page by page through a list a results when I perform a query that yields a large number of rows?
Thanks again and regards.
Nick
So is table_name a column name from information_schema.tables (even though I haven’t been able to find it yet) and how does table_schema fit in with that?
Sorry to go on but I’m just trying to get my head around what is happening.
Regards
Nick
Or is table_schema a different command that means something other than what I think it means. Sorry I’m probably rambling now!
Have a nice day!
Nick
I think what was confusing me was the table_schema = ‘owasp10’. I thought that this was a table in information_schemata.tables and wanted to have a look to see if it was there and the information it contained. I assume it contains information about which database particular tables come from. Well maybe. I could be wrong please could you clarify.
Thanks and regards
Nick
Ok I started mysql on the metasploitable VM and entered the following command:
select table_name from information_schema.tables;
Having first used the command:
show databases;
Just to practice navigating and exploring the available databases on metasploit to see if I could understand it further. However, the results from the select table_name…. command were 430 rows and I could only see the last few. Hence, my question, in Linux I think you are able to control how information scrolls through the terminal with the more or less command (I think, please correct me if I’m wrong). So is it possible to do this in MySQL. Have the terminal display a page of rows and then press a key to display more so that you can peruse the information at leisure. I searched google and it seemed to indicate that you should use pager but when I used the \P I got an error saying pager was not my default pager and I couldn’t figure out how to set it up so it was. I hope this makes more sense about what I’m trying to achieve and you can help me.
Regards and thanks again.
Nick
Thank you so much for your patience and taking the time to explain it further to me. One day, I live in the fear that I might understand all of this but not today. Although I do understand a little more. I understand now why Zaid chose to add the union command. But what would have made him decide to use select 1,2,3,4,5. I understand that using the order by statement he could determine the number of columns in the table. But the column headings much have been unknown at that point. So why choose select 1,2,3,4,5. Is it just a knowledge of SQL which I don’t have at present or something else?
Thanks again and regards
Nick
It looks like my original message was blocked when I typed out the full statement Zaid used. Anyway, all I really wanted to know was a method that I could look at a table in mysql page by page.
Regards
Nick
