7 June 2012

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"; 

25 March 2012

14 March 2012

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

    SELECT * FROM table1
    ORDER BY nos desc limit 0,1) 
          )  T1 ORDER BY RAND()
if the column nos is same in multipe rows then fetch a random row..

29 February 2012

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

30 January 2012

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.