In this guide i will guide you the simple step to show the table on the database server. Assume that the wordpress blog has been installed and running fine with the following database details:
Database Name : wp1db Database User : wp1user Database Password : wp1password
Go to the terminal or ssh to MySQL Database server. You should login as wp1user.
[root@server ~]# mysql -u wp1user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 198 Server version: 5.0.77 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> status -------------- mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1 Connection id: 204 Current database: Current user: wp1user@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.0.77 Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 1 hour 10 min 58 sec Threads: 3 Questions: 3307 Slow queries: 0 Opens: 57 Flush tables: 1 Open tables: 29 Queries per second avg: 0.777 --------------
mysql> use wp1db; 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> show tables; +-----------------------+ | Tables_in_wp1db | +-----------------------+ | wp_commentmeta | | wp_comments | | wp_links | | wp_options | | wp_postmeta | | wp_posts | | wp_term_relationships | | wp_term_taxonomy | | wp_terms | | wp_usermeta | | wp_users | +-----------------------+ 11 rows in set (0.01 sec)