How to create MySQL database?

Login to your MySQL database server

mysql -u root -p

and type this command:

mysql> create database test_db;
Query OK, 1 row affected (0.00 sec)

To check your newly created database, type this command:

mysql> show databases;
| Database           |
| information_schema | 
| mysql              | 
| test               | 
| test_db            | 
4 rows in set (0.00 sec)

How to prevent KDE4 applications to start in fullscreen mode on Fedora 11 with Compiz Fusion.

I am experiencing problems with most of my KDE4 applications installed in my Fedora 11 box. I've recently installed digikam, konqueror, konversation, ktorrent etc. and everytime I open each of these applications, its always opening in full screen mode.

How to fix this problem?

After googling, I found out that Compiz Fusion is the one causing this problem. To fix it, open Compizconfig Settings Manager and go "Utility Section" and click "Workarounds" then untick the "Legacy Fullscreen Support". Cheers!

How to Setup Password-less SSH Login using RSA/DSA Authentication in Fedora 11

The Goal of this tutorial

Get a secure, encrypted connection to a remote machine without typing in a password.

What is OpenSSH ?

OpenSSH is a secure way of connecting to remote computers and transfering files. The OpenSSH suite includes the following programs (among others)

How to install and Configure tftp server in fedora 11

What is TFTP?

Trivial File Transfer Protocol (TFTP) is a file transfer protocol, with the functionality of a very basic form of File Transfer Protocol (FTP). TFTP server is commonly used to upload and download executable images and configurations of routers and switches. To install tftp server, type this command in the console:

How to Check your Hardware Details in Fedora 11

lshw (Hardware Lister) is a small tool to provide detailed information about all hardware in your system.

To install lshw, type this command:

yum -y install lshw lshw-gui

By default lshw command generates a long lists of information about your hardware and you don't even need some of its information. To generate a compact report use "-short" option.

lshw -short

This will give you summarize information about your hardware devices as shown below:

How to find the fastest CentOS/Fedora mirrors

To speed-up your yum download, you need to install the yum-fastestmirror package. Its a yum plugin which chooses fastest repository from a mirrorlist. This plugin sorts each repository's mirrorlist by connection speed prior to downloading packages.

To install, simply type:

yum install yum-fastestmirror

Have fun...

How to Reset Cisco 2600 Router to Factory Defaults

To reset your Cisco 2600 router, just follow the instructions from this link.

If you forgot your router's password (enable password, enable secret, console) you need to reset your router through ROMmon.

To access the ROMmon mode, start your minicom and reboot your router. Upon booting send the CTR+BREAK sequence by pressing CTRL-A F on your keyboard.

System Bootstrap, Version 12.2(8r) [cmong 8r], RELEASE SOFTWARE (fc1)               
Copyright (c) 2003 by cisco Systems, Inc.                                           
C2600 platform with 98304 Kbytes of main memory

program load complete, entry point: 0x80008000, size: 0xacc0f0
Self decompressing the image : ########################
monitor: command "boot" aborted due to user interrupt
rommon 1 > 
rommon 1 > 

Then type this command to change the router's configuration register to 0x2142.

How to Erase Cisco 2600 Router Configuration

To erase your Cisco 2600 router configuration, type this command.

Router#erase startup-config

It will ask for confirmation. Press enter to confirm.

Erasing the nvram filesystem will remove all configuration files! Continue? [confirm]
Erase of nvram: complete

Reload your routers configuration by typing this command:

How to find the fastest repository in Debian Etch

To find the fastest mirror in Debian, download and install apt-spy.

apt-get install apt-spy

Apt-spy is a program used to test a series of Debian's mirrors for bandwidth. Apt-spy will then generate a /etc/apt/sources.list file with the fasted server. You can select which of the Debian server's to benchmark by geographical location.

Run this command to retrieve the latest list of Debian mirrors

apt-spy update

To find the fastest mirror, run

apt-spy -d stable -a ALL


How to install minicom in Debian or Ubuntu to configure Cisco switches and routers through the console port

I will assume that you are using Debian or Ubuntu Linux to configure your CISCO router using CLI.
Open your terminal and install minicom and setserial by typing this command in the terminal.

apt-get install minicom setserial

Check your serial port

dmesg | grep tty

The output should be like this:

[   18.439952] console [tty0] enabled
[   20.172975] serial8250: ttyS0 at I/O 0x3f8 (irq = 4) is a 16550A
[   20.173725] 00:08: ttyS0 at I/O 0x3f8 (irq = 4) is a 16550A

or you can use the setserial command

Syndicate content