【MySQL】关于MySQLx协议和端口

一、关于MySQL X协议

 

MySQL X plugin是MySQL新发版本5.7.12中新增的插件，利用它实现MySQL作为文件存储数据库，也就是利用MySQL 5.7版本json支持的特性完成。

 

 

二、关于MySQL X plugin 的开启和关闭

 

MySQL启动之后监听了两个端口3306和33060，是为MySQL5.7.12 之后新增了X plugin。

这个插件默认是启用的，可以在配置配置文件/etc/my.cnf 添加mysqlx=0关闭X plugin，也可以在启动时指定 --mysqlx=0 或 --skip-mysqlx选项来禁用X插件。

 

Port 3306 is the default port for the MySQL Protocol, which is used by the mysql client, MySQL Connectors, and utilities such as mysqldump and mysqlpump. 

Port 33060 is the default port for the MySQL Database Extended Interface (the MySQL X Protocol).

The X Plugin can be disabled at startup by either setting mysqlx=0 in your MySQL configuration file, or by passing in either --mysqlx=0 or --skip-mysqlx when starting the MySQL server.

Alternatively, use the -DWITH_MYSQLX=OFF CMake option to compile MySQL Server without X Plugin.

 

 

三、参考

MySQL X 插件

https://www.docs4dev.com/docs/zh/mysql/5.7/reference/x-plugin.html#x-插件

 

Understanding MySQL X

https://www.percona.com/blog/2019/01/07/understanding-mysql-x-all-flavors

 

Mysql 8 enable plugin X

https://stackoverflow.com/uestions/61666495/mysql-8-enable-plugin-x

 

MySQL Port Reference Tables

https://dev.mysql.com/doc/mysql-port-reference/en/mysql-ports-reference-tables.html#mysql-client-server-ports

 

MySQL Disabling X Plugin

https://dev.mysql.com/doc/refman/8.0/en/x-plugin-disabling.html

 

MySQL accidentally expose port

https://stackoverflow.com/questions/56720751/accidentally-expose-port

https://www.coder.work/article/2531487