Monday, November 24, 2014

Update MySQL root password in Ubuntu 14.04

Edit /etc/mysql/my.cnf, and add the following line
 skip-grant-tables

Restart MySQL service
 $ sudo service mysql restart

Login to mysql and modify passwords
 $ mysql -u root
 mysql> UPDATE mysql.user set password = PASSWORD('YOUR NEW PASSWORD') where user = 'root' and host = 'localhost';
 mysql> quit

Restart MySQL service
 $ sudo service mysql restart

You should be able to login to MySQL with your new password
 $ mysql -u root -p

Tuesday, August 5, 2014

Can not log in to Skype in Ubuntu

Skype 4.2 worked perfectly until this morning in my Ubuntu 12.04. It took me a while to make Skype work again. This is how it works.

Remove Skype 4.2
$ sudo apt-get remove skype
Get rid of old Skype configuration
$ rm -fR ~/.Skype 
Download Skype 4.3 from Skype's website (http://www.skype.com/en/download-skype/skype-for-computer/). From there I got
skype-ubuntu-precise_4.3.0.37-1_i386.deb
*Depending on your machine and time, you might get different version of Skype.
*I tried to apt-get update to get the latest Skype. However, it seems the apt list is not up to date at that time, I can get the latest Skype by that approach.

Then install Skype 4.3
$ sudo dpkg -i skype-ubuntu-precise_4.3.0.37-1_i386.deb
Hope it works for you  : )