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!

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.

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. -:)

How to solve Error 2006 - mySQL server has gone away.

When I need to populate data into mysql database, I got this error; Error 2006 - mySQL server has gone away.

How to solve it?

....\xampp\mysql\bin
open my.cnf > drag the icon into Notepad


Then just change the value of max_allowed_packet. In my case, I set 600M.



Save. And restart mysql server.