Open Source Tips : Networking,Linux/Unix,Programming,News,Howto..

if using MySql for the first time then we use the command

#mysqladmin -u root password 'yourpassword'

 give your own password for 'your password' but without quotes

if you know your root password and want to reset it. then we can use the command

 #mysqladmin -u root -p'oldpassword' password 'newpassword'

give your old password and new password but without quotes.

if you forgot the root password 

Conditional Statements

Very often when you write code, you want to perform different actions for different decisions.

You can use conditional statements in your code to do this.

In PHP we have the following conditional statements:

• if statement - use this statement to execute some code only if a specified condition is true
• if...else statement - use this statement to execute some code if a condition is true and another code if the condition is false
• if...elseif....else statement - use this statement to select one of several blocks of code to be executed
• switch statement - use this statement to select one of many blocks of code to be executed