Linux

Yesterday I was searching for Open Source Project Management softwares and found OpenProj.

To my surprise it is very much like Microsoft Project. I don't know how good it is, I will try it. In the mean time I have to try other Open Source PM Tools.

Secure your computer using IP Tables. Click on the link below. It has a nice tutorial on IP Tables.

http://www.itech7.com/Security/Secure-your-Linux-Box-using-IPTables-Fire...

For all those newbies in the world of Linux here is a very useful linux command.

pwd will print the current working directory in the konsole.

If you want the know your system information like the Kernel name, Kernel Release, Kernel Version etc then you can issue uname command.

Here is the details of the command along with the arguments. This information is fetched from manual pages.

NAME
       uname - print system information

SYNOPSIS
       uname [OPTION]...

DESCRIPTION
       Print certain system information.  With no OPTION, same as -s.

       -a, --all
              print all information, in the following order, 
              except omit -p and -i if unknown:

       -s, --kernel-name
              print the kernel name

       -n, --nodename
              print the network node hostname

       -r, --kernel-release
              print the kernel release

       -v, --kernel-version
              print the kernel version

       -m, --machine
              print the machine hardware name

       -p, --processor
              print the processor type or "unknown"

       -i, --hardware-platform
              print the hardware platform or "unknown"

       -o, --operating-system
              print the operating system

       --help display this help and exit

       --version
              output version information and exit

uptime gives a one line display of the following information. The current time, how long the system has been running, how many users are currently logged on, and the system load averages for the past 1, 5, and 15 minutes.

$ uptime
09:44:28 up 1 day, 1:10, 1 user, load average: 0.00, 0.00, 0.00

If you have forgotten your MySQL root password then don't worry. You can reset your lost password. Here is the procedure.

1. Login as root.

2. Kill running MySQL process and stop the MySQL service.

[root@localhost root]# killall mysqld
[root@localhost root]# /usr/libexec/mysqld -Sg --user=root &

3. Restart MySQL server with these parameters

[root@localhost root]# mysqld --skip-grant-tables --user=root

4. Manually set root password in the table "user" of "mysql" database.

[root@localhost root]# mysql

Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 3.23.41
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> USE mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

mysql> UPDATE user
-> SET password=password("newpassword")
-> WHERE user="root";

Query OK, 2 rows affected (0.04 sec)
Rows matched: 2 Changed: 2 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> exit;

[root@localhosthost root]# killall mysqld

5. Restart MySQL again

[root@localhosthost root]# /etc/init.d/mysqld start

Now your root password is set and you can now login as root using the password you have just created.

[root@localhost root]# mysql -u root -p
Enter Password: "newpassword"

If you again forget your root password don't worry just check this link again :)