Linux

How to show MySQL table details?

Submitted by Richard on Wed, 10/14/2009 - 06:17

Issue this command in your MySQL prompt to show table column detail.

desc user;

or

describe user;

The display would be as follows:

How display database tables in MySQL?

Submitted by Richard on Wed, 10/14/2009 - 06:13

Switch to a database you want to use using this command:

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

Once you have selected the database, just type this command to show all the tables inside it.

mysql> show tables;

The database tables are shown below.

How to delete MySQL database?

Submitted by Richard on Wed, 10/14/2009 - 06:09

To delete MySQL database, just simply type this command inside MySQL terminal.

mysql> drop database test_db;
Query OK, 0 rows affected (0.07 sec)

How to create MySQL database using mysqladmin command?

Submitted by Richard on Wed, 10/14/2009 - 06:04

To create MySQL database using mysqladmin command, type this command in your terminal.

mysqladmin create database_name

How to create MySQL database?

Submitted by Richard on Wed, 10/14/2009 - 06:01

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.

Submitted by Richard on Sun, 09/06/2009 - 08:46

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

Submitted by Richard on Sat, 09/05/2009 - 20:01

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

Submitted by Richard on Thu, 09/03/2009 - 06:40

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

Submitted by Richard on Fri, 05/08/2009 - 06:42

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:

Ubuntu 9.04 on my HP Pavilion dv5-1153ei Notebook

Submitted by Richard on Fri, 05/08/2009 - 06:38

I am very disappointed in Ubuntu 9.04 performance on my laptop. I had Ubuntu 9.04 installed in my HP Pavillion dv5-115ei laptop with the following specs:

  • 2GHZ Intel Core 2 Dou processor T5800
  • 2GB RAM
  • 512MB NVIDIA GeForce 9600M GT video card
Syndicate content