Ordinary People

October 28, 2009

How to remote MysqL @Linux ConsoLe

Filed under: hacking — haru @ 11:47 pm
How to remote
MSQL Database on Linux Console .... If I was able to
Hacked site. do not forget certain config files
I save the database Uh .. anyone know
we caught admin shell continues deleted ..
So we still have a spare .. ngahaha ...
Know who the next month or next year when
We've checked it was updates CC again lol
Ok .. First the need to provide SSH account, the user can also ...
The point's already msqlnya version 4 or 5 will be out confirmation
see below

root @ noc1: / home / noc-HQ # apt-get install mysql-client-5.0

example of my config file:
This config file (config.php)
$ http://www.punchwithjudy.com.au/shop sql_dns = ';
$ sql_host = 'caelum.netregistry.net';
$ sql_user = 'myxcar1284';
$ sql_db = 'xcart_punchwithjudy_com_au';
$ sql_password = 'Secret :p';

root@hacking ~]# mysql -h caelum.netregistry.net -u myxcar1284 -p
xcart_punchwithjudy_com_au
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 61477463 to server version: 4.1.22-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> help

For information about MySQL products and services, visit:
http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Network Support, training, or other products, visit:
https://shop.mysql.com/

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
?         (\?) Synonym for `help'.
clear     (\c) Clear command.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter. NOTE: Takes the
rest of the line as new delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute an SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
charset   (\C) Switch to another charset. Might be
needed for processing binlog

with multi-byte charsets.

warnings  (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.
For server side help, type 'help contents'
mysql> status

--------------

mysql  Ver 14.12 Distrib 5.0.27, for redhat-linux-gnu (i686)
using readline 5.0
Connection id:        61477463
Current database:    xcart_punchwithjudy_com_au
Current user:        myxcar1284@64.136.60.193
SSL:            Not in use
Current pager:        stdout
Using outfile:        ''
using delimiter:    ;
Server version:        4.1.22-standard
Protocol version:    10
Connection:        caelum.netregistry.net via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:        3306
Uptime:            76 days 13 hours 22 min 57 sec
Threads: 73  Questions: 2308234562
Slow queries: 75666

Opens: 5898321  Flush tables: 1

Open tables: 9999  Queries per second avg: 348.962

see further instructions on
command help ...: P
gud luck: D

Bandwith management

Filed under: Linux — haru @ 11:32 pm
1.91Mb            3.81Mb            5.72Mb            7.63Mb      9.54Mb
└────────────────┴─────────────────┴─────────────────┴─────────────────┴─────────────────
87.106.137.17:http             => 10.0.0.21:cft-0                 23.4Kb  53.9Kb  24.9Kb
 <=                                  528b   1.37Kb   641b
74.125.96.102:http             => Doorz.Net:sybase-sqlany         82.0Kb  52.7Kb  40.4Kb
 <=                                 2.09Kb  1.63Kb  1.16Kb
74.200.94.11:http              => SMK-Bunda_Satria:50140          70.3Kb  46.9Kb  45.4Kb
 <=                                 1.30Kb   979b   1.02Kb
vlaai.snt.utwente.nl:http      => 10.0.0.58:4339                  35.2Kb  44.5Kb  50.1Kb
 <=                                  800b   1.03Kb  1.16Kb
74.125.209.241:http            => Doorz.Net:panja-axbnet          11.7Kb  43.4Kb  45.1Kb
 <=                                  416b   1.22Kb  1.23Kb
117.121.299.5:8291             => NOC-Monitoring:4289             38.6Kb  38.6Kb  38.6Kb
 <=                                 3.34Kb  3.38Kb  3.38Kb
38.99.76.160:http              => 10.0.0.21:bmc-net-adm           41.0Kb  31.6Kb  11.4Kb
 <=                                  640b    723b    413b
vlaai.snt.utwente.nl:http      => SMK-Bunda_Satria:slinterbase    11.7Kb  29.3Kb  7.63Kb
 <=                                  320b    704b    303b
10.0.0.1:42610                 => Resident.Net:ssh                7.92Kb  8.73Kb  8.84Kb
 <=                                 19.3Kb  21.0Kb  21.0Kb
67.205.49.180:http             => 10.0.0.7:netopia-vo3            17.6Kb  25.8Kb  12.0Kb
 <=                                  480b    576b    316b
121.14.243.118:http            => 10.0.0.111:4413                 16.4Kb  25.2Kb  30.7Kb
 <=                                  576b    726b    815b
119.110.77.114:http            => Kho-Liok-Koan:trustestablish       0b   23.4Kb  9.72Kb
 <=                                    0b   1.01Kb   550b
74.86.232.183-static.reve:http => 10.0.0.111:vnsstr                  0b   23.5Kb  5.87Kb
 <=                                    0b    979b    245b
119.110.77.114:http            => Kho-Liok-Koan:wrs_registry      58.6Kb  22.3Kb  21.5Kb
 <=                                 1.80Kb   774b    846b
a909sm.avast.com:http          => Lintang.Net:startron            17.6Kb  21.1Kb  6.21Kb
 <=                                  480b    544b    283b
119.110.77.114:http            => Kho-Liok-Koan:mon               53.2Kb  20.0Kb  10.6Kb
 <=                                 3.03Kb  0.99Kb   571b
119.110.77.114:http            => Kho-Liok-Koan:scipticslsrvr     23.4Kb  20.0Kb  10.3Kb
 <=                                 1.00Kb   851b    485b
122.152.142.13:http            => 10.0.0.111:ssslic-mgr            160b   19.1Kb  5.75Kb
 <=                                  160b    506b    271b

─────────────────────────────────────────────────────────────────────────────────────────
TX:             cumm:  36.0MB   peak:   1.54Mb           rates:   1.36Mb  1.27Mb  1.34Mb
RX:                    6.33MB            686Kb                     225Kb   200Kb   256Kb
TOTAL:                 42.3MB           1.84Mb                    1.58Mb  1.46Mb  1.59Mb

Description of the above to view:
87.106.137.17  => 10.0.0.21:cft-0     23.4Kb  53.9Kb  24.9Kb

 <=                     528b   1.37Kb   641b

=> : means the traffic that comes from 87.106.137.17 ke host 10.0.0.21:cft-0
<= : means the traffic that comes from Doorz.Net:sybase-sqlany  ke 74.125.96.102:http

Now look at the three far right column, there is 23.4Kb 53.9Kb 24.9Kb
Starting from the far left, is the amount of data received by the host
in 2-second interval that is counted
The next column shows the data received in 10 seconds,
and the last in a period of 40 seconds.

Introduce my self

Filed under: Diary — haru @ 6:41 pm
    introduce, my name is my haru comes from a small town
in the southern part of Central Java,
and now I work in a company's Internet Service Provider
I finally finished my blog again, this is not the first time I made a blog
many times but all is never neglected, and I took the initiative to make a new blog
I wanted to write again, and hopefully these articles
useful for friends of all who read,,
thanks

Powered by WordPress