May
5

You can recover MySQL database server password with following five easy steps.

Stop services:

# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables &

Login:

#mysql -u root

Output:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Type:

mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit

Done!

Just make sure you stop mysql then start normal:

/etc/init.d/mysql stop
/etc/init.d/mysql start

Give a try login with root then type your new password:

mysql -u root -p

Have fun!



©Web design Costa del Sol | SEO Marbella
0
November
9

Setup Rsync

Posted In: Debian, Fedora, Ubuntu, server by IT-Design

#apt-get install rsync
# ssh-keygen -t rsa

press ENTER for all questions.

# cd /root/.ssh
# cp id_rsa.pub myserver

send SPC to the remote server:
# scp /root/.ssh/myserver 192.168.1.2:/var/tmp/

send SPC on different port
# scp ‘-P 2848′ /root/.ssh/myserver 192.168.1.2:/var/tmp/

if you receive an error use the following command to clean the old value on the local and online server:
sed -ie 1d ~/.ssh/known_hosts

Edit /etc/ssh/sshd_config
RSAAuthentication yes
PubkeyAuthentication yes

reload ssh server:
# /etc/init.d/ssh reload

open the remote server and change permition:

# cd /var/tmp/
# cat myserver && ~/.ssh/authorized_keys

run test on the local server: # rlogin 192.168.0.1

COPY FILES OVER SERVERS
# rsync -avz 192.168.1.2:/var/scripts/ /var/scripts/

USING DIFFERENT SSH PORT
# rsync -avz –rsh=’ssh -p2848′ 192.168.0.1:/var/scripts/ /var/scripts/



©Web design Costa del Sol | SEO Marbella
0
November
9

Install Spamassassin

Posted In: Debian, Fedora, Ubuntu, server by IT-Design

# apt-get install spamassassin spamc

<br># groupadd spamd
<br># useradd -g spamd -s /bin/false -m -d /home/spamassassin spamd

<br>#  /etc/init.d/spamassassin stop
<br>#  /etc/init.d/spamassassin start



©Web design Costa del Sol | SEO Marbella
0
November
9

Install webmin

Posted In: Debian, Fedora, Ubuntu by IT-Design

#install dependencies
apt-get install libnet-ssleay-perl openssl libauthen-pam-perl libio-pty-perl libmd5-perl

#download webmin:
wget http://garr.dl.sourceforge.net/sourceforge/webadmin/webmin_1.480_all.deb

#install webmin
dpkg -i webmin_1.470_all.deb

You can now access using the url https://your_ip:10000/



©Web design Costa del Sol | SEO Marbella
0