is there such a software as this
 

is there such a software to monitor what scripts or what object/item is sending queries to a specific table or database and displays a report or a log of queries sent.

thxn

Not that I know of, sorry mate. I usually make it on my own. Simply make a class (if you know how, you're already on your way). In the class (it's a mySQL class btw), you are going to create a function called query. When the $mysql->query(); is called upon, you can insert the query into an array like so; $history = array("sql" => $query);

In any case, something like that. The same you can perform with any given object or item. Fetched, Result or what ever you prefer.

Good luck. :-)

what if someone had access to my server and was sending queries, is there no way to catch what querys he's sending?

being that he created a php script so that loaded it can show him username/passwords or select from a table and show to the page.

MySQL can keep log files for a history of activity, errors, etc. just like Apache keeps logs for httpd activity, errors, etc. A starting point: http://dev.mysql.com/doc/refman/5.0/en/log-files.html