MySQL Commands 101

To login at the command line, enter

mysql -u root -p

At the mysql command, type

status

This is a sample result:

mysql> status
————–
mysql Ver 14.14 Distrib 5.5.14, for Linux (i686) using readline 5.1
Connection id: 41
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: less -X -R -F
Using outfile: ”
Using delimiter: ;
Server version: 5.5.14-55 Percona Server (GPL), Release 20.5
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 11 min 14 sec
Threads: 1 Questions: 110 Slow queries: 0 Opens: 171 Flush tables: 1 Open tables: 41 Queries per second avg: 0.163
More at MySQL website.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s