mysqlshow - display database, table, and column information
SYNOPSIS
mysqlshow [options] [db_name [tbl_name [col_name]]]
DESCRIPTION
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table´s columns or indexes.
mysqlshow provides a command-line interface to several SQL SHOW statements.
The same information can be obtained by using those statements directly.
For example, you can issue them from the mysql client program.
Invoke mysqlshow like this:
shell> mysqlshow [options] [db_name [tbl_name [col_name]]]
If no database is given, a list of database names is shown.
If no table is given, all matching tables in the database are shown.
WHM News - The Apache security/version table
The News link at the top of the WHM screen provides up-to-date information about your server. The information is divided up into 3 sections:
This table shows selected Apache modules you have installed on your server.
The information is divided into 4 columns:
Module — The module to which the other information in the row pertains.
Apache Core — The Apache web server. For more information visit http://httpd.apache.org/.
mod_ssl — The module that provides SSL cryptography to the Apache web server. For more information visit http://www.modssl.org.
OpenSSL — A general purpose, open source, cryptographic library for SSL and TLS. Fore more information visit http://www.openssl.org.
Passthrough Authentication — Also seen as mod_auth_passthrough. A module that is installed with Apache to allow other programs to use their own authentication methods. cPanel uses it specifically to allow FrontPage® to use its own authentication system.
Bandwidth Limiter — Also seen as mod_bwlimited. The module that is installed with WHM and cPanel that allows you to limit your users’ bandwidth usage.
FrontPage® — The FrontPage extensions that are installed with WHM and cPanel.
Latest Version — The newest version of the corresponding module that is available.
Installed Version — The version of the module that is currently installed on your server.
Status — Shows whether or not the corresponding module is considered secure.
Reference: http://cpanel.net
Routing Table
To display the routing table in numerical addresses, one would use the “route -n” command:
$ route -n
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
10.0.2.0 0.0.0.0 255.255.255.0 U 1 0 0 eth0
With iproute, the equivalent command is “ip route show”:
$ ip route show
10.0.2.0/24 dev eth0 proto kernel scope link src 10.0.2.15 metric 1
default via 10.0.2.2 dev eth0 proto static
Add or delete static routes from the Linux IP routing table.
You need to know the network/subnet you wish to reach, also the interface you wish this route to be added to, i.e., which interface to use to reach the subnet.
How to reach another network, 10.20.30.0/24, that is reachable via a router on the 192.168.1.0/24 network, 192.168.1.254.
The following ip route command would add the desired route to the kernel routing table:
ip route add 10.20.30.0/24 via 192.168.1.254 dev eth1
Note: eth1 is connected to 192.168.1.0/24
