将文件拖动至此

SQL upload ( 0 ) x-

服务器: localhost »数据库: information_schema »视图: SYSTEM_VARIABLES
页面相关设置点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 : 用时 :
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 Whether a user should be displayed a "show all (rows)" button.
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头,要禁止此功能请设为 0
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. 文档
正在显示第 0 - ... 此视图的行数最少有这么多。请参阅档案 行 (查询花费 0.0046 秒。) [NUMERIC_MIN_VALUE: ... - ...]
SELECT * FROM `SYSTEM_VARIABLES`  
ORDER BY `SYSTEM_VARIABLES`.`NUMERIC_MIN_VALUE` ASC
VARIABLE_NAMESESSION_VALUEGLOBAL_VALUEGLOBAL_VALUE_ORIGINDEFAULT_VALUEVARIABLE_SCOPEVARIABLE_TYPEVARIABLE_COMMENTNUMERIC_MIN_VALUE 递增 递减 1NUMERIC_MAX_VALUENUMERIC_BLOCK_SIZEENUM_VALUE_LISTREAD_ONLYCOMMAND_LINE_ARGUMENT
WSREP_NODE_NAME NULLizhp39hn5gsepj8ayfapbgz COMPILE-TIME izhp39hn5gsepj8ayfapbgz GLOBAL VARCHAR Name of this node. This name can be used in wsrep_... NULLNULLNULLNULLNO REQUIRED
SQL_MODE NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION COMPILE-TIME NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SESSION SET Sets the sql mode NULLNULLNULLREAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_S... NO REQUIRED
BASEDIR NULL/opt/lampp CONFIG GLOBAL VARCHAR Path to installation directory. All paths are usua... NULLNULLNULLNULLYES REQUIRED
SOCKET NULL/opt/lampp/var/mysql/mysql.sock CONFIG GLOBAL VARCHAR Socket file to use for connection NULLNULLNULLNULLYES REQUIRED
VERSION_SSL_LIBRARY NULLOpenSSL 1.0.2n  7 Dec 2017 COMPILE-TIME NULLGLOBAL VARCHAR Version of the used SSL library NULLNULLNULLNULLYES NULL
INNODB_SCRUB_LOG NULLOFF COMPILE-TIME OFF GLOBAL BOOLEAN Enable background redo log (ib_logfile0, ib_logfil... NULLNULLNULLOFF,ON YES OPTIONAL
INNODB_FT_SERVER_STOPWORD_TABLE NULLCOMPILE-TIME GLOBAL VARCHAR The user supplied stopword table name. NULLNULLNULLNULLNO OPTIONAL
INNODB_USE_SYS_MALLOC NULLON COMPILE-TIME ON GLOBAL BOOLEAN DEPRECATED. This option may be removed in future r... NULLNULLNULLOFF,ON YES NONE
BINLOG_FORMAT STATEMENT STATEMENT COMPILE-TIME STATEMENT SESSION ENUM What form of binary logging the master will use: e... NULLNULLNULLMIXED,STATEMENT,ROW NO REQUIRED
CHARACTER_SETS_DIR NULL/opt/lampp/share/charsets/ AUTO GLOBAL VARCHAR Directory where character sets are NULLNULLNULLNULLYES REQUIRED
MASTER_VERIFY_CHECKSUM NULLOFF COMPILE-TIME OFF GLOBAL BOOLEAN Force checksum verification of logged events in th... NULLNULLNULLOFF,ON NO OPTIONAL
HAVE_SSL NULLDISABLED COMPILE-TIME NULLGLOBAL VARCHAR If the server supports secure connections, will be... NULLNULLNULLNULLYES NULL
WSREP_DRUPAL_282555_WORKAROUND NULLOFF COMPILE-TIME OFF GLOBAL BOOLEAN Enable a workaround to handle the cases where inse... NULLNULLNULLOFF,ON NO OPTIONAL
INNODB_CHECKSUM_ALGORITHM NULLINNODB COMPILE-TIME INNODB GLOBAL ENUM The algorithm InnoDB uses for page checksumming. P... NULLNULLNULLCRC32,STRICT_CRC32,INNODB,STRICT_INNODB,NONE,STRIC... NO REQUIRED
FT_STOPWORD_FILE NULL(built-in) COMPILE-TIME GLOBAL VARCHAR Use stopwords from this file instead of built-in l... NULLNULLNULLNULLYES REQUIRED
REPORT_HOST NULLCOMPILE-TIME GLOBAL VARCHAR Hostname or IP of the slave to be reported to the ... NULLNULLNULLNULLYES REQUIRED
EXPLICIT_DEFAULTS_FOR_TIMESTAMP NULLOFF COMPILE-TIME OFF GLOBAL BOOLEAN This option causes CREATE TABLE to create all TIME... NULLNULLNULLOFF,ON YES OPTIONAL
EVENT_SCHEDULER NULLOFF COMPILE-TIME OFF GLOBAL ENUM Enable the event scheduler. Possible values are ON... NULLNULLNULLOFF,ON,DISABLED,ORIGINAL NO OPTIONAL
LARGE_FILES_SUPPORT NULLON COMPILE-TIME NULLGLOBAL BOOLEAN Whether mysqld was compiled with options for large... NULLNULLNULLOFF,ON YES NULL
UNIQUE_CHECKS ON ON COMPILE-TIME ON SESSION BOOLEAN If set to 1, the default, secondary indexes in Inn... NULLNULLNULLOFF,ON NO NULL
WSREP_AUTO_INCREMENT_CONTROL NULLON COMPILE-TIME ON GLOBAL BOOLEAN To automatically control the assignment of autoinc... NULLNULLNULLOFF,ON NO OPTIONAL
INNODB_BACKGROUND_SCRUB_DATA_COMPRESSED NULLOFF COMPILE-TIME OFF GLOBAL BOOLEAN Enable scrubbing of compressed data by background ... NULLNULLNULLOFF,ON NO REQUIRED
CHARACTER_SET_RESULTS utf8mb4 latin1 COMPILE-TIME latin1 SESSION ENUM The character set used for returning query results... NULLNULLNULLNULLNO NULL
INNODB_VERSION NULL5.6.36-82.2 COMPILE-TIME NULLGLOBAL VARCHAR Percona-InnoDB-plugin version NULLNULLNULLNULLYES NULL
CHARACTER_SET_CONNECTION utf8mb4 latin1 COMPILE-TIME latin1 SESSION ENUM The character set used for literals that do not ha... NULLNULLNULLNULLNO NULL


mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
使用配置文件中定义的控制用户连接失败。