Howto Change Mysql root Password and Users password

Some users want to change their mysql root password and users password.
mysqladmin

To setup root password for mysql in first time, use the following command :

$ mysqladmin -u root password NEWPASSWORD

If you want to change existing root password, then use following command

$ mysqladmin -u root -p oldpassword newpassword


For Changing MySQL user password

eg: for changing password for user panayara

$ mysqladmin -u panayara -p oldpassword newpass

New Linux Drivers from Nvidia Released

Nvidia launches two new drivers: one stable and one beta. The stable version is version 185.18.36, and beta version 190.25.

Download Nvidia Driver For Linux ver 185.18.36 from here
Download Nvidia Driver For Linux ver 190.25 from here

Howto Install wammu : Mobile phone Manager for Ubuntu / Debian Linux

I know everybody is looking for a mobile phone manager for Linux. text based gammu is there, but it is not user friendly . wammu is a graphical front end for gammu.

Using wammu you can read/edit/delete/copy your contacts, todo, calendar you can read/create/save/send and backup your sms. some type of phone supports file sending, display message including pictures and ringtones playback. Support for backup and import in various formats (vCard, vCalendar, iCalendar, gammu own backup,...) . Export messages to mail (IMAP4, maildir and mailbox storages are supported). Searching for phone, translated into several languages, rated as best on many software servers


wammu is in development stage, It supports Sony Ericsson phones, Motorola Phones, some models of Nokia, Siemens, Alcatel.

Howto install wammu in ubuntu /debian

$ sudo apt-get install wammu (or use synaptic package manager )

Control Your Network Traffic with Wondershaper in Linux

If you are a Network Administrator with little knowledge in Network Protocols and IPtables, don't worry you can also controll your network traffic with a simple tool named wondershaper.

sudo apt-get install wondershaper

official site : http://lartc.org/wondershaper/

Readme files in /usr/share/doc/wondershaper

$ifconfig this will help you to find the network interface (eth0, eth1 or wifi0 etc..)

Now
$sudo wondershaper eth0 downspeed upspeed
eg: sudo wonderspeed 128 64

To Disable this settings

$sudo wondershaper clear eth0

make these connection settings permanent by editing /etc/network/interfaces file :

$ sudo gedit /etc/network/interfaces and add the following lines

up /sbin/wondershaper eth0 downspeed upspeed
down /sbin/wondershaper clear eth0

Howto Install PHP6 in ubuntu / Debian Linux

The full stable version of PHP6 is not yet released. But pre-built package is available. Early birds can start now. You can install a development snapshot of PHP 6 and preview it for its features and you can check your old scripts ( PHP 6 have some backwards-compatibility issues), so check your existing codes.

Howto Install PHP6 in Ubuntu / debian linux.

First you have to install GCC and GNU make utility

$sudo apt-get install build-essential
Now PHP6 installation needs some additional libraries

• Apache development headers, such as apache-prefork-dev
• International Component for Unicode (ICU) library, libicu-dev
• The XML2 development headers, libxml2-de etc

You can install the above using
$ sudo apt-get install apache-prefork-dev libicu-dev libxml2-dev

Now you can download latest PHP6 package from here http://snaps.php.net/

$ tar -xzvf php6.0-xxxxxx.tar.gz

Now Change directory to the new directory made by tar and start configuration
$ cd php6.0-xxxxxx
$ sudo ./configure --exec-prefix=/usr
--with-apxs2=/usr/bin/apxs2
--with-config-file-path=/etc/php6
$ sudo make
$ sudo make test
$ sudo make install

40 Beautiful Linux Wallpapers

40 Beautiful Linux Wallpapers for download
Download from Here

Useful Wireless Networking Connection Commands - Ubuntu/Debian Linux

Here I am trying to explain some useful Linux commands for wireless networking

iwlist scan - shows wireless networks that are available in the area with basic encryption information
lshw -C network - Shows Details of Interface card and drivers of each networking device

lspci -nn - Shows PCI vendor and device codes as both numbers and names of hardware connected to the pci bus
lsusb - Shows USB connected hardware
lshw -C usb - Additional info on USB related hardware (good for USB dongles)

