How to disable MySQL X Protocol (mysqlx_port)

After installing MySQL 8 and checking listening ports with “netstat -lntp”, you will see MySQL is listening on ports 3306 and 33060.

Port 3306 is used by traditional MySQL protocol (MySQL Classic Protocol). Port 33060 is used by MySQL X Protocol.

What is MySQL X Protocol?

MySQL X Protocol is a network protocol that allows communication between MySQL Server and client applications using a modern, asynchronous, and high-performance approach.

One of the key advantages of MySQL X Protocol is its ability to handle large datasets efficiently, making it ideal for applications that require high-speed data transfer.

It also provides support for new features in MySQL 5.7 and later versions, such as document store, which allows users to store and retrieve JSON documents directly in the database.

How to disable MySQL X Protocol?

To disable MySQL X protocol, edit MySQL configuration file.

On Ubuntu/Debian

Find, [mysqld] section, and under it, add

Restart MySQL service

How to change MySQL X Protocol port?

To change the MySQL X Protocol port, change the following variables in your MySQL configuration file and restart MySQL server.

MySQL X Protocol related variables

To see MySQL 8 related variables, use the SQL command


Back to MySQL

Need help with Linux Server or WordPress? We can help!

Leave a Reply

Your email address will not be published. Required fields are marked *