Determining the Communication Forms Supported by the MySQL Server : Global Variables « Command MySQL « SQL / MySQL

1. SQL / MySQL
2. Command MySQL
3. Global Variables

Determining the Communication Forms Supported by the MySQL Server

      
mysql>
mysql> SHOW VARIABLES LIKE 'skip_net%';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| skip_networking | OFF   |
+-----------------+-------+
1 row in set (0.00 sec)

mysql>
mysql> SHOW VARIABLES LIKE 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3306  |
+---------------+-------+
1 row in set (0.00 sec)

mysql>
mysql> SHOW VARIABLES LIKE 'socket';
Empty set (0.00 sec)

mysql>
mysql> SHOW VARIABLES LIKE 'named%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| named_pipe    | OFF   |
+---------------+-------+
1 row in set (0.00 sec)

mysql>
mysql> SHOW VARIABLES LIKE 'shared%';
+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| shared_memory           | OFF   |
| shared_memory_base_name | MYSQL |
+-------------------------+-------+
2 rows in set (0.00 sec)

mysql>
mysql>
mysql>

   
    
    
    
    
    
  

Related examples in the same category