LAMP How To – Open Source At Work

Only Passion Matters

Entries for October, 2008

Retrieve Lost Password in MYSQL

Sometime, we forget the root password for mysql. It happened to me once in my company. The previous developer left and didn’t document where to look for passwords. Well, it is possible for the root user of the system to reset it anyway…
First shutdown mysql,
/etc/init.d/mysql stop
then
mysqld –skip-grant-tables –u root
mysql -u root
mysql> use mysql;
mysql> UPDATE [...]

BlueHost Hosting Review – My Experience

updated on 17 April 2010
Website hosting nowsadays is very competitive. Many web hosting companies offer tonnes of features at very competitive rates. With so many choices in mind, how do you choose the right host? I have tried many hosts over the years and finally landed on one that I feel has the most complete [...]

Search Engine Rankings With PEAR SOAP

Google implemented a search API in 2002 for web developers to do Google search within their own website. By using SOAP (Simple Object Access Protocol) procedures, the API allows the search and results retrieval to run in the background.
I have implemented a google search function in this website using PEAR SOAP. The script loops through [...]

Online Calendar Using PHP and AJAX

This calendar plugs in seamless with any content management system you are using. With Ajax, your screen need not be refreshed. The functionality can be easily extended using inheritance.
The full demo can be seen here – PHP Ajax Calendar and source code is here – Simple PHP Calendar Source.