competence-rs.com / localhost

Recent

Favorites

There are no favorite tables.

Drop files here

SQL upload ( 0 ) x-

Server: localhost

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

General
Databases
Text fields
Page titles
Warnings

General

Set some commonly used options.

Version check Enables check for latest version on main phpMyAdmin page.
Natural order Use natural order for sorting table and database names.
Initial state for sliders
Login cookie validity Define how long (in seconds) a login cookie is valid.
Skip locked tables Mark used tables and make it possible to show databases with locked tables.
Disable multi table maintenance Disable the table maintenance mass operations, like optimizing or repairing the selected tables of a database.
Maximum tables Maximum number of tables displayed in table list.	i
Show hint Whether to show hint or not.
Send error reports Choose the default action when sending error reports.
Enter executes queries in console Queries are executed by pressing Enter (instead of Ctrl+Enter). New lines will be inserted with Shift+Enter.

Databases

Show only listed databases You can use MySQL wildcard characters (% and _), escape them if you want to use their literal instances, i.e. use `'my\_db'` and not `'my_db'`.
Hide databases Hide databases matching regular expression (PCRE).
Maximum databases Maximum number of databases displayed in database list.	i

Text fields

Customize text input fields.

CHAR columns editing Defines which type of editing controls should be used for CHAR and VARCHAR columns; `input` - allows limiting of input length, `textarea` - allows newlines in columns.
Minimum size for input field Defines the minimum size for input fields generated for CHAR and VARCHAR columns.
Maximum size for input field Defines the maximum size for input fields generated for CHAR and VARCHAR columns.
CHAR textarea columns Number of columns for CHAR/VARCHAR textareas.
CHAR textarea rows Number of rows for CHAR/VARCHAR textareas.
Textarea columns Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2).
Textarea rows Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2).
Bigger textarea for LONGTEXT Double size of textarea for LONGTEXT columns.

Page titles

Specify browser's title bar text. Refer to documentation for magic strings that can be used to get special values.

Default title Title of browser window when nothing is selected.
Table Title of browser window when a table is selected.
Database Title of browser window when a database is selected.
Server Title of browser window when a server is selected.

Warnings

Disable some of the warnings shown by phpMyAdmin.

Server/library difference warning Disable the default warning that is displayed if a difference between the MySQL library and server is detected.
Missing phpMyAdmin configuration storage tables Disable the default warning that is displayed on the database details Structure page if any of the required tables for the phpMyAdmin configuration storage could not be found.
Suhosin warning Disable the default warning that is displayed on the main page if Suhosin is detected.
Login cookie validity warning Disable the default warning that is displayed on the main page if the value of the PHP setting session.gc_maxlifetime is less than the value of `LoginCookieValidity`.
MySQL reserved word warning Disable the default warning that is displayed on the Structure page if column names in a table are reserved MySQL words.

Warning in ./libraries/dbi/DBIMysqli.class.php#261

mysqli_query(): MySQL server has gone away

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
NULL,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#460: PMA_DatabaseInterface->fetchResult(string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC')
./libraries/navigation/NavigationTree.class.php#279: Node->getData(
string 'databases',
integer 0,
string '',
)
./libraries/navigation/NavigationTree.class.php#830: PMA_NavigationTree->_buildPath()
./libraries/navigation/Navigation.class.php#44: PMA_NavigationTree->renderState()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()

Warning in ./libraries/dbi/DBIMysqli.class.php#261

mysqli_query(): Error reading result set's header

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC',
NULL,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#460: PMA_DatabaseInterface->fetchResult(string 'SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, \'_\'), CONCAT(SCHEMA_NAME, \'_\')) ORDER BY SCHEMA_NAME ASC')
./libraries/navigation/NavigationTree.class.php#279: Node->getData(
string 'databases',
integer 0,
string '',
)
./libraries/navigation/NavigationTree.class.php#830: PMA_NavigationTree->_buildPath()
./libraries/navigation/Navigation.class.php#44: PMA_NavigationTree->renderState()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()

Warning in ./libraries/dbi/DBIMysqli.class.php#261

Error while sending QUERY packet. PID=1597397

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#814: PMA_DatabaseInterface->fetchResult(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
string 'db_name',
string 'count',
object,
)
./libraries/navigation/NavigationTree.class.php#280: Node->getNavigationHidingData()
./libraries/navigation/NavigationTree.class.php#830: PMA_NavigationTree->_buildPath()
./libraries/navigation/Navigation.class.php#44: PMA_NavigationTree->renderState()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()