route -n - Lists kernel IP routing table — Good for troubleshooting problems with the gateway

sudo route add default gw 192.168.1.1 - Example of how to set the default gateway to 192.168.1.1

sudo route del default gw 192.168.1.1 - Example of how to delete the default gateway setting

sudo modprobe ***** - Loads the kernel module **** . (Example usage - sudo modprobe ndiswrapper, sudo modprobe r818x, sudo modprobe ath_pci)

sudo modprobe -r **** - Unloades the kernel module ****. (Example usage - sudo modprobe -r ndiswrapper)

ifconfig - lists IP address

sudo ifup/ifdown - Brings up/down the interface and clears the routing table for the specified interface

sudo ifconfig up/down - Brings up/down the interface for the specified interface

sudo dhclient - Request IP address from DNS server for specified interface

sudo dhclient -r - Release IP address associated with specified interface

sudo iptables -L - Lists firewall rules

sudo iptables -F - Flush all firewall rules

dmesg | more - Lists boot log — good for troubleshooting problems with modules/drivers not being loaded

uname -r - Displays kernel version

/etc/udev/rules.d/70-persistent-net.rules - File which assigns logical names (eth0, wlan0, etc) to MAC addresses

cat /etc/resolv.conf - Lists DNS servers associated with network connections (Network Manager)

/etc/dhcp3/dhclient.conf - File which sets or modifies dns (domain name servers) settings

Howto Read CHM (compiled HTML) file in Ubuntu / debian Linux

Lot of documentations and e-books are now available in chm format. There is lot of tools are available in Linux for reading chm books. xchm, chmsee, KchmViewer , gnochm and archmage .

all of the above utilities are available ubuntu repositories

open a terminal
$ apt-get install xchm
(same way you can install chmsee, Kchmviewer, gnochm and archmage)

or use synaptic package manager for installing

Howto Password Protect Grub in Ubuntu / Debian Linux

Some recent posts showing that your linux box is not secure unless you installed a grub Password.
If you are an administrator of a highly sensitive server, you must do it.
To add a password for grub, first you must generate an md5 password hash using the grub-md5-crypt utility: grub-md5-crypt

The command will ask you to enter a password and offer a resulting hash value as shown below:

Password: (enter new password)
Retype password: (repeat password)
$1$s3YiK$M3lxAbqA6JLm2FbDWnClQ0

Add the resulting hash value to the file /boot/grub/menu.lst in the following format:

password --md5 $1$s3YiK$M3lxAbqA6JLm2FbDWnClQ0

To require use of the password for entering single user mode, change the value of the lockalternative variable in the file /boot/grub/menu.lst to true, as shown in the following example.

# lockalternative=true

Howto make Ubuntu 9.04 (Jaunty Jackalope) Multimedia Ready

AS per the request from my readers I am re-publishing this article

Ubuntu 9.04 Required the foll0wing steps to Run Multimedia files like MP3, AVI, Mpeg, Flash file etc...

In Ubuntu 9.04 "Jaunty jackalop", the universe, multiverse and restricted repositories are activated by default.

For installing Multimedia files you need to add medibuntu repositories.

Run the follwing in command mode it will add medibuntu repositories in your sources list

$ sudo wget http://www.medibuntu.org/sources.list.d/jaunty.list --output-document=/etc/apt/sources.list.d/medibuntu.list

then Add the GPG Key:

$ sudo apt-get update && sudo apt-get install medibuntu-keyring && sudo apt-get update

Run

$ sudo apt-get update

Now you can Install non-free-codecs

$ sudo apt-get install non-free-codecs

It will enables your system to support for MP3 and various other audio formats, unrar. Java runtime environment, Flash plugin, Microsoft fonts, w32codecs etc!

You can install more codecs and DVD Support by using

$ sudo apt-get install libdvdcss2 libxine1-ffmpeg gxine mencoder

It will help you to run DVDs, AVI files and other mpeg codecs.

Now Install Famous VLC player and Mplayer

$ sudo apt-get install vlc mplayer

You can Install following interesting and useful utilities

Audio Editing Software Audacity

$ sudo apt-get install audacity

Adobe Acrobat Reader

$sudo apt-get install acroread acroread-plugins