12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095 |
- <?php
- /**
- * <code>
- * N N OOO !! DDDD OOO N N OOO TTTTT EEEE DDDD I TTTTT !!
- * NN N O O !! D D O O NN N O O T E D D I T !!
- * N N N O O !! D D O O N N N O O T EEEE D D I T !!
- * N NN O O D D O O N NN O O T E D D I T
- * N N OOO !! DDDD OOO N N OOO T EEEE DDDD I T !!
- * </code>
- *
- * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
- *
- * phpMyAdmin default configuration, you can copy values from here to your
- * config.inc.php
- *
- * All directives are explained in the documentation
- */
- declare(strict_types=1);
- /**
- * Your phpMyAdmin URL.
- *
- * Complete the variable below with the full URL ie
- * https://example.com/path_to_your_phpMyAdmin_directory/
- *
- * It must contain characters that are valid for a URL, and the path is
- * case sensitive on some Web servers, for example Unix-based servers.
- *
- * In most cases you can leave this variable empty, as the correct value
- * will be detected automatically. However, we recommend that you do
- * test to see that the auto-detection code works in your system. A good
- * test is to browse a table, then edit a row and save it. There will be
- * an error message if phpMyAdmin cannot auto-detect the correct value.
- *
- * @global string $cfg['PmaAbsoluteUri']
- */
- $cfg['PmaAbsoluteUri'] = '';
- /**
- * Configure authentication logging destination
- *
- * @global string $cfg['AuthLog']
- */
- $cfg['AuthLog'] = 'auto';
- /**
- * Whether to log successful authentication attempts
- *
- * @global boolean $cfg['AuthLogSuccess']
- */
- $cfg['AuthLogSuccess'] = false;
- /**
- * Disable the default warning that is displayed on the DB Details Structure page if
- * any of the required Tables for the configuration storage could not be found
- *
- * @global boolean $cfg['PmaNoRelation_DisableWarning']
- */
- $cfg['PmaNoRelation_DisableWarning'] = false;
- /**
- * Disable the default warning that is displayed if Suhosin is detected
- *
- * @global boolean $cfg['SuhosinDisableWarning']
- */
- $cfg['SuhosinDisableWarning'] = false;
- /**
- * Disable the default warning that is displayed if session.gc_maxlifetime
- * is less than `LoginCookieValidity`
- *
- * @global boolean $cfg['LoginCookieValidityDisableWarning']
- */
- $cfg['LoginCookieValidityDisableWarning'] = false;
- /**
- * Disable the default warning about MySQL reserved words in column names
- *
- * @global boolean $cfg['ReservedWordDisableWarning']
- */
- $cfg['ReservedWordDisableWarning'] = false;
- /**
- * Show warning about incomplete translations on certain threshold.
- *
- * @global boolean $cfg['TranslationWarningThreshold']
- */
- $cfg['TranslationWarningThreshold'] = 80;
- /**
- * Allows phpMyAdmin to be included from a other document in a frame;
- * setting this to true is a potential security hole. Setting this to
- * 'sameorigin' prevents phpMyAdmin to be included from another document
- * in a frame, unless that document belongs to the same domain.
- *
- * @global boolean|string $cfg['AllowThirdPartyFraming']
- */
- $cfg['AllowThirdPartyFraming'] = false;
- /**
- * The 'cookie' auth_type uses AES algorithm to encrypt the password. If
- * at least one server configuration uses 'cookie' auth_type, enter here a
- * pass phrase that will be used by AES. The maximum length seems to be 46
- * characters.
- *
- * @global string $cfg['blowfish_secret']
- */
- $cfg['blowfish_secret'] = '';
- /*******************************************************************************
- * Server(s) configuration
- *
- * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
- * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
- * to ''. If you want more than one server, just copy following section
- * (including $i incrementation) several times. There is no need to define
- * full server array, just define values you need to change.
- *
- * @global array $cfg['Servers']
- */
- $cfg['Servers'] = [];
- $i = 1;
- /**
- * MySQL hostname or IP address
- *
- * @global string $cfg['Servers'][$i]['host']
- */
- $cfg['Servers'][$i]['host'] = 'localhost';
- /**
- * MySQL port - leave blank for default port
- *
- * @global string $cfg['Servers'][$i]['port']
- */
- $cfg['Servers'][$i]['port'] = '';
- /**
- * Path to the socket - leave blank for default socket
- *
- * @global string $cfg['Servers'][$i]['socket']
- */
- $cfg['Servers'][$i]['socket'] = '';
- /**
- * Use SSL for connecting to MySQL server?
- *
- * @global boolean $cfg['Servers'][$i]['ssl']
- */
- $cfg['Servers'][$i]['ssl'] = false;
- /**
- * Path to the key file when using SSL for connecting to the MySQL server
- *
- * @global string $cfg['Servers'][$i]['ssl_key']
- */
- $cfg['Servers'][$i]['ssl_key'] = null;
- /**
- * Path to the cert file when using SSL for connecting to the MySQL server
- *
- * @global string $cfg['Servers'][$i]['ssl_cert']
- */
- $cfg['Servers'][$i]['ssl_cert'] = null;
- /**
- * Path to the CA file when using SSL for connecting to the MySQL server
- *
- * @global string $cfg['Servers'][$i]['ssl_ca']
- */
- $cfg['Servers'][$i]['ssl_ca'] = null;
- /**
- * Directory containing trusted SSL CA certificates in PEM format
- *
- * @global string $cfg['Servers'][$i]['ssl_ca_path']
- */
- $cfg['Servers'][$i]['ssl_ca_path'] = null;
- /**
- * List of allowable ciphers for SSL connections to the MySQL server
- *
- * @global string $cfg['Servers'][$i]['ssl_ciphers']
- */
- $cfg['Servers'][$i]['ssl_ciphers'] = null;
- /**
- * MySQL 5.6 or later triggers the mysqlnd driver in PHP to validate the
- * peer_name of the SSL certifcate
- * For most self-signed certificates this is a problem. Setting this to false
- * will disable the check and allow the connection (PHP 5.6.16 or later)
- *
- * @link https://bugs.php.net/68344
- *
- * @global string $cfg['Servers'][$i]['ssl_verify']
- */
- $cfg['Servers'][$i]['ssl_verify'] = true;
- /**
- * Use compressed protocol for the MySQL connection
- *
- * @global boolean $cfg['Servers'][$i]['compress']
- */
- $cfg['Servers'][$i]['compress'] = false;
- /**
- * MySQL control host. This permits to use a host different than the
- * main host, for the phpMyAdmin configuration storage. If left empty,
- * $cfg['Servers'][$i]['host'] is used instead.
- *
- * @global string $cfg['Servers'][$i]['controlhost']
- */
- $cfg['Servers'][$i]['controlhost'] = '';
- /**
- * MySQL control port. This permits to use a port different than the
- * main port, for the phpMyAdmin configuration storage. If left empty,
- * $cfg['Servers'][$i]['port'] is used instead.
- *
- * @global string $cfg['Servers'][$i]['controlport']
- */
- $cfg['Servers'][$i]['controlport'] = '';
- /**
- * MySQL control user settings (this user must have read-only
- * access to the "mysql/user" and "mysql/db" tables). The controluser is also
- * used for all relational features (pmadb)
- *
- * @global string $cfg['Servers'][$i]['controluser']
- */
- $cfg['Servers'][$i]['controluser'] = '';
- /**
- * MySQL control user settings (this user must have read-only
- * access to the "mysql/user" and "mysql/db" tables). The controluser is also
- * used for all relational features (pmadb)
- *
- * @global string $cfg['Servers'][$i]['controlpass']
- */
- $cfg['Servers'][$i]['controlpass'] = '';
- /**
- * Authentication method (valid choices: config, http, signon or cookie)
- *
- * @global string $cfg['Servers'][$i]['auth_type']
- */
- $cfg['Servers'][$i]['auth_type'] = 'cookie';
- /**
- * HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)
- *
- * @global string $cfg['Servers'][$i]['auth_http_realm']
- */
- $cfg['Servers'][$i]['auth_http_realm'] = '';
- /**
- * MySQL user
- *
- * @global string $cfg['Servers'][$i]['user']
- */
- $cfg['Servers'][$i]['user'] = 'root';
- /**
- * MySQL password (only needed with 'config' auth_type)
- *
- * @global string $cfg['Servers'][$i]['password']
- */
- $cfg['Servers'][$i]['password'] = '';
- /**
- * Session to use for 'signon' authentication method
- *
- * @global string $cfg['Servers'][$i]['SignonSession']
- */
- $cfg['Servers'][$i]['SignonSession'] = '';
- /**
- * Cookie params to match session to use for 'signon' authentication method
- * It should be an associative array matching result of session_get_cookie_params() in other system
- *
- * @global array $cfg['Servers'][$i]['SignonCookieParams']
- */
- $cfg['Servers'][$i]['SignonCookieParams'] = [];
- /**
- * PHP script to use for 'signon' authentication method
- *
- * @global string $cfg['Servers'][$i]['SignonScript']
- */
- $cfg['Servers'][$i]['SignonScript'] = '';
- /**
- * URL where to redirect user to login for 'signon' authentication method
- *
- * @global string $cfg['Servers'][$i]['SignonURL']
- */
- $cfg['Servers'][$i]['SignonURL'] = '';
- /**
- * URL where to redirect user after logout
- *
- * @global string $cfg['Servers'][$i]['LogoutURL']
- */
- $cfg['Servers'][$i]['LogoutURL'] = '';
- /**
- * If set to a db-name, only this db is displayed in navigation panel
- * It may also be an array of db-names
- *
- * @global string $cfg['Servers'][$i]['only_db']
- */
- $cfg['Servers'][$i]['only_db'] = '';
- /**
- * Database name to be hidden from listings
- *
- * @global string $cfg['Servers'][$i]['hide_db']
- */
- $cfg['Servers'][$i]['hide_db'] = '';
- /**
- * Verbose name for this host - leave blank to show the hostname
- * (for HTTP authentication, all non-US-ASCII characters will be stripped)
- *
- * @global string $cfg['Servers'][$i]['verbose']
- */
- $cfg['Servers'][$i]['verbose'] = '';
- /**
- * Database used for Relation, Bookmark and PDF Features
- * (see sql/create_tables.sql)
- * - leave blank for no support
- * SUGGESTED: 'phpmyadmin'
- *
- * @global string $cfg['Servers'][$i]['pmadb']
- */
- $cfg['Servers'][$i]['pmadb'] = '';
- /**
- * Bookmark table
- * - leave blank for no bookmark support
- * SUGGESTED: 'pma__bookmark'
- *
- * @global string $cfg['Servers'][$i]['bookmarktable']
- */
- $cfg['Servers'][$i]['bookmarktable'] = '';
- /**
- * table to describe the relation between links (see doc)
- * - leave blank for no relation-links support
- * SUGGESTED: 'pma__relation'
- *
- * @global string $cfg['Servers'][$i]['relation']
- */
- $cfg['Servers'][$i]['relation'] = '';
- /**
- * table to describe the display fields
- * - leave blank for no display fields support
- * SUGGESTED: 'pma__table_info'
- *
- * @global string $cfg['Servers'][$i]['table_info']
- */
- $cfg['Servers'][$i]['table_info'] = '';
- /**
- * table to describe the tables position for the designer and PDF schema
- * - leave blank for no PDF schema support
- * SUGGESTED: 'pma__table_coords'
- *
- * @global string $cfg['Servers'][$i]['table_coords']
- */
- $cfg['Servers'][$i]['table_coords'] = '';
- /**
- * table to describe pages of relationpdf
- * - leave blank if you don't want to use this
- * SUGGESTED: 'pma__pdf_pages'
- *
- * @global string $cfg['Servers'][$i]['pdf_pages']
- */
- $cfg['Servers'][$i]['pdf_pages'] = '';
- /**
- * table to store column information
- * - leave blank for no column comments/mime types
- * SUGGESTED: 'pma__column_info'
- *
- * @global string $cfg['Servers'][$i]['column_info']
- */
- $cfg['Servers'][$i]['column_info'] = '';
- /**
- * table to store SQL history
- * - leave blank for no SQL query history
- * SUGGESTED: 'pma__history'
- *
- * @global string $cfg['Servers'][$i]['history']
- */
- $cfg['Servers'][$i]['history'] = '';
- /**
- * table to store recently used tables
- * - leave blank for no "persistent" recently used tables
- * SUGGESTED: 'pma__recent'
- */
- $cfg['Servers'][$i]['recent'] = '';
- /**
- * table to store favorite tables
- * - leave blank for no favorite tables
- * SUGGESTED: 'pma__favorite'
- */
- $cfg['Servers'][$i]['favorite'] = '';
- /**
- * table to store UI preferences for tables
- * - leave blank for no "persistent" UI preferences
- * SUGGESTED: 'pma__table_uiprefs'
- */
- $cfg['Servers'][$i]['table_uiprefs'] = '';
- /**
- * table to store SQL tracking
- * - leave blank for no SQL tracking
- * SUGGESTED: 'pma__tracking'
- *
- * @global string $cfg['Servers'][$i]['tracking']
- */
- $cfg['Servers'][$i]['tracking'] = '';
- /**
- * table to store user preferences
- * - leave blank to disable server storage
- * SUGGESTED: 'pma__userconfig'
- *
- * @global string $cfg['Servers'][$i]['userconfig']
- */
- $cfg['Servers'][$i]['userconfig'] = '';
- /**
- * table to store users and their assignment to user groups
- * - leave blank to disable configurable menus feature
- * SUGGESTED: 'pma__users'
- *
- * @global string $cfg['Servers'][$i]['users']
- */
- $cfg['Servers'][$i]['users'] = '';
- /**
- * table to store allowed menu items for each user group
- * - leave blank to disable configurable menus feature
- * SUGGESTED: 'pma__usergroups'
- *
- * @global string $cfg['Servers'][$i]['usergroups']
- */
- $cfg['Servers'][$i]['usergroups'] = '';
- /**
- * table to store information about item hidden from navigation tree
- * - leave blank to disable hide/show navigation items feature
- * SUGGESTED: 'pma__navigationhiding'
- *
- * @global string $cfg['Servers'][$i]['navigationhiding']
- */
- $cfg['Servers'][$i]['navigationhiding'] = '';
- /**
- * table to store information about saved searches from query-by-example on a db
- * - leave blank to disable saved searches feature
- * SUGGESTED: 'pma__savedsearches'
- *
- * @global string $cfg['Servers'][$i]['savedsearches']
- */
- $cfg['Servers'][$i]['savedsearches'] = '';
- /**
- * table to store central list of columns per database
- * - leave blank to disable central list of columns feature
- * SUGGESTED: 'pma__central_columns'
- *
- * @global string $cfg['Servers'][$i]['central_columns']
- */
- $cfg['Servers'][$i]['central_columns'] = '';
- /**
- * table to store designer settings
- * - leave blank to disable the storage of designer settings
- * SUGGESTED: 'pma__designer_settings'
- *
- * @global string $cfg['Servers'][$i]['designer_settings']
- */
- $cfg['Servers'][$i]['designer_settings'] = '';
- /**
- * table to store export templates
- * - leave blank to disable saved searches feature
- * SUGGESTED: 'pma__export_templates'
- *
- * @global string $cfg['Servers'][$i]['export_templates']
- */
- $cfg['Servers'][$i]['export_templates'] = '';
- /**
- * Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.
- *
- * In case where tables in databases is modified (e.g. dropped or renamed),
- * table_uiprefs may contains invalid data (referring to tables which are not
- * exist anymore).
- * This configuration make sure that we only keep N (N = MaxTableUiprefs)
- * newest record in table_uiprefs and automatically delete older records.
- *
- * @global integer $cfg['Servers'][$i]['userconfig'] = '';
- */
- $cfg['Servers'][$i]['MaxTableUiprefs'] = 100;
- /**
- * Sets the time zone used by phpMyAdmin. Possible values are explained at
- * https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
- *
- * @global string $cfg['Servers'][$i]['SessionTimeZone'] = ''
- */
- $cfg['Servers'][$i]['SessionTimeZone'] = '';
- /**
- * whether to allow root login
- *
- * @global boolean $cfg['Servers'][$i]['AllowRoot']
- */
- $cfg['Servers'][$i]['AllowRoot'] = true;
- /**
- * whether to allow login of any user without a password
- *
- * @global boolean $cfg['Servers'][$i]['AllowNoPassword']
- */
- $cfg['Servers'][$i]['AllowNoPassword'] = false;
- /**
- * Host authentication order, leave blank to not use
- *
- * @global string $cfg['Servers'][$i]['AllowDeny']['order']
- */
- $cfg['Servers'][$i]['AllowDeny']['order'] = '';
- /**
- * Host authentication rules, leave blank for defaults
- *
- * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
- */
- $cfg['Servers'][$i]['AllowDeny']['rules'] = [];
- /**
- * Disable use of INFORMATION_SCHEMA.
- *
- * @see https://github.com/phpmyadmin/phpmyadmin/issues/8970
- * @see https://bugs.mysql.com/19588
- *
- * @global boolean $cfg['Servers'][$i]['DisableIS']
- */
- $cfg['Servers'][$i]['DisableIS'] = false;
- /**
- * Whether the tracking mechanism creates
- * versions for tables and views automatically.
- *
- * @global bool $cfg['Servers'][$i]['tracking_version_auto_create']
- */
- $cfg['Servers'][$i]['tracking_version_auto_create'] = false;
- /**
- * Defines the list of statements
- * the auto-creation uses for new versions.
- *
- * @global string $cfg['Servers'][$i]['tracking_default_statements']
- */
- $cfg['Servers'][$i]['tracking_default_statements']
- = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,' .
- 'DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,' .
- 'ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
- /**
- * Whether a DROP VIEW IF EXISTS statement will be added
- * as first line to the log when creating a view.
- *
- * @global bool $cfg['Servers'][$i]['tracking_add_drop_view']
- */
- $cfg['Servers'][$i]['tracking_add_drop_view'] = true;
- /**
- * Whether a DROP TABLE IF EXISTS statement will be added
- * as first line to the log when creating a table.
- *
- * @global bool $cfg['Servers'][$i]['tracking_add_drop_table']
- */
- $cfg['Servers'][$i]['tracking_add_drop_table'] = true;
- /**
- * Whether a DROP DATABASE IF EXISTS statement will be added
- * as first line to the log when creating a database.
- *
- * @global bool $cfg['Servers'][$i]['tracking_add_drop_database']
- */
- $cfg['Servers'][$i]['tracking_add_drop_database'] = true;
- /**
- * Default server (0 = no default server)
- *
- * If you have more than one server configured, you can set $cfg['ServerDefault']
- * to any one of them to auto-connect to that server when phpMyAdmin is started,
- * or set it to 0 to be given a list of servers without logging in
- * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
- * set to that server.
- *
- * @global integer $cfg['ServerDefault']
- */
- $cfg['ServerDefault'] = 1;
- /*
- * Other core phpMyAdmin settings
- */
- /**
- * whether version check is active
- *
- * @global boolean $cfg['VersionCheck']
- */
- if (defined('VERSION_CHECK_DEFAULT')) {
- $cfg['VersionCheck'] = VERSION_CHECK_DEFAULT;
- } else {
- $cfg['VersionCheck'] = true;
- }
- /**
- * The url of the proxy to be used when retrieving the information about
- * the latest version of phpMyAdmin or error reporting. You need this if
- * the server where phpMyAdmin is installed does not have direct access to
- * the internet.
- * The format is: "hostname:portnumber"
- *
- * @global string $cfg['ProxyUrl']
- */
- $cfg['ProxyUrl'] = '';
- /**
- * The username for authenticating with the proxy. By default, no
- * authentication is performed. If a username is supplied, Basic
- * Authentication will be performed. No other types of authentication
- * are currently supported.
- *
- * @global string $cfg['ProxyUser']
- */
- $cfg['ProxyUser'] = '';
- /**
- * The password for authenticating with the proxy.
- *
- * @global string $cfg['ProxyPass']
- */
- $cfg['ProxyPass'] = '';
- /**
- * maximum number of db's displayed in database list
- *
- * @global integer $cfg['MaxDbList']
- */
- $cfg['MaxDbList'] = 100;
- /**
- * maximum number of tables displayed in table list
- *
- * @global integer $cfg['MaxTableList']
- */
- $cfg['MaxTableList'] = 250;
- /**
- * whether to show hint or not
- *
- * @global boolean $cfg['ShowHint']
- */
- $cfg['ShowHint'] = true;
- /**
- * maximum number of characters when a SQL query is displayed
- *
- * @global integer $cfg['MaxCharactersInDisplayedSQL']
- */
- $cfg['MaxCharactersInDisplayedSQL'] = 1000;
- /**
- * use GZIP output buffering if possible (true|false|'auto')
- *
- * @global string $cfg['OBGzip']
- */
- $cfg['OBGzip'] = 'auto';
- /**
- * use persistent connections to MySQL database
- *
- * @global boolean $cfg['PersistentConnections']
- */
- $cfg['PersistentConnections'] = false;
- /**
- * maximum execution time in seconds (0 for no limit)
- *
- * @global integer $cfg['ExecTimeLimit']
- */
- $cfg['ExecTimeLimit'] = 300;
- /**
- * Path for storing session data (session_save_path PHP parameter).
- *
- * @global integer $cfg['SessionSavePath']
- */
- $cfg['SessionSavePath'] = '';
- /**
- * Hosts or IPs to consider safe when checking if SSL is used or not
- *
- * @global array $cfg['MysqlSslWarningSafeHosts']
- */
- $cfg['MysqlSslWarningSafeHosts'] = ['127.0.0.1', 'localhost'];
- /**
- * maximum allocated bytes ('-1' for no limit, '0' for no change)
- * this is a string because '16M' is a valid value; we must put here
- * a string as the default value so that /setup accepts strings
- *
- * @global string $cfg['MemoryLimit']
- */
- $cfg['MemoryLimit'] = '-1';
- /**
- * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
- *
- * @global boolean $cfg['SkipLockedTables']
- */
- $cfg['SkipLockedTables'] = false;
- /**
- * show SQL queries as run
- *
- * @global boolean $cfg['ShowSQL']
- */
- $cfg['ShowSQL'] = true;
- /**
- * retain SQL input on Ajax execute
- *
- * @global boolean $cfg['RetainQueryEditor']
- */
- $cfg['RetainQueryBox'] = false;
- /**
- * use CodeMirror syntax highlighting for editing SQL
- *
- * @global boolean $cfg['CodemirrorEnable']
- */
- $cfg['CodemirrorEnable'] = true;
- /**
- * use the parser to find any errors in the query before executing
- *
- * @global boolean $cfg['LintEnable']
- */
- $cfg['LintEnable'] = true;
- /**
- * show a 'Drop database' link to normal users
- *
- * @global boolean $cfg['AllowUserDropDatabase']
- */
- $cfg['AllowUserDropDatabase'] = false;
- /**
- * confirm some commands that can result in loss of data
- *
- * @global boolean $cfg['Confirm']
- */
- $cfg['Confirm'] = true;
- /**
- * sets SameSite attribute of the Set-Cookie HTTP response header
- *
- * @global boolean $cfg['CookieSameSite']
- */
- $cfg['CookieSameSite'] = 'Strict';
- /**
- * recall previous login in cookie authentication mode or not
- *
- * @global boolean $cfg['LoginCookieRecall']
- */
- $cfg['LoginCookieRecall'] = true;
- /**
- * validity of cookie login (in seconds; 1440 matches php.ini's
- * session.gc_maxlifetime)
- *
- * @global integer $cfg['LoginCookieValidity']
- */
- $cfg['LoginCookieValidity'] = 1440;
- /**
- * how long login cookie should be stored (in seconds)
- *
- * @global integer $cfg['LoginCookieStore']
- */
- $cfg['LoginCookieStore'] = 0;
- /**
- * whether to delete all login cookies on logout
- *
- * @global boolean $cfg['LoginCookieDeleteAll']
- */
- $cfg['LoginCookieDeleteAll'] = true;
- /**
- * whether to enable the "database search" feature or not
- *
- * @global boolean $cfg['UseDbSearch']
- */
- $cfg['UseDbSearch'] = true;
- /**
- * if set to true, PMA continues computing multiple-statement queries
- * even if one of the queries failed
- *
- * @global boolean $cfg['IgnoreMultiSubmitErrors']
- */
- $cfg['IgnoreMultiSubmitErrors'] = false;
- /**
- * allow login to any user entered server in cookie based authentication
- *
- * @global boolean $cfg['AllowArbitraryServer']
- */
- $cfg['AllowArbitraryServer'] = false;
- /**
- * restrict by IP (with regular expression) the MySQL servers the user can enter
- * when $cfg['AllowArbitraryServer'] = true
- *
- * @global string $cfg['ArbitraryServerRegexp']
- */
- $cfg['ArbitraryServerRegexp'] = '';
- /**
- * To enable reCaptcha v2 checkbox mode if necessary
- *
- * @global string $cfg['CaptchaMethod']
- */
- $cfg['CaptchaMethod'] = 'invisible';
- /**
- * URL for the reCaptcha v2 compatible API to use
- *
- * @global string $cfg['CaptchaApi']
- */
- $cfg['CaptchaApi'] = 'https://www.google.com/recaptcha/api.js';
- /**
- * Content-Security-Policy snippet for the reCaptcha v2 compatible API
- *
- * @global string $cfg['CaptchaCsp']
- */
- $cfg['CaptchaCsp'] = 'https://apis.google.com https://www.google.com/recaptcha/'
- . ' https://www.gstatic.com/recaptcha/ https://ssl.gstatic.com/';
- /**
- * reCaptcha API's request parameter name
- *
- * @global string $cfg['CaptchaRequestParam']
- */
- $cfg['CaptchaRequestParam'] = 'g-recaptcha';
- /**
- * reCaptcha API's response parameter name
- *
- * @global string $cfg['CaptchaResponseParam']
- */
- $cfg['CaptchaResponseParam'] = 'g-recaptcha-response';
- /**
- * if reCaptcha is enabled it needs public key to connect with the service
- *
- * @global string $cfg['CaptchaLoginPublicKey']
- */
- $cfg['CaptchaLoginPublicKey'] = '';
- /**
- * if reCaptcha is enabled it needs private key to connect with the service
- *
- * @global string $cfg['CaptchaLoginPrivateKey']
- */
- $cfg['CaptchaLoginPrivateKey'] = '';
- /**
- * if reCaptcha is enabled may need an URL for site verify
- *
- * @global string $cfg['CaptchaSiteVerifyURL']
- */
- $cfg['CaptchaSiteVerifyURL'] = '';
- /**
- * Enable drag and drop import
- *
- * @see feature request : https://github.com/phpmyadmin/phpmyadmin/issues/13155
- *
- * @global bool $cfg['enable_drag_drop_import']
- */
- $cfg['enable_drag_drop_import'] = true;
- /*******************************************************************************
- * Navigation panel setup
- */
- /**
- * In the navigation panel, replaces the database tree with a selector
- *
- * @global boolean $cfg['ShowDatabasesNavigationAsTree']
- */
- $cfg['ShowDatabasesNavigationAsTree'] = true;
- /**
- * maximum number of first level databases displayed in navigation panel
- *
- * @global integer $cfg['FirstLevelNavigationItems']
- */
- $cfg['FirstLevelNavigationItems'] = 100;
- /**
- * maximum number of items displayed in navigation panel
- *
- * @global integer $cfg['MaxNavigationItems']
- */
- $cfg['MaxNavigationItems'] = 50;
- /**
- * turn the select-based light menu into a tree
- *
- * @global boolean $cfg['NavigationTreeEnableGrouping']
- */
- $cfg['NavigationTreeEnableGrouping'] = true;
- /**
- * the separator to sub-tree the select-based light menu tree
- *
- * @global string $cfg['NavigationTreeDbSeparator']
- */
- $cfg['NavigationTreeDbSeparator'] = '_';
- /**
- * Which string will be used to generate table prefixes
- * to split/nest tables into multiple categories
- *
- * @global string $cfg['NavigationTreeTableSeparator']
- */
- $cfg['NavigationTreeTableSeparator'] = '__';
- /**
- * How many sublevels should be displayed when splitting up tables
- * by the above Separator
- *
- * @global integer $cfg['NavigationTreeTableLevel']
- */
- $cfg['NavigationTreeTableLevel'] = 1;
- /**
- * link with main panel by highlighting the current db/table
- *
- * @global boolean $cfg['NavigationLinkWithMainPanel']
- */
- $cfg['NavigationLinkWithMainPanel'] = true;
- /**
- * display logo at top of navigation panel
- *
- * @global boolean $cfg['NavigationDisplayLogo']
- */
- $cfg['NavigationDisplayLogo'] = true;
- /**
- * where should logo link point to (can also contain an external URL)
- *
- * @global string $cfg['NavigationLogoLink']
- */
- $cfg['NavigationLogoLink'] = 'index.php';
- /**
- * whether to open the linked page in the main window ('main') or
- * in a new window ('new')
- *
- * @global string $cfg['NavigationLogoLinkWindow']
- */
- $cfg['NavigationLogoLinkWindow'] = 'main';
- /**
- * number of recently used tables displayed in the navigation panel
- *
- * @global integer $cfg['NumRecentTables']
- */
- $cfg['NumRecentTables'] = 10;
- /**
- * number of favorite tables displayed in the navigation panel
- *
- * @global integer $cfg['NumFavoriteTables']
- */
- $cfg['NumFavoriteTables'] = 10;
- /**
- * display a JavaScript table filter in the navigation panel
- * when more then x tables are present
- *
- * @global boolean $cfg['NavigationTreeDisplayItemFilterMinimum']
- */
- $cfg['NavigationTreeDisplayItemFilterMinimum'] = 30;
- /**
- * display server choice at top of navigation panel
- *
- * @global boolean $cfg['NavigationDisplayServers']
- */
- $cfg['NavigationDisplayServers'] = true;
- /**
- * server choice as links
- *
- * @global boolean $cfg['DisplayServersList']
- */
- $cfg['DisplayServersList'] = false;
- /**
- * display a JavaScript database filter in the navigation panel
- * when more then x databases are present
- *
- * @global boolean $cfg['NavigationTreeDisplayDbFilterMinimum']
- */
- $cfg['NavigationTreeDisplayDbFilterMinimum'] = 30;
- /**
- * target of the navigation panel quick access icon
- *
- * Possible values:
- * 'structure' = fields list
- * 'sql' = SQL form
- * 'search' = search page
- * 'insert' = insert row page
- * 'browse' = browse page
- *
- * @global string $cfg['NavigationTreeDefaultTabTable']
- */
- $cfg['NavigationTreeDefaultTabTable'] = 'structure';
- /**
- * target of the navigation panel quick second access icon
- *
- * Possible values:
- * 'structure' = fields list
- * 'sql' = SQL form
- * 'search' = search page
- * 'insert' = insert row page
- * 'browse' = browse page
- * '' = no link
- *
- * @global string $cfg['NavigationTreeDefaultTabTable2']
- */
- $cfg['NavigationTreeDefaultTabTable2'] = '';
- /**
- * Enables the possibility of navigation tree expansion
- *
- * @global boolean $cfg['NavigationTreeEnableExpansion']
- */
- $cfg['NavigationTreeEnableExpansion'] = true;
- /**
- * Show tables in navigation panel
- *
- * @global boolean $cfg['NavigationTreeShowTables']
- */
- $cfg['NavigationTreeShowTables'] = true;
- /**
- * Show views in navigation panel
- *
- * @global boolean $cfg['NavigationTreeShowViews']
- */
- $cfg['NavigationTreeShowViews'] = true;
- /**
- * Show functions in navigation panel
- *
- * @global boolean $cfg['NavigationTreeShowFunctions']
- */
- $cfg['NavigationTreeShowFunctions'] = true;
- /**
- * Show procedures in navigation panel
- *
- * @global boolean $cfg['NavigationTreeShowProcedures']
- */
- $cfg['NavigationTreeShowProcedures'] = true;
- /**
- * Show events in navigation panel
- *
- * @global boolean $cfg['NavigationTreeShowEvents']
- */
- $cfg['NavigationTreeShowEvents'] = true;
- /**
- * Width of navigation panel
- *
- * @global integer $cfg['NavigationWidth']
- */
- $cfg['NavigationWidth'] = 240;
- /**
- * Automatically expands single database in navigation panel
- *
- * @global boolean $cfg['NavigationAutoexpandSingleDb']
- */
- $cfg['NavigationTreeAutoexpandSingleDb'] = true;
- /*******************************************************************************
- * In the main panel, at startup...
- */
- /**
- * allow to display statistics and space usage in the pages about database
- * details and table properties
- *
- * @global boolean $cfg['ShowStats']
- */
- $cfg['ShowStats'] = true;
- /**
- * show PHP info link
- *
- * @global boolean $cfg['ShowPhpInfo']
- */
- $cfg['ShowPhpInfo'] = false;
- /**
- * show MySQL server and web server information
- *
- * @global boolean $cfg['ShowServerInfo']
- */
- $cfg['ShowServerInfo'] = true;
- /**
- * show change password link
- *
- * @global boolean $cfg['ShowChgPassword']
- */
- $cfg['ShowChgPassword'] = true;
- /**
- * show create database form
- *
- * @global boolean $cfg['ShowCreateDb']
- */
- $cfg['ShowCreateDb'] = true;
- /*******************************************************************************
- * Database structure
- */
- /** show charset column in database structure (true|false)?
- *
- * @global boolean $cfg['ShowDbStructureCharset']
- */
- $cfg['ShowDbStructureCharset'] = false;
- /**
- * show comment column in database structure (true|false)?
- *
- * @global boolean $cfg['ShowDbStructureComment']
- */
- $cfg['ShowDbStructureComment'] = false;
- /**
- * show creation timestamp column in database structure (true|false)?
- *
- * @global boolean $cfg['ShowDbStructureCreation']
- */
- $cfg['ShowDbStructureCreation'] = false;
- /**
- * show last update timestamp column in database structure (true|false)?
- *
- * @global boolean $cfg['ShowDbStructureLastUpdate']
- */
- $cfg['ShowDbStructureLastUpdate'] = false;
- /**
- * show last check timestamp column in database structure (true|false)?
- *
- * @global boolean $cfg['ShowDbStructureLastCheck']
- */
- $cfg['ShowDbStructureLastCheck'] = false;
- /**
- * allow hide action columns to drop down menu in database structure (true|false)?
- *
- * @global boolean $cfg['HideStructureActions']
- */
- $cfg['HideStructureActions'] = true;
- /**
- * Show column comments in table structure view (true|false)?
- *
- * @global boolean $cfg['ShowColumnComments']
- */
- $cfg['ShowColumnComments'] = true;
- /*******************************************************************************
- * In browse mode...
- */
- /**
- * Use icons instead of text for the navigation bar buttons (table browse)
- * ('text'|'icons'|'both')
- *
- * @global string $cfg['TableNavigationLinksMode']
- */
- $cfg['TableNavigationLinksMode'] = 'icons';
- /**
- * Defines whether a user should be displayed a "show all (records)"
- * button in browse mode or not.
- *
- * @global boolean $cfg['ShowAll']
- */
- $cfg['ShowAll'] = false;
- /**
- * Number of rows displayed when browsing a result set. If the result
- * set contains more rows, "Previous" and "Next".
- * Possible values: 25,50,100,250,500
- *
- * @global integer $cfg['MaxRows']
- */
- $cfg['MaxRows'] = 25;
- /**
- * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
- * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
- * ascending order else-)
- *
- * @global string $cfg['Order']
- */
- $cfg['Order'] = 'SMART';
- /**
- * grid editing: save edited cell(s) in browse-mode at once
- *
- * @global boolean $cfg['SaveCellsAtOnce']
- */
- $cfg['SaveCellsAtOnce'] = false;
- /**
- * grid editing: which action triggers it, or completely disable the feature
- *
- * Possible values:
- * 'click'
- * 'double-click'
- * 'disabled'
- *
- * @global string $cfg['GridEditing']
- */
- $cfg['GridEditing'] = 'double-click';
- /**
- * Options > Relational display
- *
- * Possible values:
- * 'K' for key value
- * 'D' for display column
- *
- * @global string $cfg['RelationalDisplay']
- */
- $cfg['RelationalDisplay'] = 'K';
- /*******************************************************************************
- * In edit mode...
- */
- /**
- * disallow editing of binary fields
- * valid values are:
- * false allow editing
- * 'blob' allow editing except for BLOB fields
- * 'noblob' disallow editing except for BLOB fields
- * 'all' disallow editing
- *
- * @global string $cfg['ProtectBinary']
- */
- $cfg['ProtectBinary'] = 'blob';
- /**
- * Display the function fields in edit/insert mode
- *
- * @global boolean $cfg['ShowFunctionFields']
- */
- $cfg['ShowFunctionFields'] = true;
- /**
- * Display the type fields in edit/insert mode
- *
- * @global boolean $cfg['ShowFieldTypesInDataEditView']
- */
- $cfg['ShowFieldTypesInDataEditView'] = true;
- /**
- * Which editor should be used for CHAR/VARCHAR fields:
- * input - allows limiting of input length
- * textarea - allows newlines in fields
- *
- * @global string $cfg['CharEditing']
- */
- $cfg['CharEditing'] = 'input';
- /**
- * The minimum size for character input fields
- *
- * @global integer $cfg['MinSizeForInputField']
- */
- $cfg['MinSizeForInputField'] = 4;
- /**
- * The maximum size for character input fields
- *
- * @global integer $cfg['MinSizeForInputField']
- */
- $cfg['MaxSizeForInputField'] = 60;
- /**
- * How many rows can be inserted at one time
- *
- * @global integer $cfg['InsertRows']
- */
- $cfg['InsertRows'] = 2;
- /**
- * Sort order for items in a foreign-key drop-down list.
- * 'content' is the referenced data, 'id' is the key value.
- *
- * @global array $cfg['ForeignKeyDropdownOrder']
- */
- $cfg['ForeignKeyDropdownOrder'] = [
- 'content-id',
- 'id-content',
- ];
- /**
- * A drop-down list will be used if fewer items are present
- *
- * @global integer $cfg['ForeignKeyMaxLimit']
- */
- $cfg['ForeignKeyMaxLimit'] = 100;
- /**
- * Whether to disable foreign key checks while importing
- *
- * @global boolean $cfg['DefaultForeignKeyChecks']
- */
- $cfg['DefaultForeignKeyChecks'] = 'default';
- /*******************************************************************************
- * For the export features...
- */
- /**
- * Allow for the use of zip compression (requires zip support to be enabled)
- *
- * @global boolean $cfg['ZipDump']
- */
- $cfg['ZipDump'] = true;
- /**
- * Allow for the use of gzip compression (requires zlib)
- *
- * @global boolean $cfg['GZipDump']
- */
- $cfg['GZipDump'] = true;
- /**
- * Allow for the use of bzip2 decompression (requires bz2 extension)
- *
- * @global boolean $cfg['BZipDump']
- */
- $cfg['BZipDump'] = true;
- /**
- * Will compress gzip exports on the fly without the need for much memory.
- * If you encounter problems with created gzip files disable this feature.
- *
- * @global boolean $cfg['CompressOnFly']
- */
- $cfg['CompressOnFly'] = true;
- /*******************************************************************************
- * Tabs display settings
- */
- /**
- * How to display the menu tabs ('icons'|'text'|'both')
- *
- * @global boolean $cfg['TabsMode']
- */
- $cfg['TabsMode'] = 'both';
- /**
- * How to display various action links ('icons'|'text'|'both')
- *
- * @global boolean $cfg['ActionLinksMode']
- */
- $cfg['ActionLinksMode'] = 'both';
- /**
- * How many columns should be used for table display of a database?
- * (a value larger than 1 results in some information being hidden)
- *
- * @global integer $cfg['PropertiesNumColumns']
- */
- $cfg['PropertiesNumColumns'] = 1;
- /**
- * Possible values:
- * 'welcome' = the welcome page
- * (recommended for multiuser setups)
- * 'databases' = list of databases
- * 'status' = runtime information
- * 'variables' = MySQL server variables
- * 'privileges' = user management
- *
- * @global string $cfg['DefaultTabServer']
- */
- $cfg['DefaultTabServer'] = 'welcome';
- /**
- * Possible values:
- * 'structure' = tables list
- * 'sql' = SQL form
- * 'search' = search query
- * 'operations' = operations on database
- *
- * @global string $cfg['DefaultTabDatabase']
- */
- $cfg['DefaultTabDatabase'] = 'structure';
- /**
- * Possible values:
- * 'structure' = fields list
- * 'sql' = SQL form
- * 'search' = search page
- * 'insert' = insert row page
- * 'browse' = browse page
- *
- * @global string $cfg['DefaultTabTable']
- */
- $cfg['DefaultTabTable'] = 'browse';
- /**
- * Whether to display image or text or both image and text in table row
- * action segment. Value can be either of ``image``, ``text`` or ``both``.
- */
- $cfg['RowActionType'] = 'both';
- /*******************************************************************************
- * Export defaults
- */
- $cfg['Export'] = [];
- /**
- * codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xml/yaml
- *
- * @global string $cfg['Export']['format']
- */
- $cfg['Export']['format'] = 'sql';
- /**
- * quick/custom/custom-no-form
- *
- * @global string $cfg['Export']['format']
- */
- $cfg['Export']['method'] = 'quick';
- /**
- * none/zip/gzip
- *
- * @global string $cfg['Export']['compression']
- */
- $cfg['Export']['compression'] = 'none';
- /**
- * Whether to LOCK TABLES before exporting
- *
- * @global boolean $cfg['Export']['lock_tables']
- */
- $cfg['Export']['lock_tables'] = false;
- /**
- * Whether to export databases/tables as separate files
- *
- * @global boolean $cfg['Export']['as_separate_files']
- */
- $cfg['Export']['as_separate_files'] = false;
- /**
- * @global boolean $cfg['Export']['asfile']
- */
- $cfg['Export']['asfile'] = true;
- /**
- * @global string $cfg['Export']['charset']
- */
- $cfg['Export']['charset'] = '';
- /**
- * @global boolean $cfg['Export']['onserver']
- */
- $cfg['Export']['onserver'] = false;
- /**
- * @global boolean $cfg['Export']['onserver_overwrite']
- */
- $cfg['Export']['onserver_overwrite'] = false;
- /**
- * @global boolean $cfg['Export']['quick_export_onserver']
- */
- $cfg['Export']['quick_export_onserver'] = false;
- /**
- * @global boolean $cfg['Export']['quick_export_onserver_overwrite']
- */
- $cfg['Export']['quick_export_onserver_overwrite'] = false;
- /**
- * @global boolean $cfg['Export']['remember_file_template']
- */
- $cfg['Export']['remember_file_template'] = true;
- /**
- * @global string $cfg['Export']['file_template_table']
- */
- $cfg['Export']['file_template_table'] = '@TABLE@';
- /**
- * @global string $cfg['Export']['file_template_database']
- */
- $cfg['Export']['file_template_database'] = '@DATABASE@';
- /**
- * @global string $cfg['Export']['file_template_server']
- */
- $cfg['Export']['file_template_server'] = '@SERVER@';
- /**
- * @global string $cfg['Export']['codegen_structure_or_data']
- */
- $cfg['Export']['codegen_structure_or_data'] = 'data';
- /**
- * @global $cfg['Export']['codegen_format']
- */
- $cfg['Export']['codegen_format'] = 0;
- /**
- * @global boolean $cfg['Export']['ods_columns']
- */
- $cfg['Export']['ods_columns'] = false;
- /**
- * @global string $cfg['Export']['ods_null']
- */
- $cfg['Export']['ods_null'] = 'NULL';
- /**
- * @global string $cfg['Export']['odt_structure_or_data']
- */
- $cfg['Export']['odt_structure_or_data'] = 'structure_and_data';
- /**
- * @global boolean $cfg['Export']['odt_columns']
- */
- $cfg['Export']['odt_columns'] = true;
- /**
- * @global boolean $cfg['Export']['odt_relation']
- */
- $cfg['Export']['odt_relation'] = true;
- /**
- * @global boolean $cfg['Export']['odt_comments']
- */
- $cfg['Export']['odt_comments'] = true;
- /**
- * @global boolean $cfg['Export']['odt_mime']
- */
- $cfg['Export']['odt_mime'] = true;
- /**
- * @global string $cfg['Export']['odt_null']
- */
- $cfg['Export']['odt_null'] = 'NULL';
- /**
- * @global boolean $cfg['Export']['htmlword_structure_or_data']
- */
- $cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';
- /**
- * @global boolean $cfg['Export']['htmlword_columns']
- */
- $cfg['Export']['htmlword_columns'] = false;
- /**
- * @global string $cfg['Export']['htmlword_null']
- */
- $cfg['Export']['htmlword_null'] = 'NULL';
- /**
- * @global string $cfg['Export']['texytext_structure_or_data']
- */
- $cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';
- /**
- * @global boolean $cfg['Export']['texytext_columns']
- */
- $cfg['Export']['texytext_columns'] = false;
- /**
- * @global string $cfg['Export']['texytext_null']
- */
- $cfg['Export']['texytext_null'] = 'NULL';
- /**
- * @global boolean $cfg['Export']['csv_columns']
- */
- $cfg['Export']['csv_columns'] = false;
- /**
- * @global string $cfg['Export']['csv_structure_or_data']
- */
- $cfg['Export']['csv_structure_or_data'] = 'data';
- /**
- * @global string $cfg['Export']['csv_null']
- */
- $cfg['Export']['csv_null'] = 'NULL';
- /**
- * @global string $cfg['Export']['csv_separator']
- */
- $cfg['Export']['csv_separator'] = ',';
- /**
- * @global string $cfg['Export']['csv_enclosed']
- */
- $cfg['Export']['csv_enclosed'] = '"';
- /**
- * @global string $cfg['Export']['csv_escaped']
- */
- $cfg['Export']['csv_escaped'] = '"';
- /**
- * @global string $cfg['Export']['csv_terminated']
- */
- $cfg['Export']['csv_terminated'] = 'AUTO';
- /**
- * @global string $cfg['Export']['csv_removeCRLF']
- */
- $cfg['Export']['csv_removeCRLF'] = false;
- /**
- * @global boolean $cfg['Export']['excel_columns']
- */
- $cfg['Export']['excel_columns'] = true;
- /**
- * @global string $cfg['Export']['excel_null']
- */
- $cfg['Export']['excel_null'] = 'NULL';
- /**
- * win/mac
- *
- * @global string $cfg['Export']['excel_edition']
- */
- $cfg['Export']['excel_edition'] = 'win';
- /**
- * @global string $cfg['Export']['excel_removeCRLF']
- */
- $cfg['Export']['excel_removeCRLF'] = false;
- /**
- * @global string $cfg['Export']['excel_structure_or_data']
- */
- $cfg['Export']['excel_structure_or_data'] = 'data';
- /**
- * @global string $cfg['Export']['latex_structure_or_data']
- */
- $cfg['Export']['latex_structure_or_data'] = 'structure_and_data';
- /**
- * @global boolean $cfg['Export']['latex_columns']
- */
- $cfg['Export']['latex_columns'] = true;
- /**
- * @global boolean $cfg['Export']['latex_relation']
- */
- $cfg['Export']['latex_relation'] = true;
- /**
- * @global boolean $cfg['Export']['latex_comments']
- */
- $cfg['Export']['latex_comments'] = true;
- /**
- * @global boolean $cfg['Export']['latex_mime']
- */
- $cfg['Export']['latex_mime'] = true;
- /**
- * @global string $cfg['Export']['latex_null']
- */
- $cfg['Export']['latex_null'] = '\textit{NULL}';
- /**
- * @global boolean $cfg['Export']['latex_caption']
- */
- $cfg['Export']['latex_caption'] = true;
- /**
- * @global string $cfg['Export']['latex_structure_caption']
- */
- $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
- /**
- * @global string $cfg['Export']['latex_structure_continued_caption']
- */
- $cfg['Export']['latex_structure_continued_caption']
- = 'strLatexStructure strLatexContinued';
- /**
- * @global string $cfg['Export']['latex_data_caption']
- */
- $cfg['Export']['latex_data_caption'] = 'strLatexContent';
- /**
- * @global string $cfg['Export']['latex_data_continued_caption']
- */
- $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
- /**
- * @global string $cfg['Export']['latex_data_label']
- */
- $cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';
- /**
- * @global string $cfg['Export']['latex_structure_label']
- */
- $cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';
- /**
- * @global string $cfg['Export']['mediawiki_structure_or_data']
- */
- $cfg['Export']['mediawiki_structure_or_data'] = 'data';
- /**
- * @global boolean $cfg['Export']['mediawiki_caption']
- */
- $cfg['Export']['mediawiki_caption'] = true;
- /**
- * @global boolean $cfg['Export']['mediawiki_headers']
- */
- $cfg['Export']['mediawiki_headers'] = true;
- /**
- * @global string $cfg['Export']['ods_structure_or_data']
- */
- $cfg['Export']['ods_structure_or_data'] = 'data';
- /**
- * @global string $cfg['Export']['pdf_structure_or_data']
- */
- $cfg['Export']['pdf_structure_or_data'] = 'data';
- /**
- * @global string $cfg['Export']['phparray_structure_or_data']
- */
- $cfg['Export']['phparray_structure_or_data'] = 'data';
- /**
- * @global string $cfg['Export']['json_structure_or_data']
- */
- $cfg['Export']['json_structure_or_data'] = 'data';
- /**
- * Export functions
- *
- * @global string $cfg['Export']['json_pretty_print']
- */
- $cfg['Export']['json_pretty_print'] = false;
- /**
- * Export functions
- *
- * @global string $cfg['Export']['json_unicode']
- */
- $cfg['Export']['json_unicode'] = true;
- /**
- * @global string $cfg['Export']['sql_structure_or_data']
- */
- $cfg['Export']['sql_structure_or_data'] = 'structure_and_data';
- /**
- * @global string $cfg['Export']['sql_compatibility']
- */
- $cfg['Export']['sql_compatibility'] = 'NONE';
- /**
- * Whether to include comments in SQL export.
- *
- * @global string $cfg['Export']['sql_include_comments']
- */
- $cfg['Export']['sql_include_comments'] = true;
- /**
- * @global boolean $cfg['Export']['sql_disable_fk']
- */
- $cfg['Export']['sql_disable_fk'] = false;
- /**
- * @global boolean $cfg['Export']['sql_views_as_tables']
- */
- $cfg['Export']['sql_views_as_tables'] = false;
- /**
- * @global boolean $cfg['Export']['sql_metadata']
- */
- $cfg['Export']['sql_metadata'] = false;
- /**
- * @global boolean $cfg['Export']['sql_use_transaction']
- */
- $cfg['Export']['sql_use_transaction'] = true;
- /**
- * @global boolean $cfg['Export']['sql_create_database']
- */
- $cfg['Export']['sql_create_database'] = false;
- /**
- * @global boolean $cfg['Export']['sql_drop_database']
- */
- $cfg['Export']['sql_drop_database'] = false;
- /**
- * @global boolean $cfg['Export']['sql_drop_table']
- */
- $cfg['Export']['sql_drop_table'] = false;
- /**
- * true by default for correct behavior when dealing with exporting
- * of VIEWs and the stand-in table
- *
- * @global boolean $cfg['Export']['sql_if_not_exists']
- */
- $cfg['Export']['sql_if_not_exists'] = false;
- /**
- * @global boolean $cfg['Export']['sql_view_current_user']
- */
- $cfg['Export']['sql_view_current_user'] = false;
- /**
- * @global boolean $cfg['Export']['sql_or_replace']
- */
- $cfg['Export']['sql_or_replace_view'] = false;
- /**
- * @global boolean $cfg['Export']['sql_procedure_function']
- */
- $cfg['Export']['sql_procedure_function'] = true;
- /**
- * @global boolean $cfg['Export']['sql_create_table']
- */
- $cfg['Export']['sql_create_table'] = true;
- /**
- * @global boolean $cfg['Export']['sql_create_view']
- */
- $cfg['Export']['sql_create_view'] = true;
- /**
- * @global boolean $cfg['Export']['sql_create_trigger']
- */
- $cfg['Export']['sql_create_trigger'] = true;
- /**
- * @global boolean $cfg['Export']['sql_auto_increment']
- */
- $cfg['Export']['sql_auto_increment'] = true;
- /**
- * @global boolean $cfg['Export']['sql_backquotes']
- */
- $cfg['Export']['sql_backquotes'] = true;
- /**
- * @global boolean $cfg['Export']['sql_dates']
- */
- $cfg['Export']['sql_dates'] = false;
- /**
- * @global boolean $cfg['Export']['sql_relation']
- */
- $cfg['Export']['sql_relation'] = false;
- /**
- * @global boolean $cfg['Export']['sql_truncate']
- */
- $cfg['Export']['sql_truncate'] = false;
- /**
- * @global boolean $cfg['Export']['sql_delayed']
- */
- $cfg['Export']['sql_delayed'] = false;
- /**
- * @global boolean $cfg['Export']['sql_ignore']
- */
- $cfg['Export']['sql_ignore'] = false;
- /**
- * Export time in UTC.
- *
- * @global boolean $cfg['Export']['sql_utc_time']
- */
- $cfg['Export']['sql_utc_time'] = true;
- /**
- * @global boolean $cfg['Export']['sql_hex_for_binary']
- */
- $cfg['Export']['sql_hex_for_binary'] = true;
- /**
- * insert/update/replace
- *
- * @global string $cfg['Export']['sql_type']
- */
- $cfg['Export']['sql_type'] = 'INSERT';
- /**
- * @global integer $cfg['Export']['sql_max_query_size']
- */
- $cfg['Export']['sql_max_query_size'] = 50000;
- /**
- * @global boolean $cfg['Export']['sql_mime']
- */
- $cfg['Export']['sql_mime'] = false;
- /**
- * \n is replaced by new line
- *
- * @global string $cfg['Export']['sql_header_comment']
- */
- $cfg['Export']['sql_header_comment'] = '';
- /**
- * Whether to use complete inserts, extended inserts, both, or neither
- *
- * @global string $cfg['Export']['sql_insert_syntax']
- */
- $cfg['Export']['sql_insert_syntax'] = 'both';
- /**
- * @global string $cfg['Export']['pdf_report_title']
- */
- $cfg['Export']['pdf_report_title'] = '';
- /**
- * @global string $cfg['Export']['xml_structure_or_data']
- */
- $cfg['Export']['xml_structure_or_data'] = 'data';
- /**
- * Export schema for each structure
- *
- * @global string $cfg['Export']['xml_export_struc']
- */
- $cfg['Export']['xml_export_struc'] = true;
- /**
- * Export events
- *
- * @global string $cfg['Export']['xml_export_events']
- */
- $cfg['Export']['xml_export_events'] = true;
- /**
- * Export functions
- *
- * @global string $cfg['Export']['xml_export_functions']
- */
- $cfg['Export']['xml_export_functions'] = true;
- /**
- * Export procedures
- *
- * @global string $cfg['Export']['xml_export_procedures']
- */
- $cfg['Export']['xml_export_procedures'] = true;
- /**
- * Export schema for each table
- *
- * @global string $cfg['Export']['xml_export_tables']
- */
- $cfg['Export']['xml_export_tables'] = true;
- /**
- * Export triggers
- *
- * @global string $cfg['Export']['xml_export_triggers']
- */
- $cfg['Export']['xml_export_triggers'] = true;
- /**
- * Export views
- *
- * @global string $cfg['Export']['xml_export_views']
- */
- $cfg['Export']['xml_export_views'] = true;
- /**
- * Export contents data
- *
- * @global string $cfg['Export']['xml_export_contents']
- */
- $cfg['Export']['xml_export_contents'] = true;
- /**
- * @global string $cfg['Export']['yaml_structure_or_data']
- */
- $cfg['Export']['yaml_structure_or_data'] = 'data';
- /*******************************************************************************
- * Import defaults
- */
- $cfg['Import'] = [];
- /**
- * @global string $cfg['Import']['format']
- */
- $cfg['Import']['format'] = 'sql';
- /**
- * Default charset for import.
- *
- * @global string $cfg['Import']['charset']
- */
- $cfg['Import']['charset'] = '';
- /**
- * @global boolean $cfg['Import']['allow_interrupt']
- */
- $cfg['Import']['allow_interrupt'] = true;
- /**
- * @global integer $cfg['Import']['skip_queries']
- */
- $cfg['Import']['skip_queries'] = 0;
- /**
- * @global string $cfg['Import']['sql_compatibility']
- */
- $cfg['Import']['sql_compatibility'] = 'NONE';
- /**
- * @global string $cfg['Import']['sql_no_auto_value_on_zero']
- */
- $cfg['Import']['sql_no_auto_value_on_zero'] = true;
- /**
- * @global string $cfg['Import']['sql_read_as_multibytes']
- */
- $cfg['Import']['sql_read_as_multibytes'] = false;
- /**
- * @global boolean $cfg['Import']['csv_replace']
- */
- $cfg['Import']['csv_replace'] = false;
- /**
- * @global boolean $cfg['Import']['csv_ignore']
- */
- $cfg['Import']['csv_ignore'] = false;
- /**
- * @global string $cfg['Import']['csv_terminated']
- */
- $cfg['Import']['csv_terminated'] = ',';
- /**
- * @global string $cfg['Import']['csv_enclosed']
- */
- $cfg['Import']['csv_enclosed'] = '"';
- /**
- * @global string $cfg['Import']['csv_escaped']
- */
- $cfg['Import']['csv_escaped'] = '"';
- /**
- * @global string $cfg['Import']['csv_new_line']
- */
- $cfg['Import']['csv_new_line'] = 'auto';
- /**
- * @global string $cfg['Import']['csv_columns']
- */
- $cfg['Import']['csv_columns'] = '';
- /**
- * @global string $cfg['Import']['csv_col_names']
- */
- $cfg['Import']['csv_col_names'] = false;
- /**
- * @global boolean $cfg['Import']['ldi_replace']
- */
- $cfg['Import']['ldi_replace'] = false;
- /**
- * @global boolean $cfg['Import']['ldi_ignore']
- */
- $cfg['Import']['ldi_ignore'] = false;
- /**
- * @global string $cfg['Import']['ldi_terminated']
- */
- $cfg['Import']['ldi_terminated'] = ';';
- /**
- * @global string $cfg['Import']['ldi_enclosed']
- */
- $cfg['Import']['ldi_enclosed'] = '"';
- /**
- * @global string $cfg['Import']['ldi_escaped']
- */
- $cfg['Import']['ldi_escaped'] = '\\';
- /**
- * @global string $cfg['Import']['ldi_new_line']
- */
- $cfg['Import']['ldi_new_line'] = 'auto';
- /**
- * @global string $cfg['Import']['ldi_columns']
- */
- $cfg['Import']['ldi_columns'] = '';
- /**
- * 'auto' for auto-detection, true or false for forcing
- *
- * @global string $cfg['Import']['ldi_local_option']
- */
- $cfg['Import']['ldi_local_option'] = 'auto';
- /**
- * @global string $cfg['Import']['ods_col_names']
- */
- $cfg['Import']['ods_col_names'] = false;
- /**
- * @global string $cfg['Import']['ods_empty_rows']
- */
- $cfg['Import']['ods_empty_rows'] = true;
- /**
- * @global string $cfg['Import']['ods_recognize_percentages']
- */
- $cfg['Import']['ods_recognize_percentages'] = true;
- /**
- * @global string $cfg['Import']['ods_recognize_currency']
- */
- $cfg['Import']['ods_recognize_currency'] = true;
- /*******************************************************************************
- * Schema export defaults
- */
- $cfg['Schema'] = [];
- /**
- * pdf/eps/dia/svg
- *
- * @global string $cfg['Schema']['format']
- */
- $cfg['Schema']['format'] = 'pdf';
- /**
- * @global string $cfg['Schema']['pdf_show_color']
- */
- $cfg['Schema']['pdf_show_color'] = true;
- /**
- * @global string $cfg['Schema']['pdf_show_keys']
- */
- $cfg['Schema']['pdf_show_keys'] = false;
- /**
- * @global string $cfg['Schema']['pdf_all_tables_same_width']
- */
- $cfg['Schema']['pdf_all_tables_same_width'] = false;
- /**
- * L/P
- *
- * @global string $cfg['Schema']['pdf_orientation']
- */
- $cfg['Schema']['pdf_orientation'] = 'L';
- /**
- * @global string $cfg['Schema']['pdf_paper']
- */
- $cfg['Schema']['pdf_paper'] = 'A4';
- /**
- * @global string $cfg['Schema']['pdf_show_grid']
- */
- $cfg['Schema']['pdf_show_grid'] = false;
- /**
- * @global string $cfg['Schema']['pdf_with_doc']
- */
- $cfg['Schema']['pdf_with_doc'] = true;
- /**
- * @global string $cfg['Schema']['pdf_table_order']
- */
- $cfg['Schema']['pdf_table_order'] = '';
- /**
- * @global string $cfg['Schema']['dia_show_color']
- */
- $cfg['Schema']['dia_show_color'] = true;
- /**
- * @global string $cfg['Schema']['dia_show_keys']
- */
- $cfg['Schema']['dia_show_keys'] = false;
- /**
- * L/P
- *
- * @global string $cfg['Schema']['dia_orientation']
- */
- $cfg['Schema']['dia_orientation'] = 'L';
- /**
- * @global string $cfg['Schema']['dia_paper']
- */
- $cfg['Schema']['dia_paper'] = 'A4';
- /**
- * @global string $cfg['Schema']['eps_show_color']
- */
- $cfg['Schema']['eps_show_color'] = true;
- /**
- * @global string $cfg['Schema']['eps_show_keys']
- */
- $cfg['Schema']['eps_show_keys'] = false;
- /**
- * @global string $cfg['Schema']['eps_all_tables_same_width']
- */
- $cfg['Schema']['eps_all_tables_same_width'] = false;
- /**
- * L/P
- *
- * @global string $cfg['Schema']['eps_orientation']
- */
- $cfg['Schema']['eps_orientation'] = 'L';
- /**
- * @global string $cfg['Schema']['svg_show_color']
- */
- $cfg['Schema']['svg_show_color'] = true;
- /**
- * @global string $cfg['Schema']['svg_show_keys']
- */
- $cfg['Schema']['svg_show_keys'] = false;
- /**
- * @global string $cfg['Schema']['svg_all_tables_same_width']
- */
- $cfg['Schema']['svg_all_tables_same_width'] = false;
- /*******************************************************************************
- * PDF options
- */
- /**
- * @global array $cfg['PDFPageSizes']
- */
- $cfg['PDFPageSizes'] = [
- 'A3',
- 'A4',
- 'A5',
- 'letter',
- 'legal',
- ];
- /**
- * @global string $cfg['PDFDefaultPageSize']
- */
- $cfg['PDFDefaultPageSize'] = 'A4';
- /*******************************************************************************
- * Language and character set conversion settings
- */
- /**
- * Default language to use, if not browser-defined or user-defined
- *
- * @global string $cfg['DefaultLang']
- */
- $cfg['DefaultLang'] = 'en';
- /**
- * Default connection collation
- *
- * @global string $cfg['DefaultConnectionCollation']
- */
- $cfg['DefaultConnectionCollation'] = 'utf8mb4_unicode_ci';
- /**
- * Force: always use this language, e.g. 'en'
- *
- * @global string $cfg['Lang']
- */
- $cfg['Lang'] = '';
- /**
- * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
- * English only
- *
- * @global string $cfg['FilterLanguages']
- */
- $cfg['FilterLanguages'] = '';
- /**
- * You can select here which functions will be used for character set conversion.
- * Possible values are:
- * auto - automatically use available one (first is tested iconv, then
- * recode)
- * iconv - use iconv or libiconv functions
- * recode - use recode_string function
- * mb - use mbstring extension
- * none - disable encoding conversion
- *
- * @global string $cfg['RecodingEngine']
- */
- $cfg['RecodingEngine'] = 'auto';
- /**
- * Specify some parameters for iconv used in character set conversion. See iconv
- * documentation for details:
- * https://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1.15/iconv_open.3.html
- *
- * @global string $cfg['IconvExtraParams']
- */
- $cfg['IconvExtraParams'] = '//TRANSLIT';
- /**
- * Available character sets for MySQL conversion. currently contains all which could
- * be found in lang/* files and few more.
- * Character sets will be shown in same order as here listed, so if you frequently
- * use some of these move them to the top.
- *
- * @global array $cfg['AvailableCharsets']
- */
- $cfg['AvailableCharsets'] = [
- 'iso-8859-1',
- 'iso-8859-2',
- 'iso-8859-3',
- 'iso-8859-4',
- 'iso-8859-5',
- 'iso-8859-6',
- 'iso-8859-7',
- 'iso-8859-8',
- 'iso-8859-9',
- 'iso-8859-10',
- 'iso-8859-11',
- 'iso-8859-12',
- 'iso-8859-13',
- 'iso-8859-14',
- 'iso-8859-15',
- 'windows-1250',
- 'windows-1251',
- 'windows-1252',
- 'windows-1256',
- 'windows-1257',
- 'koi8-r',
- 'big5',
- 'gb2312',
- 'utf-16',
- 'utf-8',
- 'utf-7',
- 'x-user-defined',
- 'euc-jp',
- 'ks_c_5601-1987',
- 'tis-620',
- 'SHIFT_JIS',
- 'SJIS',
- 'SJIS-win',
- ];
- /*******************************************************************************
- * Customization & design
- *
- * The graphical settings are now located in themes/theme-name/scss/_variables.scss
- */
- /**
- * enable the left panel pointer
- *
- * @global boolean $cfg['NavigationTreePointerEnable']
- */
- $cfg['NavigationTreePointerEnable'] = true;
- /**
- * enable the browse pointer
- *
- * @global boolean $cfg['BrowsePointerEnable']
- */
- $cfg['BrowsePointerEnable'] = true;
- /**
- * enable the browse marker
- *
- * @global boolean $cfg['BrowseMarkerEnable']
- */
- $cfg['BrowseMarkerEnable'] = true;
- /**
- * textarea size (columns) in edit mode
- * (this value will be emphasized (*2) for SQL
- * query textareas and (*1.25) for query window)
- *
- * @global integer $cfg['TextareaCols']
- */
- $cfg['TextareaCols'] = 40;
- /**
- * textarea size (rows) in edit mode
- *
- * @global integer $cfg['TextareaRows']
- */
- $cfg['TextareaRows'] = 15;
- /**
- * double size of textarea size for LONGTEXT columns
- *
- * @global boolean $cfg['LongtextDoubleTextarea']
- */
- $cfg['LongtextDoubleTextarea'] = true;
- /**
- * auto-select when clicking in the textarea of the query-box
- *
- * @global boolean $cfg['TextareaAutoSelect']
- */
- $cfg['TextareaAutoSelect'] = false;
- /**
- * textarea size (columns) for CHAR/VARCHAR
- *
- * @global integer $cfg['CharTextareaCols']
- */
- $cfg['CharTextareaCols'] = 40;
- /**
- * textarea size (rows) for CHAR/VARCHAR
- *
- * @global integer $cfg['CharTextareaRows']
- */
- $cfg['CharTextareaRows'] = 2;
- /**
- * Max field data length in browse mode for all non-numeric fields
- *
- * @global integer $cfg['LimitChars']
- */
- $cfg['LimitChars'] = 50;
- /**
- * Where to show the edit/copy/delete links in browse mode
- * Possible values are 'left', 'right', 'both' and 'none'.
- *
- * @global string $cfg['RowActionLinks']
- */
- $cfg['RowActionLinks'] = 'left';
- /**
- * Whether to show row links (Edit, Copy, Delete) and checkboxes for
- * multiple row operations even when the selection does not have a unique key.
- *
- * @global boolean $cfg['RowActionLinksWithoutUnique']
- */
- $cfg['RowActionLinksWithoutUnique'] = false;
- /**
- * Default sort order by primary key.
- *
- * @global string $cfg['TablePrimaryKeyOrder']
- */
- $cfg['TablePrimaryKeyOrder'] = 'NONE';
- /**
- * remember the last way a table sorted
- *
- * @global string $cfg['RememberSorting']
- */
- $cfg['RememberSorting'] = true;
- /**
- * shows column comments in 'browse' mode.
- *
- * @global boolean $cfg['ShowBrowseComments']
- */
- $cfg['ShowBrowseComments'] = true;
- /**
- * shows column comments in 'table property' mode.
- *
- * @global boolean $cfg['ShowPropertyComments']
- */
- $cfg['ShowPropertyComments'] = true;
- /**
- * repeat header names every X cells? (0 = deactivate)
- *
- * @global integer $cfg['RepeatCells']
- */
- $cfg['RepeatCells'] = 100;
- /**
- * Set to true if you want DB-based query history.If false, this utilizes
- * JS-routines to display query history (lost by window close)
- *
- * @global boolean $cfg['QueryHistoryDB']
- */
- $cfg['QueryHistoryDB'] = false;
- /**
- * When using DB-based query history, how many entries should be kept?
- *
- * @global integer $cfg['QueryHistoryMax']
- */
- $cfg['QueryHistoryMax'] = 25;
- /**
- * Use MIME-Types (stored in column comments table) for
- *
- * @global boolean $cfg['BrowseMIME']
- */
- $cfg['BrowseMIME'] = true;
- /**
- * When approximate count < this, PMA will get exact count for table rows.
- *
- * @global integer $cfg['MaxExactCount']
- */
- $cfg['MaxExactCount'] = 50000;
- /**
- * Zero means that no row count is done for views; see the doc
- *
- * @global integer $cfg['MaxExactCountViews']
- */
- $cfg['MaxExactCountViews'] = 0;
- /**
- * Sort table and database in natural order
- *
- * @global boolean $cfg['NaturalOrder']
- */
- $cfg['NaturalOrder'] = true;
- /**
- * Initial state for sliders
- * (open | closed | disabled)
- *
- * @global string $cfg['InitialSlidersState']
- */
- $cfg['InitialSlidersState'] = 'closed';
- /**
- * User preferences: disallow these settings
- * For possible setting names look in libraries/config/user_preferences.forms.php
- *
- * @global array $cfg['UserprefsDisallow']
- */
- $cfg['UserprefsDisallow'] = [];
- /**
- * User preferences: enable the Developer tab
- */
- $cfg['UserprefsDeveloperTab'] = false;
- /*******************************************************************************
- * Window title settings
- */
- /**
- * title of browser window when a table is selected
- *
- * @global string $cfg['TitleTable']
- */
- $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
- /**
- * title of browser window when a database is selected
- *
- * @global string $cfg['TitleDatabase']
- */
- $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
- /**
- * title of browser window when a server is selected
- *
- * @global string $cfg['TitleServer']
- */
- $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
- /**
- * title of browser window when nothing is selected
- *
- * @global string $cfg['TitleDefault']
- */
- $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
- /*******************************************************************************
- * theme manager
- */
- /**
- * if you want to use selectable themes and if ThemesPath not empty
- * set it to true, else set it to false (default is false);
- *
- * @global boolean $cfg['ThemeManager']
- */
- $cfg['ThemeManager'] = true;
- /**
- * set up default theme, you can set up here an valid
- * path to themes or 'original' for the original pma-theme
- *
- * @global string $cfg['ThemeDefault']
- */
- $cfg['ThemeDefault'] = 'pmahomme';
- /**
- * allow different theme for each configured server
- *
- * @global boolean $cfg['ThemePerServer']
- */
- $cfg['ThemePerServer'] = false;
- /**
- * Default query for table
- *
- * @global string $cfg['DefaultQueryTable']
- */
- $cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';
- /**
- * Default query for database
- *
- * @global string $cfg['DefaultQueryDatabase']
- */
- $cfg['DefaultQueryDatabase'] = '';
- /*******************************************************************************
- * SQL Query box settings
- * These are the links display in all of the SQL Query boxes
- *
- * @global array $cfg['SQLQuery']
- */
- $cfg['SQLQuery'] = [];
- /**
- * Display an "Edit" link on the results page to change a query
- *
- * @global boolean $cfg['SQLQuery']['Edit']
- */
- $cfg['SQLQuery']['Edit'] = true;
- /**
- * Display an "Explain SQL" link on the results page
- *
- * @global boolean $cfg['SQLQuery']['Explain']
- */
- $cfg['SQLQuery']['Explain'] = true;
- /**
- * Display a "Create PHP code" link on the results page to wrap a query in PHP
- *
- * @global boolean $cfg['SQLQuery']['ShowAsPHP']
- */
- $cfg['SQLQuery']['ShowAsPHP'] = true;
- /**
- * Display a "Refresh" link on the results page
- *
- * @global boolean $cfg['SQLQuery']['Refresh']
- */
- $cfg['SQLQuery']['Refresh'] = true;
- /**
- * Enables autoComplete for table & column names in SQL queries
- *
- * default = 'true'
- */
- $cfg['EnableAutocompleteForTablesAndColumns'] = true;
- /*******************************************************************************
- * Web server upload/save/import directories
- */
- /**
- * Directory for uploaded files that can be executed by phpMyAdmin.
- * For example './upload'. Leave empty for no upload directory support.
- * Use %u for username inclusion.
- *
- * @global string $cfg['UploadDir']
- */
- $cfg['UploadDir'] = '';
- /**
- * Directory where phpMyAdmin can save exported data on server.
- * For example './save'. Leave empty for no save directory support.
- * Use %u for username inclusion.
- *
- * @global string $cfg['SaveDir']
- */
- $cfg['SaveDir'] = '';
- /**
- * Directory where phpMyAdmin can save temporary files.
- *
- * @global string $cfg['TempDir']
- */
- if (defined('TEMP_DIR')) {
- $cfg['TempDir'] = TEMP_DIR;
- } else {
- $cfg['TempDir'] = ROOT_PATH . 'tmp' . DIRECTORY_SEPARATOR;
- }
- /**
- * Misc. settings
- */
- /**
- * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
- * which is the only safe way to determine GD version.
- *
- * @global string $cfg['GD2Available']
- */
- $cfg['GD2Available'] = 'auto';
- /**
- * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
- *
- * @global array $cfg['TrustedProxies']
- */
- $cfg['TrustedProxies'] = [];
- /**
- * We normally check the permissions on the configuration file to ensure
- * it's not world writable. However, phpMyAdmin could be installed on
- * a NTFS filesystem mounted on a non-Windows server, in which case the
- * permissions seems wrong but in fact cannot be detected. In this case
- * a sysadmin would set the following to false.
- */
- $cfg['CheckConfigurationPermissions'] = true;
- /**
- * Limit for length of URL in links. When length would be above this limit, it
- * is replaced by form with button.
- * This is required as some web servers (IIS) have problems with long URLs.
- * The recommended limit is 2000
- * (see https://www.boutell.com/newfaq/misc/urllength.html) but we put
- * 1000 to accommodate Suhosin, see bug #3358750.
- */
- $cfg['LinkLengthLimit'] = 1000;
- /**
- * Additional string to allow in CSP headers.
- */
- $cfg['CSPAllow'] = '';
- /**
- * Disable the table maintenance mass operations, like optimizing or
- * repairing the selected tables of a database. An accidental execution
- * of such a maintenance task can enormously slow down a bigger database.
- */
- $cfg['DisableMultiTableMaintenance'] = false;
- /**
- * Whether or not to query the user before sending the error report to
- * the phpMyAdmin team when a JavaScript error occurs
- *
- * Available options
- * (ask | always | never)
- *
- * @global string $cfg['SendErrorReports']
- */
- $cfg['SendErrorReports'] = 'ask';
- /**
- * Whether Enter or Ctrl+Enter executes queries in the console.
- *
- * @global boolean $cfg['ConsoleEnterExecutes']
- */
- $cfg['ConsoleEnterExecutes'] = false;
- /**
- * Zero Configuration mode.
- *
- * @global boolean $cfg['ZeroConf']
- */
- $cfg['ZeroConf'] = true;
- /*******************************************************************************
- * Developers ONLY!
- *
- * @global array $cfg['DBG']
- */
- $cfg['DBG'] = [];
- /**
- * Output executed queries and their execution times
- *
- * @global boolean $cfg['DBG']['sql']
- */
- $cfg['DBG']['sql'] = false;
- /**
- * Log executed queries and their execution times to syslog
- *
- * @global boolean $cfg['DBG']['sqllog']
- */
- $cfg['DBG']['sqllog'] = false;
- /**
- * Enable to let server present itself as demo server.
- *
- * @global boolean $cfg['DBG']['demo']
- */
- $cfg['DBG']['demo'] = false;
- /**
- * Enable Simple two-factor authentication
- *
- * @global boolean $cfg['DBG']['simple2fa']
- */
- $cfg['DBG']['simple2fa'] = false;
- /**
- * Sets the working environment
- *
- * This only needs to be changed when you are developing phpMyAdmin itself.
- * The development mode may display debug information in some places.
- *
- * Possible values are 'production' or 'development'
- */
- $cfg['environment'] = 'production';
- /*******************************************************************************
- * MySQL settings
- */
- /**
- * Default functions for above defined groups
- *
- * @global array $cfg['DefaultFunctions']
- */
- $cfg['DefaultFunctions'] = [
- 'FUNC_CHAR' => '',
- 'FUNC_DATE' => '',
- 'FUNC_NUMBER' => '',
- 'FUNC_SPATIAL' => 'GeomFromText',
- 'FUNC_UUID' => 'UUID',
- 'first_timestamp' => 'NOW',
- ];
- /**
- * Max rows retrieved for zoom search
- */
- $cfg['maxRowPlotLimit'] = 500;
- /**
- * Show Git revision if applicable
- *
- * @global boolean $cfg['ShowGitRevision']
- */
- $cfg['ShowGitRevision'] = true;
- /**
- * MySQL minimal version required
- *
- * @global array $cfg['MysqlMinVersion']
- */
- $cfg['MysqlMinVersion'] = [
- 'internal' => 50500,
- 'human' => '5.5.0',
- ];
- /**
- * Disable shortcuts
- *
- * @global array $cfg['DisableShortcutKeys']
- */
- $cfg['DisableShortcutKeys'] = false;
- /**
- * Console configuration
- *
- * This is mostly meant for user preferences.
- */
- $cfg['Console'] = [
- 'StartHistory' => false,
- 'AlwaysExpand' => false,
- 'CurrentQuery' => true,
- 'EnterExecutes' => false,
- 'DarkTheme' => false,
- 'Mode' => 'info',
- 'Height' => 92,
- 'GroupQueries' => false,
- 'OrderBy' => 'exec',
- 'Order' => 'asc',
- ];
- /*******************************************************************************
- * Default options for transformations
- */
- /**
- * Initialize default transformations array
- *
- * @global array $cfg['DefaultTransformations']
- */
- $cfg['DefaultTransformations'] = [];
- /**
- * Default transformations for Substring
- *
- * @global array $cfg['DefaultTransformations']['Substring']
- */
- $cfg['DefaultTransformations']['Substring'] = [
- 0,
- 'all',
- '…',
- ];
- /**
- * Default transformations for Bool2Text
- *
- * @global array $cfg['DefaultTransformations']['Bool2Text']
- */
- $cfg['DefaultTransformations']['Bool2Text'] = [
- 'T',
- 'F',
- ];
- /**
- * Default transformations for External
- *
- * @global array $cfg['DefaultTransformations']['External']
- */
- $cfg['DefaultTransformations']['External'] = [
- 0,
- '-f /dev/null -i -wrap -q',
- 1,
- 1,
- ];
- /**
- * Default transformations for PreApPend
- *
- * @global array $cfg['DefaultTransformations']['PreApPend']
- */
- $cfg['DefaultTransformations']['PreApPend'] = [
- '',
- '',
- ];
- /**
- * Default transformations for Hex
- *
- * @global array $cfg['DefaultTransformations']['Hex']
- */
- $cfg['DefaultTransformations']['Hex'] = ['2'];
- /**
- * Default transformations for DateFormat
- *
- * @global array $cfg['DefaultTransformations']['DateFormat']
- */
- $cfg['DefaultTransformations']['DateFormat'] = [
- 0,
- '',
- 'local',
- ];
- /**
- * Set default for FirstDayOfCalendar
- *
- * @global integer $cfg['FirstDayOfCalendar']
- */
- $cfg['FirstDayOfCalendar'] = 0;
- /**
- * Default transformations for Inline
- *
- * @global array $cfg['DefaultTransformations']['Inline']
- */
- $cfg['DefaultTransformations']['Inline'] = [
- '100',
- 100,
- ];
- $cfg['DefaultTransformations']['Inline']['wrapper_link'] = null;
- $cfg['DefaultTransformations']['Inline']['wrapper_params'] = [];
- /**
- * Default transformations for TextImageLink
- *
- * @global array $cfg['DefaultTransformations']['TextImageLink']
- */
- $cfg['DefaultTransformations']['TextImageLink'] = [
- null,
- 100,
- 50,
- ];
- /**
- * Default transformations for TextLink
- *
- * @global array $cfg['DefaultTransformations']['TextLink']
- */
- $cfg['DefaultTransformations']['TextLink'] = [
- null,
- null,
- null,
- ];
|