23
Nov
09
The mysqladmin tool can be used for changing MySql user’s password. The following line of code will change the user1′s password to “newpassword”. mysqladmin -u user1 -p password “newpassword”
20
Nov
09
If we lost the root privilege or password, it can be retrieved by the following steps : Stopping MySQL : Shell Command /etc/init.d/mysqld stop wait until MySQL stops, then run the following commands : mysqld_safe –skip-grant-tables & Then you will … Continue reading
19
Nov
09
This can be done by using both insert and select queries. Example : Suppose we have two tables student and mark : Student id | integer | name | text | Mark id | integer | name | text | … Continue reading
19
Nov
09
We can create the mplayer playlist by following some simple commands : $ find [/path/to/directory/] -name “*.mp3″ -print > myplaylist.txt $ mplayer -playlist myplaylist.txt
14
Nov
09
1. Login to the server as root user. 2. cd /etc/sysconfig/network-scripts 3. Check for existing network adapters with the command: ls ifcfg-* 4. Copy ifcfg-eth0 to ifcfg-eth0:0 cp ifcfg-eth0 ifcfg-eth0:0 5. Edit the file vi ifcfg-eth0:0 and change the following … Continue reading
