reset mysql root password

ps -ef | grep mysql      - checks if mysql/mysqld is one of the running processes. 

pkill mysqld             - kills the daemon, if it is running.

mysqld_safe --skip-grant-tables & - Run MySQL safe daemon with skipping grant tables

mysql -u root mysql - Login to MySQL as root with no password

UPDATE user SET password=PASSWORD("your-new-passowrd") WHERE user="root"; 

FLUSH PRIVILEGES;

Done 

services and its port

netstat -antp | grep LISTEN

unique combination of multiple columns in mysql

alter table tablename add unique index(column1,column2,column3);

[mysql ] perform order by column and rand() in single query

SELECT * FROM
(
    SELECT * FROM table1
    ORDER BY nos desc limit 0,1) 

          )  T1 ORDER BY RAND()

usage: 

if the column nos is same in multipe rows then fetch a random row..

How to install the Sun Java JDK on Ubuntu 10.10?

sudo apt-get install python-software-properties

sudo add-apt-repository ppa:sun-java-community-team/sun-java6

sudo apt-get update

sudo apt-get install sun-java6-jdk

search files in linux server

find /etc -name '*.conf'





/etc is directory or path


*.conf is file name * represents any name.conf files.

install Imagick on CentOS 5.x 32bit

Run the following commands


yum install ImageMagick

yum install ImageMagick-devel

yum install php-pear

pecl install imagick

echo "extension=imagick.so"> /etc/php.d/imagick.ini



service httpd restart

check Imagick is configured corectly by following command.

php -m | grep imagick

this will display output as "Imagick" that means you are Done.