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!

Hi All,

This little guide is to make the life easier for the new windows users on Ubuntu world…

Installation:

Get your liveCD on http://www.ubuntu.com/ and follow the installation till the end.

Once your Ubuntu installation is ready let’s starting tunning your Ubuntu to make it looks like a windows box.

- Open the Termina on the top left ( Applications->Acessories->Terminal)
- Login as admininstrator, type:

sudo su

once it prompts for the password use the one you choosed when you installed the system.
At this point you should see something like root@username-desktop ..

1 – Update your packages to the latest version, type:

apt-get update
apt-get upgrade

once is finished you’ll be up to the latest version and packages.

Installing Microsoft fonts:
type on the terminal:

 apt-get install msttcorefonts

Installing Messenger( Very similar to MSN ):

apt-get install amsn

View on the desktop My PC, documents, Recicle Bin, Network:
press ALT+F2 then type

gconf-editor

in the box at the top next to the 3 cogs/gears

press enter, now gconf-editor should show up, in the tree view on the left go apps>nautilus>desktop
check the boxes: computer_icon _isible, home_icon_visible, network_icon_visible and trash_icon_visible

Install Emule for download files:
type:

apt-get install amule

That’s it!! You should have now a machine identical to a windows version without need of stupid antivirus or crap Internet Explorer full of bugs and a open door for exploiters…

www.it-design.es

#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/

# 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

#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/