Mega Code Archive

 

Categories / MySQL / Command Mysql

 

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>