To test whether a connection can even be made, execute the command STATUS. : Status « Command MySQL « SQL / MySQL

1. SQL / MySQL
2. Command MySQL
3. Status

To test whether a connection can even be made, execute the command STATUS.

  
mysql>
mysql> STATUS;
--------------
.\mysql\bin\mysql  Ver 14.14 Distrib 5.1.39, for Win32 (ia32)

Connection id:          130
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.1.39-community MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 4 days 20 hours 24 min 31 sec

Threads: 1  Questions: 28098  Slow queries: 0  Opens: 791  Flush tables: 1  Open tables: 0  Queries per second avg: 0.67

--------------

mysql>

   
    
  

Related examples in the same category