Monday, August 10, 2009

how to recover mysql server root password?

If you have lost your mysql password for some "ding dong" reason, :P

here is how to recover them:
1. stop the mysqld service by: sudo /etc/init.d/mysqld stop
2. start: mysqld_safe --skip-grant-tables &
3. login without pwd: mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit
4. stop mysql: sudo /etc/init.d/mysqld stop
5. start mysqld: sudo /etc/init.d/mysqld start
6. try login via: mysql -u root -p (with yournew pwd)

Wednesday, August 5, 2009

Change Request

Its usual that under many circumstances, customer / client will change their mind or change their decision in tuning their software towards their objective.
Every change requirement shall have a "change request" document signed by customer/client.

A change request is a document containing a call for an adjustment of a system; it is of great importance in the change management process.


Every project shall have a well written requirement. One of the best requirement document design will be SRS.

Software Requirements Specifications (SRS)

Cover Page

Revisions Page

Table of Contents


1.1 Product Overview
1.2 Purpose
1.3 Scope
1.4 Reference
1.5 Definition And Abbreviation


2.1 External Interface Requirements
2.1.1 User Interfaces
2.1.2 Hardware Interfaces
2.1.3 Software Interfaces
2.1.4 Communications Protocols
2.1.5 Memory Constraints
2.1.6 Operation
2.1.7 Product function
2.1.8 Assumption and Dependency
2.2 Software Product Features
2.3 Software System Attributes
2.3.1 Reliability
2.3.2 Availability
2.3.3 Security
2.3.4 Maintainability
2.3.5 Portability
2.3.6 Performance
2.4 Database Requirements