Mysqladmin show variables

    mysqladmin show variables
    phpmyadmin show variables
    mysqladmin example
    show variables in mysql
  • Mysqladmin show variables
    • Simply SELECT the variable like this: SELECT @myId; Here is the MySQL documentation on user-defined variables.

    SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, “Server System Variables”)..

    MySQL - SHOW VARIABLES Statement

    MySQL SHOW VARIABLES Statement

    The SHOW VARIABLES Statement is used to display names and values of MySQL system variables.

    Syntax

    Following is the syntax of the SHOW VARIABLES Statement −

    SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr]

    Example

    You can retrieve the list GLOBAL VARIABLES in MySQL using the GLOBAL clause as shown below −

    SHOW GLOBAL VARIABLES\G;

    Output

    The above query produces the following output −

    ************* 1.

    row ************* Variable_name: activate_all_roles_on_login Value: OFF ************* 2. row ************* Variable_name: admin_address Value: ************* 3. row ************* Variable_name: admin_port Value: 33062 ************* 4.

    row ************* Variable_name: admin_ssl_ca Value: ************* 5. row ************* Variable_name: admin_ssl_capath Value: ************* 6.

    This is a deprecated alias for stop-replica.

  • SHOW VARIABLES shows the values of MySQL system variables (see Section 5.1.7, “Server System Variables”).
  • SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, “Server System Variables”).
  • Click the “Status” button on the toolbar within the Server Variables window.
  • You can use the WHERE clause of the SHOW VARIABLES statements to retrieve names of the variables which match the specified condition.

    • row ************* Variable_name: admin_ssl_cert Value: ************* 7. row ************* Variable_name: admin_ssl_cipher Value: ************* 8. row ************* Variable_name: admin_ssl_crl Value: *****

      mysqladmin variables
      mysqladmin set variable