Tuesday, October 20, 2009

Ubuntu: How to reset MySQL password?

Problem: Forgot the password to login mysql.
Solution: Need to reset password.
First, just take few minute checking the default password in file debian.cnf

Command line: sudo gedit /etc/mysql/debian.cnf

Then type this command;
mysql -u debian-sys-maint -p
Enter password:
*Please enter the password stated in the debian.cnf

Then when you logged-in,
mysql >

Type the command to set new password.

Mysql > SET PASSWORD for 'root'@'localhost'= 'my_new_password';

exit.

Then test the new password.
mysql -u root -p
Enter password: my_new_password

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

Have a nice day!

Wednesday, October 14, 2009

UBUNTU 9.04: How to fix error - SSH connection refused?

OpenSSH is a freely available version of the Secure Shell (SSH) protocol family of tools for remotely controlling a computer or transferring files between computers.
If the openssh-server not installed yet, you will get error : openssh connection refused.
It is not about firewall disable.

When you cannot remote to the other PC or server in the network, just install OpenSSH-server. Use the command line below

sudo apt-get install openssh-server

--------
Good luck! Have a nice day.

Thursday, October 8, 2009

How to install nautilus SVN in Ubuntu 9.04

Client side for SVN


1. The video below is the tutorial for nautilusSVN.


1.1 Refer to this tutorial: Youtube Tutorial


How to install? Step by step.


2. According to a report, nautilusSVN already renamed as RabbitCVS.


Step 1: Go to www.rabbitcvs.org. ## install rabbitvcs

http://rabbitvcs.org/ and download the installer package: rabbitvcs_0.12-1~hardy_all.deb.

http://wiki.rabbitvcs.org/wiki/download


Step 2: Unpack the package.


             sudo dpkg -i rabbitvcs_0.12-1~hardy_all.deb


Step 3: There is some missing package (ipython) that not installed. Then install ipython package.


           sudo apt-get install ipython meld


Step 4: Solve this error :: E: Unmet dependencies.


          sudo apt-get -f install


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


Note: Thanks to my friend, Wahid. -:)