Rocover Mysql Password

Sedikit trics buat kakek yang dah pikun dengan password²nya :p
1. Stop mysql
/etc/rc.d/rc.mysqld stop

2. Pindah ke dir di mana mysql kakek berada. Klo mysql cucu berada di direktori /usr/mysql
cd /usr/mysql/

2. Jalankan mysqld_safe dengan option –skip-grant-tables&
./bin/mysqld_safe –skip-grant-tables&

3. Konek ke mysql sebagai root
/usr/mysql/bin/mysql -u root

4. Gunakan database mysql
use mysql;

5. Jalankan perintah update dan ganti —> passwordbaru <— dengan password yang akan kakek
gunakan untuk password mysql.
update user set password = password(‘passwordbaru’) where user = ‘root’ and host=’localhost’;

6. Flush
flush privileges;
7. Keluar dari mysql
quit
8. Stop mysql
/etc/rc.d/rc.mysqld stop

9. Jalankan mysql lagi
/etc/rc.d/rc.mysqld start

# Di Uji pada “mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)”
# Dengan OS Slackware Linux 10.2
# Moga kakek ngga’ lupa lagi dengan password mysql

Iptables

1. FLUSH/DEL RULES
iptables -F

2. NAT
iptables -t nat -A POSTROUTING -s 192.168.10.0/24 -j SNAT –to 202.157.56.3

3. REDIRECT
iptables -t nat -A PREROUTING -p tcp -s 192.168.10.0/24 –dport 80 -j REDIRECT –to-port 3128 –> gateway + squid dalam satu mesin
iptables -t nat -A PREROUTING -p tcp -s 192.168.10.0/24 –dport 80 -j DNAT –to 202.149.79.50:8200 –> gateway terpisah dengan squid

4. BLOKIR CLIENT
iptables -I INPUT -s 192.168.10.5/32 -d 0/0 -j DROP

5. BLOKIR IRC
iptables -I INPUT -p tcp -s 192.168.10.5/32 -d 0/0 –destination-port 6667 -j DROP

6. BLOKIR PORT COMPLETE
for PORT in 69 111 135 137 138 139 213 445 554 1025 1034 1080 1214 2049 4000 4444 4662 4661 6257 6346 6347 6699 6700 7070 10858 31415 48523 54470
do
iptables -A FORWARD -p tcp –dport $PORT -j REJECT
iptables -A FORWARD -p udp –dport $PORT -j REJECT
done

7. REDIRECT ACCESS
iptables -t nat -A PREROUTING -p tcp –dport 3000 -j DNAT –to-destination 192.168.10.4:3000

semua yang access lewat port 3000 otomatis ditujukan ke ip 192.168.10.4 port 3000

bashrc[da]Linux

# /etc/bashrc
# Pertama buat file bashrc di direktori /etc
#vi /etc/bashrc
#kemudian pastekan file ini
#Lalu masukan di /etc/profile masukan kata
# source /etc/bashrc
#Keluar dari shell and jadi dech

PS1=’\[33[1;34m\]\[33)016\]\[\]lq\[1733(B\](\[33[1;32m\]\u\[33[1;34m\]@\[33[1;32m\]\H\[33[1;34m\])(\[33[1;32m\]\T\[33[33[1;34m\])\n\[33)016\]\[\]mq\[1733(B\]\[33[1;34m\](\[33[m\]\w\[33[1;34m\])\[33[1;34m\]->\[33[0m\]‘
echo -e ‘\e[37;44m'"Sugeng Rawuh wonten Anjink-cYborg server"; tput sgr0
# by default, we want this to get set.
# Even for non-interactive, non-login shells.
if [ "`id -gn`" = "`id -un`" -a `id -u` -gt 99 ]; then
umask 002
else
umask 022
fi

# are we an interactive shell?
if [ "$PS1" ]; then
if [ -x /usr/bin/tput ]; then
if [ "x`tput kbs`" != "x" ]; then # We can’t do this with “dumb” terminal
stty erase `tput kbs`
elif [ -x /usr/bin/wc ]; then
if [ "`tput kbs|wc -c `" -gt 0 ]; then # We can’t do this with “dumb” terminal
stty erase `tput kbs`
fi
fi
fi
case $TERM in
xterm*)
if [ -e /etc/sysconfig/bash-prompt-xterm ]; then
PROMPT_COMMAND=/etc/sysconfig/bash-prompt-xterm
else
PROMPT_COMMAND=’echo -ne “33]0;${USER}@${HOSTNAME%%.*}:${PWD/#$HOME/~}07″‘
fi
;;
screen)
if [ -e /etc/sysconfig/bash-prompt-screen ]; then
PROMPT_COMMAND=/etc/sysconfig/bash-prompt-screen
else
PROMPT_COMMAND=’echo -ne “33_${USER}@${HOSTNAME%%.*}:${PWD/#$HOME/~}33\\”‘
fi
;;
*)
[ -e /etc/sysconfig/bash-prompt-default ] && PROMPT_COMMAND=/etc/sysconfig/bash-prompt-default
;;
esac
# Turn on checkwinsize
shopt -s checkwinsize
[ "$PS1" = "\\s-\\v\\\$ " ] && PS1=”[\u@\h \W]\\$ “

if [ "x$SHLVL" != "x1" ]; then # We’re not a login shell
for i in /etc/profile.d/*.sh; do
if [ -r "$i" ]; then
. $i
fi
done
fi
fi