> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/clientserver-protocol/2-text-protocol.md).

# 2 - Text Protocol

{% columns %}
{% column %}
{% content-ref url="/pages/ngNgHKT9TSnecw2nlkZI" %}
[COM\_CHANGE\_USER](/docs/server/reference/clientserver-protocol/2-text-protocol/com_change_user.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command allows a connected client to re-authenticate as a different user without closing and reopening the connection.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/toTuK1Ehemf8zb5UkAph" %}
[COM\_CREATE\_DB](/docs/server/reference/clientserver-protocol/2-text-protocol/com_create_db.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command creates a new database on the server, functionally equivalent to the SQL statement CREATE DATABASE.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/tBwEoLkK5QFnn0X1j1tI" %}
[COM\_DEBUG](/docs/server/reference/clientserver-protocol/2-text-protocol/com_debug.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command forces the server to dump debug information to the standard output or log, requiring the SUPER privilege.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/jExDK04lr1AEugAtMSW2" %}
[COM\_DROP\_DB](/docs/server/reference/clientserver-protocol/2-text-protocol/com_drop_db.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command drops an existing database from the server, functionally equivalent to the SQL statement DROP DATABASE.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/yccnaHGDBIL5Zri4K4ni" %}
[COM\_FIELD\_LIST](/docs/server/reference/clientserver-protocol/2-text-protocol/com_field_list.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command retrieves a list of fields (columns) for a specified table, similar to the SHOW COLUMNS SQL statement.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/7SgZ7jivYEbxbEXLJZxX" %}
[COM\_INIT\_DB](/docs/server/reference/clientserver-protocol/2-text-protocol/com_init_db.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command selects the default database for the current connection, functionally equivalent to the USE statement.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/c9hf8NLBF6eVSnCPFq9G" %}
[COM\_PING](/docs/server/reference/clientserver-protocol/2-text-protocol/com_ping.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command checks if the server is alive and reachable, the server responds with an OK packet if it is running.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Q5iL0x9nW9nlQe1aW8Ep" %}
[COM\_PROCESSLIST](/docs/server/reference/clientserver-protocol/2-text-protocol/com_processlist.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command retrieves a list of active threads and their current status, similar to the SHOW PROCESSLIST statement.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/IgtycQ2LIvOPqvjzCujK" %}
[COM\_PROCESS\_KILL](/docs/server/reference/clientserver-protocol/2-text-protocol/com_process_kill.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command asks the server to terminate a specific connection thread, functionally equivalent to the KILL statement.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/CBNo1wNy14a9c1BvZOnN" %}
[COM\_QUERY](/docs/server/reference/clientserver-protocol/2-text-protocol/com_query.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command sends an SQL statement to the server for execution immediately, without the prepare/execute steps.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/sj8xBliDXGXsebIvSZaE" %}
[COM\_QUIT](/docs/server/reference/clientserver-protocol/2-text-protocol/com_quit.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command instructs the server to close the connection and release associated resources.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/fg6ajzIr2D6NxSL7F1S9" %}
[COM\_RESET\_CONNECTION](/docs/server/reference/clientserver-protocol/2-text-protocol/com_reset_connection.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command resets the session state (variables, tables, etc.) to its initial values without closing the connection.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/S23iVVKfIzcQNPQRXS5N" %}
[COM\_SET\_OPTION](/docs/server/reference/clientserver-protocol/2-text-protocol/com_set_option.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command configures client-specific options for the current connection, such as enabling or disabling multi-statements.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/oEoakdj8eNhS44G48n4b" %}
[COM\_SHUTDOWN](/docs/server/reference/clientserver-protocol/2-text-protocol/com_shutdown.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command requests the server to shut down, it requires the SHUTDOWN privilege to be executed successfully.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TnBi6EZZsBzCrmklrPZY" %}
[COM\_SLEEP](/docs/server/reference/clientserver-protocol/2-text-protocol/com_sleep.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This is an internal command used to represent a sleeping connection that is waiting for a new command from the client.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ybIJ8b6tH5loIReJApzL" %}
[COM\_STATISTICS](/docs/server/reference/clientserver-protocol/2-text-protocol/com_statistics.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This command retrieves a human-readable string containing internal server statistics like uptime and thread counts.
{% endcolumn %}
{% endcolumns %}