To err is human. Humans forget things, MySQL root password is one of those things. However, its not very difficult to reset the root password if you have root access to the machine.
The tutorial does seem a bit long because of all the alternate ways to kill and start the mysqld, but trust me its simple.
Here’s in short what we will be going to do:
- Step 1: Stop mysql server process
- Step 2: Start mysqld with --skip-grant-tables option.
- Step 3: Run mysql without any parameters.
- Step 4: Change the root admin password (old password not required.)
- Step 5: Close mysql and restart mysql server.
And here are the detailed instructions to reset MySQL root password: Read the rest of this entry »
Linux is awesome and so is the terminal. Things become a lot more easy if you can just type in few commands and get your work done. Downloading youtube video has always been messy with GUI downloaders, browser extensions and web services which claim to give you the download link to that video. Now, you can download it from the terminal using youtube-dl in ubuntu. You can also download and install it in other flavors of linux. The script is written in python.
Install youtube-dl from the official repository in Ubuntu:
sudo apt-get install youtube-dl
To download a video execute the following:
youtube-dl <url>
Example screenshot:
Read the rest of this entry »
My host recently started allowing remote connections to its mysql database. It was a really useful feature – I could not change database settings from my own computer. Since it started allowing remote connections from my IP, I could use any mysql client to connect to it. I fired up terminal and tried to connect using the command:
mysql --host=69.89.31.242 --user=username --password=password
It connected. This was just to test the connection. I wanted to connect my phpmyadmin with this remote host. For that I edited /etc/phpmyadmin/config-db.php file and changed:
$dbserver=”;
to
$dbserver=’69.89.31.242′;
I loaded the url http://localhost/phpmyadmin, entered the database username and password and I got in. I could administer my database from my local phpmyadmin installation.
Cheers!
Those of who are bored of the dull themes of Linux, I found 13 cool new themes for Linux.
Bisigi Themes provide 13 free themes, each has its own icon-set, wallpaper, and color scheme. Just a few terminal commands are needed to install them.
Installation instructions of Bisigi Themes
Few people have complained that the link above does not open, so I’ll give the instructions here as well.
Add the key for repository:
gpg --keyserver hkp://keyserver.ubuntu.com:11371 --recv-key 881574DE && gpg -a --export 881574DE | sudo apt-key add -
Read the rest of this entry »
For Rar files:
My friend sent me a link to a rar file just today. After downloading, I found that rar file wasn’t supported natively on Ubuntu. I tried different softwares but none was good. So finally I installed rar and unrar, both of them aren’t free. They provide integration with the native gnome archive manager.
To install them, type the following line in terminal and press enter:
sudo apt-get install rar unrar
When you double click a rar file it will automatically open with gnome archive manager (file roller). Also, you’ll be able to see the rar format option available in the create archive dialog box.
For 7z files:
I also wanted to have 7z support while I was at this. So I just installed p7zip-full for this. It also provided integration with default archiver of gnome. To install it, type the following in terminal:
sudo apt-get install p7zip-full
This will give 7z support. Try double clicking a 7z file and it will open directly in archive manager. You will also find the option to select 7z in create archive dialog box.
Cheers!
