MySQL Change root Password

How do I change MySQL root password under Linux, FreeBSD, OpenBSD and UNIX like operating system over ssh / telnet session?

Setting up mysql password is one of the essential tasks. By default root user is MySQL admin account. Please note that the Linux / UNIX login root account for your operating system and MySQL root are different. They are separate and nothing to do with each other (indeed some admin removes root account and setup admin as mysql super user). More

How to shut down ubuntu on legacy toshiba

Try adding "acpi=force" to your kernel line in /boot/grub/menu.lst
while I look for the bug report if it exists. My memory isn’t the
greatest so I may be mistaken.

Ubuntu 8.04 does not shut down properly

Here is what you do if you are running Xubuntu Hardy Heron:

1) Go to the terminal (Applications/System) and enter this line of code:

sudo mousepad /boot/grub/menu.lst

2) Now a Mousepad file will open. Scroll down all the way till you see

End Default Options

3) Find the paragraph where it says something like:

Ubuntu 7.10, kernel 2.6.22-14-generic
(hd0,0)
/boot/vmlinuz-2.6.22-14-generic root=UUID=419086cc-9136-45e9-9369-d7fe44edff76 ro quiet splash
/boot/initrd.img-2.6.22-14-generic

Note: this is only 4 lines in Mousepad, not 5.
4) See where it says "splash"? Enter a space, then write (on the same line):

acpi=force apm=power_off

5) Save the document, exit, restart the computer, log in again and try to shut down. It might just work.

 
NOTE: If you don’t have mousepad, then replace that command with sudo pico menu.lst

How to Install Open Office 3.0 in Ubuntu

Unless you’ve been in an isolation chamber, you’ve probably noticed that OpenOffice.org 3.0 was released yesterday. It’s been a while in the coming and now the latest version of our favourite, and most affordable, office suite is here.

If you’re running Ubuntu (or another .deb-based OS) then you’re in luck. Debian versions of OOo are now available on most download sites (SA-based users check out these mirrors for a download) and installing OOo 3.0 is fairly straightforward. We explain:

First, remove your existing version of OpenOffice.org:

sudo apt-get remove openoffice*.*

Next, download a copy of OpenOffice.org 3.0 (OOo_3.0.0_LinuxIntel_install_en-US_deb.tar.gz worked for us) and extract the download:

tar -zxvf OOo_3.0.0_LinuxIntel_install_en-US_deb.tar.gz

That will create a directory called something like OOO300_m9_native_packed-1_en-US.9358.

Switch into the DEBS directory in that directory:

cd OOO300_m9_native_packed-1_en-US.9358/DEBS/

Now all you need to do is install all of those .deb packages:

sudo dpkg -i *.deb

That will do the trick. Once you’ve given your password your system should install all of the required files.

With that done you should have just one thing left to do: Install the desktop integration package. That should be in the DEBS folder:

cd desktop-integration

From that folder install the package:

sudo dpkg -i openoffice.org3.0-debian-menus_3.0-9354_all.deb

If everything works out you should be able to open OpenOffice.org 3.0 from the Applications menu on your desktop.

Disclaimer: It is always a good idea to backup your important stuff before removing applications and installing new ones.

How to Install Internet Explorer on Ubuntu

You have to enable universe packages first. It is also recommended that you use the official winehq ubuntu package:

1) Open a terminal

2) Open /etc/apt/sources.list
 sudo gedit /etc/apt/sources.list

3) Uncomment (or add) following lines:
 deb http://us.archive.ubuntu.com/ubuntu edgy universe

4) Add this line:
 deb http://wine.budgetdedicated.com/apt edgy main

5) Close gedit. Update and install wine and cabextract:
 wget -q http://wine.budgetdedicated.com/apt/387EE263.gpg -O- | sudo apt-key add -
 sudo apt-get update
 sudo apt-get install wine cabextract

6) Download IEs 4 Linux and install
 wget http://www.tatanka.com.br/ies4linux/downloads/ies4linux-latest.tar.gz
 tar zxvf ies4linux-latest.tar.gz
 cd ies4linux-*
 ./ies4linux

Note for Dapper users: if you use ubuntu dapper, replace edgy with dapper on lines above. Note for Feisty users (7.04): if you use ubuntu Feisty, replace edgy with feisty in the lines above; for latest ubuntu, replace edgy with hardy. Also replace gedit with kedit if running Kubuntu instead of Ubuntu.

For "Fiesty" K/Ubuntu Users (and 64-bit "Fiesty): http://www.winehq.org/site/download-deb

Twitter Feed

Follow

Get every new post delivered to your Inbox.