config.default.php 70 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095
  1. <?php
  2. /**
  3. * <code>
  4. * N N OOO !! DDDD OOO N N OOO TTTTT EEEE DDDD I TTTTT !!
  5. * NN N O O !! D D O O NN N O O T E D D I T !!
  6. * N N N O O !! D D O O N N N O O T EEEE D D I T !!
  7. * N NN O O D D O O N NN O O T E D D I T
  8. * N N OOO !! DDDD OOO N N OOO T EEEE DDDD I T !!
  9. * </code>
  10. *
  11. * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
  12. *
  13. * phpMyAdmin default configuration, you can copy values from here to your
  14. * config.inc.php
  15. *
  16. * All directives are explained in the documentation
  17. */
  18. declare(strict_types=1);
  19. /**
  20. * Your phpMyAdmin URL.
  21. *
  22. * Complete the variable below with the full URL ie
  23. * https://example.com/path_to_your_phpMyAdmin_directory/
  24. *
  25. * It must contain characters that are valid for a URL, and the path is
  26. * case sensitive on some Web servers, for example Unix-based servers.
  27. *
  28. * In most cases you can leave this variable empty, as the correct value
  29. * will be detected automatically. However, we recommend that you do
  30. * test to see that the auto-detection code works in your system. A good
  31. * test is to browse a table, then edit a row and save it. There will be
  32. * an error message if phpMyAdmin cannot auto-detect the correct value.
  33. *
  34. * @global string $cfg['PmaAbsoluteUri']
  35. */
  36. $cfg['PmaAbsoluteUri'] = '';
  37. /**
  38. * Configure authentication logging destination
  39. *
  40. * @global string $cfg['AuthLog']
  41. */
  42. $cfg['AuthLog'] = 'auto';
  43. /**
  44. * Whether to log successful authentication attempts
  45. *
  46. * @global boolean $cfg['AuthLogSuccess']
  47. */
  48. $cfg['AuthLogSuccess'] = false;
  49. /**
  50. * Disable the default warning that is displayed on the DB Details Structure page if
  51. * any of the required Tables for the configuration storage could not be found
  52. *
  53. * @global boolean $cfg['PmaNoRelation_DisableWarning']
  54. */
  55. $cfg['PmaNoRelation_DisableWarning'] = false;
  56. /**
  57. * Disable the default warning that is displayed if Suhosin is detected
  58. *
  59. * @global boolean $cfg['SuhosinDisableWarning']
  60. */
  61. $cfg['SuhosinDisableWarning'] = false;
  62. /**
  63. * Disable the default warning that is displayed if session.gc_maxlifetime
  64. * is less than `LoginCookieValidity`
  65. *
  66. * @global boolean $cfg['LoginCookieValidityDisableWarning']
  67. */
  68. $cfg['LoginCookieValidityDisableWarning'] = false;
  69. /**
  70. * Disable the default warning about MySQL reserved words in column names
  71. *
  72. * @global boolean $cfg['ReservedWordDisableWarning']
  73. */
  74. $cfg['ReservedWordDisableWarning'] = false;
  75. /**
  76. * Show warning about incomplete translations on certain threshold.
  77. *
  78. * @global boolean $cfg['TranslationWarningThreshold']
  79. */
  80. $cfg['TranslationWarningThreshold'] = 80;
  81. /**
  82. * Allows phpMyAdmin to be included from a other document in a frame;
  83. * setting this to true is a potential security hole. Setting this to
  84. * 'sameorigin' prevents phpMyAdmin to be included from another document
  85. * in a frame, unless that document belongs to the same domain.
  86. *
  87. * @global boolean|string $cfg['AllowThirdPartyFraming']
  88. */
  89. $cfg['AllowThirdPartyFraming'] = false;
  90. /**
  91. * The 'cookie' auth_type uses AES algorithm to encrypt the password. If
  92. * at least one server configuration uses 'cookie' auth_type, enter here a
  93. * pass phrase that will be used by AES. The maximum length seems to be 46
  94. * characters.
  95. *
  96. * @global string $cfg['blowfish_secret']
  97. */
  98. $cfg['blowfish_secret'] = '';
  99. /*******************************************************************************
  100. * Server(s) configuration
  101. *
  102. * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
  103. * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
  104. * to ''. If you want more than one server, just copy following section
  105. * (including $i incrementation) several times. There is no need to define
  106. * full server array, just define values you need to change.
  107. *
  108. * @global array $cfg['Servers']
  109. */
  110. $cfg['Servers'] = [];
  111. $i = 1;
  112. /**
  113. * MySQL hostname or IP address
  114. *
  115. * @global string $cfg['Servers'][$i]['host']
  116. */
  117. $cfg['Servers'][$i]['host'] = 'localhost';
  118. /**
  119. * MySQL port - leave blank for default port
  120. *
  121. * @global string $cfg['Servers'][$i]['port']
  122. */
  123. $cfg['Servers'][$i]['port'] = '';
  124. /**
  125. * Path to the socket - leave blank for default socket
  126. *
  127. * @global string $cfg['Servers'][$i]['socket']
  128. */
  129. $cfg['Servers'][$i]['socket'] = '';
  130. /**
  131. * Use SSL for connecting to MySQL server?
  132. *
  133. * @global boolean $cfg['Servers'][$i]['ssl']
  134. */
  135. $cfg['Servers'][$i]['ssl'] = false;
  136. /**
  137. * Path to the key file when using SSL for connecting to the MySQL server
  138. *
  139. * @global string $cfg['Servers'][$i]['ssl_key']
  140. */
  141. $cfg['Servers'][$i]['ssl_key'] = null;
  142. /**
  143. * Path to the cert file when using SSL for connecting to the MySQL server
  144. *
  145. * @global string $cfg['Servers'][$i]['ssl_cert']
  146. */
  147. $cfg['Servers'][$i]['ssl_cert'] = null;
  148. /**
  149. * Path to the CA file when using SSL for connecting to the MySQL server
  150. *
  151. * @global string $cfg['Servers'][$i]['ssl_ca']
  152. */
  153. $cfg['Servers'][$i]['ssl_ca'] = null;
  154. /**
  155. * Directory containing trusted SSL CA certificates in PEM format
  156. *
  157. * @global string $cfg['Servers'][$i]['ssl_ca_path']
  158. */
  159. $cfg['Servers'][$i]['ssl_ca_path'] = null;
  160. /**
  161. * List of allowable ciphers for SSL connections to the MySQL server
  162. *
  163. * @global string $cfg['Servers'][$i]['ssl_ciphers']
  164. */
  165. $cfg['Servers'][$i]['ssl_ciphers'] = null;
  166. /**
  167. * MySQL 5.6 or later triggers the mysqlnd driver in PHP to validate the
  168. * peer_name of the SSL certifcate
  169. * For most self-signed certificates this is a problem. Setting this to false
  170. * will disable the check and allow the connection (PHP 5.6.16 or later)
  171. *
  172. * @link https://bugs.php.net/68344
  173. *
  174. * @global string $cfg['Servers'][$i]['ssl_verify']
  175. */
  176. $cfg['Servers'][$i]['ssl_verify'] = true;
  177. /**
  178. * Use compressed protocol for the MySQL connection
  179. *
  180. * @global boolean $cfg['Servers'][$i]['compress']
  181. */
  182. $cfg['Servers'][$i]['compress'] = false;
  183. /**
  184. * MySQL control host. This permits to use a host different than the
  185. * main host, for the phpMyAdmin configuration storage. If left empty,
  186. * $cfg['Servers'][$i]['host'] is used instead.
  187. *
  188. * @global string $cfg['Servers'][$i]['controlhost']
  189. */
  190. $cfg['Servers'][$i]['controlhost'] = '';
  191. /**
  192. * MySQL control port. This permits to use a port different than the
  193. * main port, for the phpMyAdmin configuration storage. If left empty,
  194. * $cfg['Servers'][$i]['port'] is used instead.
  195. *
  196. * @global string $cfg['Servers'][$i]['controlport']
  197. */
  198. $cfg['Servers'][$i]['controlport'] = '';
  199. /**
  200. * MySQL control user settings (this user must have read-only
  201. * access to the "mysql/user" and "mysql/db" tables). The controluser is also
  202. * used for all relational features (pmadb)
  203. *
  204. * @global string $cfg['Servers'][$i]['controluser']
  205. */
  206. $cfg['Servers'][$i]['controluser'] = '';
  207. /**
  208. * MySQL control user settings (this user must have read-only
  209. * access to the "mysql/user" and "mysql/db" tables). The controluser is also
  210. * used for all relational features (pmadb)
  211. *
  212. * @global string $cfg['Servers'][$i]['controlpass']
  213. */
  214. $cfg['Servers'][$i]['controlpass'] = '';
  215. /**
  216. * Authentication method (valid choices: config, http, signon or cookie)
  217. *
  218. * @global string $cfg['Servers'][$i]['auth_type']
  219. */
  220. $cfg['Servers'][$i]['auth_type'] = 'cookie';
  221. /**
  222. * HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)
  223. *
  224. * @global string $cfg['Servers'][$i]['auth_http_realm']
  225. */
  226. $cfg['Servers'][$i]['auth_http_realm'] = '';
  227. /**
  228. * MySQL user
  229. *
  230. * @global string $cfg['Servers'][$i]['user']
  231. */
  232. $cfg['Servers'][$i]['user'] = 'root';
  233. /**
  234. * MySQL password (only needed with 'config' auth_type)
  235. *
  236. * @global string $cfg['Servers'][$i]['password']
  237. */
  238. $cfg['Servers'][$i]['password'] = '';
  239. /**
  240. * Session to use for 'signon' authentication method
  241. *
  242. * @global string $cfg['Servers'][$i]['SignonSession']
  243. */
  244. $cfg['Servers'][$i]['SignonSession'] = '';
  245. /**
  246. * Cookie params to match session to use for 'signon' authentication method
  247. * It should be an associative array matching result of session_get_cookie_params() in other system
  248. *
  249. * @global array $cfg['Servers'][$i]['SignonCookieParams']
  250. */
  251. $cfg['Servers'][$i]['SignonCookieParams'] = [];
  252. /**
  253. * PHP script to use for 'signon' authentication method
  254. *
  255. * @global string $cfg['Servers'][$i]['SignonScript']
  256. */
  257. $cfg['Servers'][$i]['SignonScript'] = '';
  258. /**
  259. * URL where to redirect user to login for 'signon' authentication method
  260. *
  261. * @global string $cfg['Servers'][$i]['SignonURL']
  262. */
  263. $cfg['Servers'][$i]['SignonURL'] = '';
  264. /**
  265. * URL where to redirect user after logout
  266. *
  267. * @global string $cfg['Servers'][$i]['LogoutURL']
  268. */
  269. $cfg['Servers'][$i]['LogoutURL'] = '';
  270. /**
  271. * If set to a db-name, only this db is displayed in navigation panel
  272. * It may also be an array of db-names
  273. *
  274. * @global string $cfg['Servers'][$i]['only_db']
  275. */
  276. $cfg['Servers'][$i]['only_db'] = '';
  277. /**
  278. * Database name to be hidden from listings
  279. *
  280. * @global string $cfg['Servers'][$i]['hide_db']
  281. */
  282. $cfg['Servers'][$i]['hide_db'] = '';
  283. /**
  284. * Verbose name for this host - leave blank to show the hostname
  285. * (for HTTP authentication, all non-US-ASCII characters will be stripped)
  286. *
  287. * @global string $cfg['Servers'][$i]['verbose']
  288. */
  289. $cfg['Servers'][$i]['verbose'] = '';
  290. /**
  291. * Database used for Relation, Bookmark and PDF Features
  292. * (see sql/create_tables.sql)
  293. * - leave blank for no support
  294. * SUGGESTED: 'phpmyadmin'
  295. *
  296. * @global string $cfg['Servers'][$i]['pmadb']
  297. */
  298. $cfg['Servers'][$i]['pmadb'] = '';
  299. /**
  300. * Bookmark table
  301. * - leave blank for no bookmark support
  302. * SUGGESTED: 'pma__bookmark'
  303. *
  304. * @global string $cfg['Servers'][$i]['bookmarktable']
  305. */
  306. $cfg['Servers'][$i]['bookmarktable'] = '';
  307. /**
  308. * table to describe the relation between links (see doc)
  309. * - leave blank for no relation-links support
  310. * SUGGESTED: 'pma__relation'
  311. *
  312. * @global string $cfg['Servers'][$i]['relation']
  313. */
  314. $cfg['Servers'][$i]['relation'] = '';
  315. /**
  316. * table to describe the display fields
  317. * - leave blank for no display fields support
  318. * SUGGESTED: 'pma__table_info'
  319. *
  320. * @global string $cfg['Servers'][$i]['table_info']
  321. */
  322. $cfg['Servers'][$i]['table_info'] = '';
  323. /**
  324. * table to describe the tables position for the designer and PDF schema
  325. * - leave blank for no PDF schema support
  326. * SUGGESTED: 'pma__table_coords'
  327. *
  328. * @global string $cfg['Servers'][$i]['table_coords']
  329. */
  330. $cfg['Servers'][$i]['table_coords'] = '';
  331. /**
  332. * table to describe pages of relationpdf
  333. * - leave blank if you don't want to use this
  334. * SUGGESTED: 'pma__pdf_pages'
  335. *
  336. * @global string $cfg['Servers'][$i]['pdf_pages']
  337. */
  338. $cfg['Servers'][$i]['pdf_pages'] = '';
  339. /**
  340. * table to store column information
  341. * - leave blank for no column comments/mime types
  342. * SUGGESTED: 'pma__column_info'
  343. *
  344. * @global string $cfg['Servers'][$i]['column_info']
  345. */
  346. $cfg['Servers'][$i]['column_info'] = '';
  347. /**
  348. * table to store SQL history
  349. * - leave blank for no SQL query history
  350. * SUGGESTED: 'pma__history'
  351. *
  352. * @global string $cfg['Servers'][$i]['history']
  353. */
  354. $cfg['Servers'][$i]['history'] = '';
  355. /**
  356. * table to store recently used tables
  357. * - leave blank for no "persistent" recently used tables
  358. * SUGGESTED: 'pma__recent'
  359. */
  360. $cfg['Servers'][$i]['recent'] = '';
  361. /**
  362. * table to store favorite tables
  363. * - leave blank for no favorite tables
  364. * SUGGESTED: 'pma__favorite'
  365. */
  366. $cfg['Servers'][$i]['favorite'] = '';
  367. /**
  368. * table to store UI preferences for tables
  369. * - leave blank for no "persistent" UI preferences
  370. * SUGGESTED: 'pma__table_uiprefs'
  371. */
  372. $cfg['Servers'][$i]['table_uiprefs'] = '';
  373. /**
  374. * table to store SQL tracking
  375. * - leave blank for no SQL tracking
  376. * SUGGESTED: 'pma__tracking'
  377. *
  378. * @global string $cfg['Servers'][$i]['tracking']
  379. */
  380. $cfg['Servers'][$i]['tracking'] = '';
  381. /**
  382. * table to store user preferences
  383. * - leave blank to disable server storage
  384. * SUGGESTED: 'pma__userconfig'
  385. *
  386. * @global string $cfg['Servers'][$i]['userconfig']
  387. */
  388. $cfg['Servers'][$i]['userconfig'] = '';
  389. /**
  390. * table to store users and their assignment to user groups
  391. * - leave blank to disable configurable menus feature
  392. * SUGGESTED: 'pma__users'
  393. *
  394. * @global string $cfg['Servers'][$i]['users']
  395. */
  396. $cfg['Servers'][$i]['users'] = '';
  397. /**
  398. * table to store allowed menu items for each user group
  399. * - leave blank to disable configurable menus feature
  400. * SUGGESTED: 'pma__usergroups'
  401. *
  402. * @global string $cfg['Servers'][$i]['usergroups']
  403. */
  404. $cfg['Servers'][$i]['usergroups'] = '';
  405. /**
  406. * table to store information about item hidden from navigation tree
  407. * - leave blank to disable hide/show navigation items feature
  408. * SUGGESTED: 'pma__navigationhiding'
  409. *
  410. * @global string $cfg['Servers'][$i]['navigationhiding']
  411. */
  412. $cfg['Servers'][$i]['navigationhiding'] = '';
  413. /**
  414. * table to store information about saved searches from query-by-example on a db
  415. * - leave blank to disable saved searches feature
  416. * SUGGESTED: 'pma__savedsearches'
  417. *
  418. * @global string $cfg['Servers'][$i]['savedsearches']
  419. */
  420. $cfg['Servers'][$i]['savedsearches'] = '';
  421. /**
  422. * table to store central list of columns per database
  423. * - leave blank to disable central list of columns feature
  424. * SUGGESTED: 'pma__central_columns'
  425. *
  426. * @global string $cfg['Servers'][$i]['central_columns']
  427. */
  428. $cfg['Servers'][$i]['central_columns'] = '';
  429. /**
  430. * table to store designer settings
  431. * - leave blank to disable the storage of designer settings
  432. * SUGGESTED: 'pma__designer_settings'
  433. *
  434. * @global string $cfg['Servers'][$i]['designer_settings']
  435. */
  436. $cfg['Servers'][$i]['designer_settings'] = '';
  437. /**
  438. * table to store export templates
  439. * - leave blank to disable saved searches feature
  440. * SUGGESTED: 'pma__export_templates'
  441. *
  442. * @global string $cfg['Servers'][$i]['export_templates']
  443. */
  444. $cfg['Servers'][$i]['export_templates'] = '';
  445. /**
  446. * Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.
  447. *
  448. * In case where tables in databases is modified (e.g. dropped or renamed),
  449. * table_uiprefs may contains invalid data (referring to tables which are not
  450. * exist anymore).
  451. * This configuration make sure that we only keep N (N = MaxTableUiprefs)
  452. * newest record in table_uiprefs and automatically delete older records.
  453. *
  454. * @global integer $cfg['Servers'][$i]['userconfig'] = '';
  455. */
  456. $cfg['Servers'][$i]['MaxTableUiprefs'] = 100;
  457. /**
  458. * Sets the time zone used by phpMyAdmin. Possible values are explained at
  459. * https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
  460. *
  461. * @global string $cfg['Servers'][$i]['SessionTimeZone'] = ''
  462. */
  463. $cfg['Servers'][$i]['SessionTimeZone'] = '';
  464. /**
  465. * whether to allow root login
  466. *
  467. * @global boolean $cfg['Servers'][$i]['AllowRoot']
  468. */
  469. $cfg['Servers'][$i]['AllowRoot'] = true;
  470. /**
  471. * whether to allow login of any user without a password
  472. *
  473. * @global boolean $cfg['Servers'][$i]['AllowNoPassword']
  474. */
  475. $cfg['Servers'][$i]['AllowNoPassword'] = false;
  476. /**
  477. * Host authentication order, leave blank to not use
  478. *
  479. * @global string $cfg['Servers'][$i]['AllowDeny']['order']
  480. */
  481. $cfg['Servers'][$i]['AllowDeny']['order'] = '';
  482. /**
  483. * Host authentication rules, leave blank for defaults
  484. *
  485. * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
  486. */
  487. $cfg['Servers'][$i]['AllowDeny']['rules'] = [];
  488. /**
  489. * Disable use of INFORMATION_SCHEMA.
  490. *
  491. * @see https://github.com/phpmyadmin/phpmyadmin/issues/8970
  492. * @see https://bugs.mysql.com/19588
  493. *
  494. * @global boolean $cfg['Servers'][$i]['DisableIS']
  495. */
  496. $cfg['Servers'][$i]['DisableIS'] = false;
  497. /**
  498. * Whether the tracking mechanism creates
  499. * versions for tables and views automatically.
  500. *
  501. * @global bool $cfg['Servers'][$i]['tracking_version_auto_create']
  502. */
  503. $cfg['Servers'][$i]['tracking_version_auto_create'] = false;
  504. /**
  505. * Defines the list of statements
  506. * the auto-creation uses for new versions.
  507. *
  508. * @global string $cfg['Servers'][$i]['tracking_default_statements']
  509. */
  510. $cfg['Servers'][$i]['tracking_default_statements']
  511. = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,' .
  512. 'DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,' .
  513. 'ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
  514. /**
  515. * Whether a DROP VIEW IF EXISTS statement will be added
  516. * as first line to the log when creating a view.
  517. *
  518. * @global bool $cfg['Servers'][$i]['tracking_add_drop_view']
  519. */
  520. $cfg['Servers'][$i]['tracking_add_drop_view'] = true;
  521. /**
  522. * Whether a DROP TABLE IF EXISTS statement will be added
  523. * as first line to the log when creating a table.
  524. *
  525. * @global bool $cfg['Servers'][$i]['tracking_add_drop_table']
  526. */
  527. $cfg['Servers'][$i]['tracking_add_drop_table'] = true;
  528. /**
  529. * Whether a DROP DATABASE IF EXISTS statement will be added
  530. * as first line to the log when creating a database.
  531. *
  532. * @global bool $cfg['Servers'][$i]['tracking_add_drop_database']
  533. */
  534. $cfg['Servers'][$i]['tracking_add_drop_database'] = true;
  535. /**
  536. * Default server (0 = no default server)
  537. *
  538. * If you have more than one server configured, you can set $cfg['ServerDefault']
  539. * to any one of them to auto-connect to that server when phpMyAdmin is started,
  540. * or set it to 0 to be given a list of servers without logging in
  541. * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
  542. * set to that server.
  543. *
  544. * @global integer $cfg['ServerDefault']
  545. */
  546. $cfg['ServerDefault'] = 1;
  547. /*
  548. * Other core phpMyAdmin settings
  549. */
  550. /**
  551. * whether version check is active
  552. *
  553. * @global boolean $cfg['VersionCheck']
  554. */
  555. if (defined('VERSION_CHECK_DEFAULT')) {
  556. $cfg['VersionCheck'] = VERSION_CHECK_DEFAULT;
  557. } else {
  558. $cfg['VersionCheck'] = true;
  559. }
  560. /**
  561. * The url of the proxy to be used when retrieving the information about
  562. * the latest version of phpMyAdmin or error reporting. You need this if
  563. * the server where phpMyAdmin is installed does not have direct access to
  564. * the internet.
  565. * The format is: "hostname:portnumber"
  566. *
  567. * @global string $cfg['ProxyUrl']
  568. */
  569. $cfg['ProxyUrl'] = '';
  570. /**
  571. * The username for authenticating with the proxy. By default, no
  572. * authentication is performed. If a username is supplied, Basic
  573. * Authentication will be performed. No other types of authentication
  574. * are currently supported.
  575. *
  576. * @global string $cfg['ProxyUser']
  577. */
  578. $cfg['ProxyUser'] = '';
  579. /**
  580. * The password for authenticating with the proxy.
  581. *
  582. * @global string $cfg['ProxyPass']
  583. */
  584. $cfg['ProxyPass'] = '';
  585. /**
  586. * maximum number of db's displayed in database list
  587. *
  588. * @global integer $cfg['MaxDbList']
  589. */
  590. $cfg['MaxDbList'] = 100;
  591. /**
  592. * maximum number of tables displayed in table list
  593. *
  594. * @global integer $cfg['MaxTableList']
  595. */
  596. $cfg['MaxTableList'] = 250;
  597. /**
  598. * whether to show hint or not
  599. *
  600. * @global boolean $cfg['ShowHint']
  601. */
  602. $cfg['ShowHint'] = true;
  603. /**
  604. * maximum number of characters when a SQL query is displayed
  605. *
  606. * @global integer $cfg['MaxCharactersInDisplayedSQL']
  607. */
  608. $cfg['MaxCharactersInDisplayedSQL'] = 1000;
  609. /**
  610. * use GZIP output buffering if possible (true|false|'auto')
  611. *
  612. * @global string $cfg['OBGzip']
  613. */
  614. $cfg['OBGzip'] = 'auto';
  615. /**
  616. * use persistent connections to MySQL database
  617. *
  618. * @global boolean $cfg['PersistentConnections']
  619. */
  620. $cfg['PersistentConnections'] = false;
  621. /**
  622. * maximum execution time in seconds (0 for no limit)
  623. *
  624. * @global integer $cfg['ExecTimeLimit']
  625. */
  626. $cfg['ExecTimeLimit'] = 300;
  627. /**
  628. * Path for storing session data (session_save_path PHP parameter).
  629. *
  630. * @global integer $cfg['SessionSavePath']
  631. */
  632. $cfg['SessionSavePath'] = '';
  633. /**
  634. * Hosts or IPs to consider safe when checking if SSL is used or not
  635. *
  636. * @global array $cfg['MysqlSslWarningSafeHosts']
  637. */
  638. $cfg['MysqlSslWarningSafeHosts'] = ['127.0.0.1', 'localhost'];
  639. /**
  640. * maximum allocated bytes ('-1' for no limit, '0' for no change)
  641. * this is a string because '16M' is a valid value; we must put here
  642. * a string as the default value so that /setup accepts strings
  643. *
  644. * @global string $cfg['MemoryLimit']
  645. */
  646. $cfg['MemoryLimit'] = '-1';
  647. /**
  648. * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
  649. *
  650. * @global boolean $cfg['SkipLockedTables']
  651. */
  652. $cfg['SkipLockedTables'] = false;
  653. /**
  654. * show SQL queries as run
  655. *
  656. * @global boolean $cfg['ShowSQL']
  657. */
  658. $cfg['ShowSQL'] = true;
  659. /**
  660. * retain SQL input on Ajax execute
  661. *
  662. * @global boolean $cfg['RetainQueryEditor']
  663. */
  664. $cfg['RetainQueryBox'] = false;
  665. /**
  666. * use CodeMirror syntax highlighting for editing SQL
  667. *
  668. * @global boolean $cfg['CodemirrorEnable']
  669. */
  670. $cfg['CodemirrorEnable'] = true;
  671. /**
  672. * use the parser to find any errors in the query before executing
  673. *
  674. * @global boolean $cfg['LintEnable']
  675. */
  676. $cfg['LintEnable'] = true;
  677. /**
  678. * show a 'Drop database' link to normal users
  679. *
  680. * @global boolean $cfg['AllowUserDropDatabase']
  681. */
  682. $cfg['AllowUserDropDatabase'] = false;
  683. /**
  684. * confirm some commands that can result in loss of data
  685. *
  686. * @global boolean $cfg['Confirm']
  687. */
  688. $cfg['Confirm'] = true;
  689. /**
  690. * sets SameSite attribute of the Set-Cookie HTTP response header
  691. *
  692. * @global boolean $cfg['CookieSameSite']
  693. */
  694. $cfg['CookieSameSite'] = 'Strict';
  695. /**
  696. * recall previous login in cookie authentication mode or not
  697. *
  698. * @global boolean $cfg['LoginCookieRecall']
  699. */
  700. $cfg['LoginCookieRecall'] = true;
  701. /**
  702. * validity of cookie login (in seconds; 1440 matches php.ini's
  703. * session.gc_maxlifetime)
  704. *
  705. * @global integer $cfg['LoginCookieValidity']
  706. */
  707. $cfg['LoginCookieValidity'] = 1440;
  708. /**
  709. * how long login cookie should be stored (in seconds)
  710. *
  711. * @global integer $cfg['LoginCookieStore']
  712. */
  713. $cfg['LoginCookieStore'] = 0;
  714. /**
  715. * whether to delete all login cookies on logout
  716. *
  717. * @global boolean $cfg['LoginCookieDeleteAll']
  718. */
  719. $cfg['LoginCookieDeleteAll'] = true;
  720. /**
  721. * whether to enable the "database search" feature or not
  722. *
  723. * @global boolean $cfg['UseDbSearch']
  724. */
  725. $cfg['UseDbSearch'] = true;
  726. /**
  727. * if set to true, PMA continues computing multiple-statement queries
  728. * even if one of the queries failed
  729. *
  730. * @global boolean $cfg['IgnoreMultiSubmitErrors']
  731. */
  732. $cfg['IgnoreMultiSubmitErrors'] = false;
  733. /**
  734. * allow login to any user entered server in cookie based authentication
  735. *
  736. * @global boolean $cfg['AllowArbitraryServer']
  737. */
  738. $cfg['AllowArbitraryServer'] = false;
  739. /**
  740. * restrict by IP (with regular expression) the MySQL servers the user can enter
  741. * when $cfg['AllowArbitraryServer'] = true
  742. *
  743. * @global string $cfg['ArbitraryServerRegexp']
  744. */
  745. $cfg['ArbitraryServerRegexp'] = '';
  746. /**
  747. * To enable reCaptcha v2 checkbox mode if necessary
  748. *
  749. * @global string $cfg['CaptchaMethod']
  750. */
  751. $cfg['CaptchaMethod'] = 'invisible';
  752. /**
  753. * URL for the reCaptcha v2 compatible API to use
  754. *
  755. * @global string $cfg['CaptchaApi']
  756. */
  757. $cfg['CaptchaApi'] = 'https://www.google.com/recaptcha/api.js';
  758. /**
  759. * Content-Security-Policy snippet for the reCaptcha v2 compatible API
  760. *
  761. * @global string $cfg['CaptchaCsp']
  762. */
  763. $cfg['CaptchaCsp'] = 'https://apis.google.com https://www.google.com/recaptcha/'
  764. . ' https://www.gstatic.com/recaptcha/ https://ssl.gstatic.com/';
  765. /**
  766. * reCaptcha API's request parameter name
  767. *
  768. * @global string $cfg['CaptchaRequestParam']
  769. */
  770. $cfg['CaptchaRequestParam'] = 'g-recaptcha';
  771. /**
  772. * reCaptcha API's response parameter name
  773. *
  774. * @global string $cfg['CaptchaResponseParam']
  775. */
  776. $cfg['CaptchaResponseParam'] = 'g-recaptcha-response';
  777. /**
  778. * if reCaptcha is enabled it needs public key to connect with the service
  779. *
  780. * @global string $cfg['CaptchaLoginPublicKey']
  781. */
  782. $cfg['CaptchaLoginPublicKey'] = '';
  783. /**
  784. * if reCaptcha is enabled it needs private key to connect with the service
  785. *
  786. * @global string $cfg['CaptchaLoginPrivateKey']
  787. */
  788. $cfg['CaptchaLoginPrivateKey'] = '';
  789. /**
  790. * if reCaptcha is enabled may need an URL for site verify
  791. *
  792. * @global string $cfg['CaptchaSiteVerifyURL']
  793. */
  794. $cfg['CaptchaSiteVerifyURL'] = '';
  795. /**
  796. * Enable drag and drop import
  797. *
  798. * @see feature request : https://github.com/phpmyadmin/phpmyadmin/issues/13155
  799. *
  800. * @global bool $cfg['enable_drag_drop_import']
  801. */
  802. $cfg['enable_drag_drop_import'] = true;
  803. /*******************************************************************************
  804. * Navigation panel setup
  805. */
  806. /**
  807. * In the navigation panel, replaces the database tree with a selector
  808. *
  809. * @global boolean $cfg['ShowDatabasesNavigationAsTree']
  810. */
  811. $cfg['ShowDatabasesNavigationAsTree'] = true;
  812. /**
  813. * maximum number of first level databases displayed in navigation panel
  814. *
  815. * @global integer $cfg['FirstLevelNavigationItems']
  816. */
  817. $cfg['FirstLevelNavigationItems'] = 100;
  818. /**
  819. * maximum number of items displayed in navigation panel
  820. *
  821. * @global integer $cfg['MaxNavigationItems']
  822. */
  823. $cfg['MaxNavigationItems'] = 50;
  824. /**
  825. * turn the select-based light menu into a tree
  826. *
  827. * @global boolean $cfg['NavigationTreeEnableGrouping']
  828. */
  829. $cfg['NavigationTreeEnableGrouping'] = true;
  830. /**
  831. * the separator to sub-tree the select-based light menu tree
  832. *
  833. * @global string $cfg['NavigationTreeDbSeparator']
  834. */
  835. $cfg['NavigationTreeDbSeparator'] = '_';
  836. /**
  837. * Which string will be used to generate table prefixes
  838. * to split/nest tables into multiple categories
  839. *
  840. * @global string $cfg['NavigationTreeTableSeparator']
  841. */
  842. $cfg['NavigationTreeTableSeparator'] = '__';
  843. /**
  844. * How many sublevels should be displayed when splitting up tables
  845. * by the above Separator
  846. *
  847. * @global integer $cfg['NavigationTreeTableLevel']
  848. */
  849. $cfg['NavigationTreeTableLevel'] = 1;
  850. /**
  851. * link with main panel by highlighting the current db/table
  852. *
  853. * @global boolean $cfg['NavigationLinkWithMainPanel']
  854. */
  855. $cfg['NavigationLinkWithMainPanel'] = true;
  856. /**
  857. * display logo at top of navigation panel
  858. *
  859. * @global boolean $cfg['NavigationDisplayLogo']
  860. */
  861. $cfg['NavigationDisplayLogo'] = true;
  862. /**
  863. * where should logo link point to (can also contain an external URL)
  864. *
  865. * @global string $cfg['NavigationLogoLink']
  866. */
  867. $cfg['NavigationLogoLink'] = 'index.php';
  868. /**
  869. * whether to open the linked page in the main window ('main') or
  870. * in a new window ('new')
  871. *
  872. * @global string $cfg['NavigationLogoLinkWindow']
  873. */
  874. $cfg['NavigationLogoLinkWindow'] = 'main';
  875. /**
  876. * number of recently used tables displayed in the navigation panel
  877. *
  878. * @global integer $cfg['NumRecentTables']
  879. */
  880. $cfg['NumRecentTables'] = 10;
  881. /**
  882. * number of favorite tables displayed in the navigation panel
  883. *
  884. * @global integer $cfg['NumFavoriteTables']
  885. */
  886. $cfg['NumFavoriteTables'] = 10;
  887. /**
  888. * display a JavaScript table filter in the navigation panel
  889. * when more then x tables are present
  890. *
  891. * @global boolean $cfg['NavigationTreeDisplayItemFilterMinimum']
  892. */
  893. $cfg['NavigationTreeDisplayItemFilterMinimum'] = 30;
  894. /**
  895. * display server choice at top of navigation panel
  896. *
  897. * @global boolean $cfg['NavigationDisplayServers']
  898. */
  899. $cfg['NavigationDisplayServers'] = true;
  900. /**
  901. * server choice as links
  902. *
  903. * @global boolean $cfg['DisplayServersList']
  904. */
  905. $cfg['DisplayServersList'] = false;
  906. /**
  907. * display a JavaScript database filter in the navigation panel
  908. * when more then x databases are present
  909. *
  910. * @global boolean $cfg['NavigationTreeDisplayDbFilterMinimum']
  911. */
  912. $cfg['NavigationTreeDisplayDbFilterMinimum'] = 30;
  913. /**
  914. * target of the navigation panel quick access icon
  915. *
  916. * Possible values:
  917. * 'structure' = fields list
  918. * 'sql' = SQL form
  919. * 'search' = search page
  920. * 'insert' = insert row page
  921. * 'browse' = browse page
  922. *
  923. * @global string $cfg['NavigationTreeDefaultTabTable']
  924. */
  925. $cfg['NavigationTreeDefaultTabTable'] = 'structure';
  926. /**
  927. * target of the navigation panel quick second access icon
  928. *
  929. * Possible values:
  930. * 'structure' = fields list
  931. * 'sql' = SQL form
  932. * 'search' = search page
  933. * 'insert' = insert row page
  934. * 'browse' = browse page
  935. * '' = no link
  936. *
  937. * @global string $cfg['NavigationTreeDefaultTabTable2']
  938. */
  939. $cfg['NavigationTreeDefaultTabTable2'] = '';
  940. /**
  941. * Enables the possibility of navigation tree expansion
  942. *
  943. * @global boolean $cfg['NavigationTreeEnableExpansion']
  944. */
  945. $cfg['NavigationTreeEnableExpansion'] = true;
  946. /**
  947. * Show tables in navigation panel
  948. *
  949. * @global boolean $cfg['NavigationTreeShowTables']
  950. */
  951. $cfg['NavigationTreeShowTables'] = true;
  952. /**
  953. * Show views in navigation panel
  954. *
  955. * @global boolean $cfg['NavigationTreeShowViews']
  956. */
  957. $cfg['NavigationTreeShowViews'] = true;
  958. /**
  959. * Show functions in navigation panel
  960. *
  961. * @global boolean $cfg['NavigationTreeShowFunctions']
  962. */
  963. $cfg['NavigationTreeShowFunctions'] = true;
  964. /**
  965. * Show procedures in navigation panel
  966. *
  967. * @global boolean $cfg['NavigationTreeShowProcedures']
  968. */
  969. $cfg['NavigationTreeShowProcedures'] = true;
  970. /**
  971. * Show events in navigation panel
  972. *
  973. * @global boolean $cfg['NavigationTreeShowEvents']
  974. */
  975. $cfg['NavigationTreeShowEvents'] = true;
  976. /**
  977. * Width of navigation panel
  978. *
  979. * @global integer $cfg['NavigationWidth']
  980. */
  981. $cfg['NavigationWidth'] = 240;
  982. /**
  983. * Automatically expands single database in navigation panel
  984. *
  985. * @global boolean $cfg['NavigationAutoexpandSingleDb']
  986. */
  987. $cfg['NavigationTreeAutoexpandSingleDb'] = true;
  988. /*******************************************************************************
  989. * In the main panel, at startup...
  990. */
  991. /**
  992. * allow to display statistics and space usage in the pages about database
  993. * details and table properties
  994. *
  995. * @global boolean $cfg['ShowStats']
  996. */
  997. $cfg['ShowStats'] = true;
  998. /**
  999. * show PHP info link
  1000. *
  1001. * @global boolean $cfg['ShowPhpInfo']
  1002. */
  1003. $cfg['ShowPhpInfo'] = false;
  1004. /**
  1005. * show MySQL server and web server information
  1006. *
  1007. * @global boolean $cfg['ShowServerInfo']
  1008. */
  1009. $cfg['ShowServerInfo'] = true;
  1010. /**
  1011. * show change password link
  1012. *
  1013. * @global boolean $cfg['ShowChgPassword']
  1014. */
  1015. $cfg['ShowChgPassword'] = true;
  1016. /**
  1017. * show create database form
  1018. *
  1019. * @global boolean $cfg['ShowCreateDb']
  1020. */
  1021. $cfg['ShowCreateDb'] = true;
  1022. /*******************************************************************************
  1023. * Database structure
  1024. */
  1025. /** show charset column in database structure (true|false)?
  1026. *
  1027. * @global boolean $cfg['ShowDbStructureCharset']
  1028. */
  1029. $cfg['ShowDbStructureCharset'] = false;
  1030. /**
  1031. * show comment column in database structure (true|false)?
  1032. *
  1033. * @global boolean $cfg['ShowDbStructureComment']
  1034. */
  1035. $cfg['ShowDbStructureComment'] = false;
  1036. /**
  1037. * show creation timestamp column in database structure (true|false)?
  1038. *
  1039. * @global boolean $cfg['ShowDbStructureCreation']
  1040. */
  1041. $cfg['ShowDbStructureCreation'] = false;
  1042. /**
  1043. * show last update timestamp column in database structure (true|false)?
  1044. *
  1045. * @global boolean $cfg['ShowDbStructureLastUpdate']
  1046. */
  1047. $cfg['ShowDbStructureLastUpdate'] = false;
  1048. /**
  1049. * show last check timestamp column in database structure (true|false)?
  1050. *
  1051. * @global boolean $cfg['ShowDbStructureLastCheck']
  1052. */
  1053. $cfg['ShowDbStructureLastCheck'] = false;
  1054. /**
  1055. * allow hide action columns to drop down menu in database structure (true|false)?
  1056. *
  1057. * @global boolean $cfg['HideStructureActions']
  1058. */
  1059. $cfg['HideStructureActions'] = true;
  1060. /**
  1061. * Show column comments in table structure view (true|false)?
  1062. *
  1063. * @global boolean $cfg['ShowColumnComments']
  1064. */
  1065. $cfg['ShowColumnComments'] = true;
  1066. /*******************************************************************************
  1067. * In browse mode...
  1068. */
  1069. /**
  1070. * Use icons instead of text for the navigation bar buttons (table browse)
  1071. * ('text'|'icons'|'both')
  1072. *
  1073. * @global string $cfg['TableNavigationLinksMode']
  1074. */
  1075. $cfg['TableNavigationLinksMode'] = 'icons';
  1076. /**
  1077. * Defines whether a user should be displayed a "show all (records)"
  1078. * button in browse mode or not.
  1079. *
  1080. * @global boolean $cfg['ShowAll']
  1081. */
  1082. $cfg['ShowAll'] = false;
  1083. /**
  1084. * Number of rows displayed when browsing a result set. If the result
  1085. * set contains more rows, "Previous" and "Next".
  1086. * Possible values: 25,50,100,250,500
  1087. *
  1088. * @global integer $cfg['MaxRows']
  1089. */
  1090. $cfg['MaxRows'] = 25;
  1091. /**
  1092. * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
  1093. * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
  1094. * ascending order else-)
  1095. *
  1096. * @global string $cfg['Order']
  1097. */
  1098. $cfg['Order'] = 'SMART';
  1099. /**
  1100. * grid editing: save edited cell(s) in browse-mode at once
  1101. *
  1102. * @global boolean $cfg['SaveCellsAtOnce']
  1103. */
  1104. $cfg['SaveCellsAtOnce'] = false;
  1105. /**
  1106. * grid editing: which action triggers it, or completely disable the feature
  1107. *
  1108. * Possible values:
  1109. * 'click'
  1110. * 'double-click'
  1111. * 'disabled'
  1112. *
  1113. * @global string $cfg['GridEditing']
  1114. */
  1115. $cfg['GridEditing'] = 'double-click';
  1116. /**
  1117. * Options > Relational display
  1118. *
  1119. * Possible values:
  1120. * 'K' for key value
  1121. * 'D' for display column
  1122. *
  1123. * @global string $cfg['RelationalDisplay']
  1124. */
  1125. $cfg['RelationalDisplay'] = 'K';
  1126. /*******************************************************************************
  1127. * In edit mode...
  1128. */
  1129. /**
  1130. * disallow editing of binary fields
  1131. * valid values are:
  1132. * false allow editing
  1133. * 'blob' allow editing except for BLOB fields
  1134. * 'noblob' disallow editing except for BLOB fields
  1135. * 'all' disallow editing
  1136. *
  1137. * @global string $cfg['ProtectBinary']
  1138. */
  1139. $cfg['ProtectBinary'] = 'blob';
  1140. /**
  1141. * Display the function fields in edit/insert mode
  1142. *
  1143. * @global boolean $cfg['ShowFunctionFields']
  1144. */
  1145. $cfg['ShowFunctionFields'] = true;
  1146. /**
  1147. * Display the type fields in edit/insert mode
  1148. *
  1149. * @global boolean $cfg['ShowFieldTypesInDataEditView']
  1150. */
  1151. $cfg['ShowFieldTypesInDataEditView'] = true;
  1152. /**
  1153. * Which editor should be used for CHAR/VARCHAR fields:
  1154. * input - allows limiting of input length
  1155. * textarea - allows newlines in fields
  1156. *
  1157. * @global string $cfg['CharEditing']
  1158. */
  1159. $cfg['CharEditing'] = 'input';
  1160. /**
  1161. * The minimum size for character input fields
  1162. *
  1163. * @global integer $cfg['MinSizeForInputField']
  1164. */
  1165. $cfg['MinSizeForInputField'] = 4;
  1166. /**
  1167. * The maximum size for character input fields
  1168. *
  1169. * @global integer $cfg['MinSizeForInputField']
  1170. */
  1171. $cfg['MaxSizeForInputField'] = 60;
  1172. /**
  1173. * How many rows can be inserted at one time
  1174. *
  1175. * @global integer $cfg['InsertRows']
  1176. */
  1177. $cfg['InsertRows'] = 2;
  1178. /**
  1179. * Sort order for items in a foreign-key drop-down list.
  1180. * 'content' is the referenced data, 'id' is the key value.
  1181. *
  1182. * @global array $cfg['ForeignKeyDropdownOrder']
  1183. */
  1184. $cfg['ForeignKeyDropdownOrder'] = [
  1185. 'content-id',
  1186. 'id-content',
  1187. ];
  1188. /**
  1189. * A drop-down list will be used if fewer items are present
  1190. *
  1191. * @global integer $cfg['ForeignKeyMaxLimit']
  1192. */
  1193. $cfg['ForeignKeyMaxLimit'] = 100;
  1194. /**
  1195. * Whether to disable foreign key checks while importing
  1196. *
  1197. * @global boolean $cfg['DefaultForeignKeyChecks']
  1198. */
  1199. $cfg['DefaultForeignKeyChecks'] = 'default';
  1200. /*******************************************************************************
  1201. * For the export features...
  1202. */
  1203. /**
  1204. * Allow for the use of zip compression (requires zip support to be enabled)
  1205. *
  1206. * @global boolean $cfg['ZipDump']
  1207. */
  1208. $cfg['ZipDump'] = true;
  1209. /**
  1210. * Allow for the use of gzip compression (requires zlib)
  1211. *
  1212. * @global boolean $cfg['GZipDump']
  1213. */
  1214. $cfg['GZipDump'] = true;
  1215. /**
  1216. * Allow for the use of bzip2 decompression (requires bz2 extension)
  1217. *
  1218. * @global boolean $cfg['BZipDump']
  1219. */
  1220. $cfg['BZipDump'] = true;
  1221. /**
  1222. * Will compress gzip exports on the fly without the need for much memory.
  1223. * If you encounter problems with created gzip files disable this feature.
  1224. *
  1225. * @global boolean $cfg['CompressOnFly']
  1226. */
  1227. $cfg['CompressOnFly'] = true;
  1228. /*******************************************************************************
  1229. * Tabs display settings
  1230. */
  1231. /**
  1232. * How to display the menu tabs ('icons'|'text'|'both')
  1233. *
  1234. * @global boolean $cfg['TabsMode']
  1235. */
  1236. $cfg['TabsMode'] = 'both';
  1237. /**
  1238. * How to display various action links ('icons'|'text'|'both')
  1239. *
  1240. * @global boolean $cfg['ActionLinksMode']
  1241. */
  1242. $cfg['ActionLinksMode'] = 'both';
  1243. /**
  1244. * How many columns should be used for table display of a database?
  1245. * (a value larger than 1 results in some information being hidden)
  1246. *
  1247. * @global integer $cfg['PropertiesNumColumns']
  1248. */
  1249. $cfg['PropertiesNumColumns'] = 1;
  1250. /**
  1251. * Possible values:
  1252. * 'welcome' = the welcome page
  1253. * (recommended for multiuser setups)
  1254. * 'databases' = list of databases
  1255. * 'status' = runtime information
  1256. * 'variables' = MySQL server variables
  1257. * 'privileges' = user management
  1258. *
  1259. * @global string $cfg['DefaultTabServer']
  1260. */
  1261. $cfg['DefaultTabServer'] = 'welcome';
  1262. /**
  1263. * Possible values:
  1264. * 'structure' = tables list
  1265. * 'sql' = SQL form
  1266. * 'search' = search query
  1267. * 'operations' = operations on database
  1268. *
  1269. * @global string $cfg['DefaultTabDatabase']
  1270. */
  1271. $cfg['DefaultTabDatabase'] = 'structure';
  1272. /**
  1273. * Possible values:
  1274. * 'structure' = fields list
  1275. * 'sql' = SQL form
  1276. * 'search' = search page
  1277. * 'insert' = insert row page
  1278. * 'browse' = browse page
  1279. *
  1280. * @global string $cfg['DefaultTabTable']
  1281. */
  1282. $cfg['DefaultTabTable'] = 'browse';
  1283. /**
  1284. * Whether to display image or text or both image and text in table row
  1285. * action segment. Value can be either of ``image``, ``text`` or ``both``.
  1286. */
  1287. $cfg['RowActionType'] = 'both';
  1288. /*******************************************************************************
  1289. * Export defaults
  1290. */
  1291. $cfg['Export'] = [];
  1292. /**
  1293. * codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xml/yaml
  1294. *
  1295. * @global string $cfg['Export']['format']
  1296. */
  1297. $cfg['Export']['format'] = 'sql';
  1298. /**
  1299. * quick/custom/custom-no-form
  1300. *
  1301. * @global string $cfg['Export']['format']
  1302. */
  1303. $cfg['Export']['method'] = 'quick';
  1304. /**
  1305. * none/zip/gzip
  1306. *
  1307. * @global string $cfg['Export']['compression']
  1308. */
  1309. $cfg['Export']['compression'] = 'none';
  1310. /**
  1311. * Whether to LOCK TABLES before exporting
  1312. *
  1313. * @global boolean $cfg['Export']['lock_tables']
  1314. */
  1315. $cfg['Export']['lock_tables'] = false;
  1316. /**
  1317. * Whether to export databases/tables as separate files
  1318. *
  1319. * @global boolean $cfg['Export']['as_separate_files']
  1320. */
  1321. $cfg['Export']['as_separate_files'] = false;
  1322. /**
  1323. * @global boolean $cfg['Export']['asfile']
  1324. */
  1325. $cfg['Export']['asfile'] = true;
  1326. /**
  1327. * @global string $cfg['Export']['charset']
  1328. */
  1329. $cfg['Export']['charset'] = '';
  1330. /**
  1331. * @global boolean $cfg['Export']['onserver']
  1332. */
  1333. $cfg['Export']['onserver'] = false;
  1334. /**
  1335. * @global boolean $cfg['Export']['onserver_overwrite']
  1336. */
  1337. $cfg['Export']['onserver_overwrite'] = false;
  1338. /**
  1339. * @global boolean $cfg['Export']['quick_export_onserver']
  1340. */
  1341. $cfg['Export']['quick_export_onserver'] = false;
  1342. /**
  1343. * @global boolean $cfg['Export']['quick_export_onserver_overwrite']
  1344. */
  1345. $cfg['Export']['quick_export_onserver_overwrite'] = false;
  1346. /**
  1347. * @global boolean $cfg['Export']['remember_file_template']
  1348. */
  1349. $cfg['Export']['remember_file_template'] = true;
  1350. /**
  1351. * @global string $cfg['Export']['file_template_table']
  1352. */
  1353. $cfg['Export']['file_template_table'] = '@TABLE@';
  1354. /**
  1355. * @global string $cfg['Export']['file_template_database']
  1356. */
  1357. $cfg['Export']['file_template_database'] = '@DATABASE@';
  1358. /**
  1359. * @global string $cfg['Export']['file_template_server']
  1360. */
  1361. $cfg['Export']['file_template_server'] = '@SERVER@';
  1362. /**
  1363. * @global string $cfg['Export']['codegen_structure_or_data']
  1364. */
  1365. $cfg['Export']['codegen_structure_or_data'] = 'data';
  1366. /**
  1367. * @global $cfg['Export']['codegen_format']
  1368. */
  1369. $cfg['Export']['codegen_format'] = 0;
  1370. /**
  1371. * @global boolean $cfg['Export']['ods_columns']
  1372. */
  1373. $cfg['Export']['ods_columns'] = false;
  1374. /**
  1375. * @global string $cfg['Export']['ods_null']
  1376. */
  1377. $cfg['Export']['ods_null'] = 'NULL';
  1378. /**
  1379. * @global string $cfg['Export']['odt_structure_or_data']
  1380. */
  1381. $cfg['Export']['odt_structure_or_data'] = 'structure_and_data';
  1382. /**
  1383. * @global boolean $cfg['Export']['odt_columns']
  1384. */
  1385. $cfg['Export']['odt_columns'] = true;
  1386. /**
  1387. * @global boolean $cfg['Export']['odt_relation']
  1388. */
  1389. $cfg['Export']['odt_relation'] = true;
  1390. /**
  1391. * @global boolean $cfg['Export']['odt_comments']
  1392. */
  1393. $cfg['Export']['odt_comments'] = true;
  1394. /**
  1395. * @global boolean $cfg['Export']['odt_mime']
  1396. */
  1397. $cfg['Export']['odt_mime'] = true;
  1398. /**
  1399. * @global string $cfg['Export']['odt_null']
  1400. */
  1401. $cfg['Export']['odt_null'] = 'NULL';
  1402. /**
  1403. * @global boolean $cfg['Export']['htmlword_structure_or_data']
  1404. */
  1405. $cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';
  1406. /**
  1407. * @global boolean $cfg['Export']['htmlword_columns']
  1408. */
  1409. $cfg['Export']['htmlword_columns'] = false;
  1410. /**
  1411. * @global string $cfg['Export']['htmlword_null']
  1412. */
  1413. $cfg['Export']['htmlword_null'] = 'NULL';
  1414. /**
  1415. * @global string $cfg['Export']['texytext_structure_or_data']
  1416. */
  1417. $cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';
  1418. /**
  1419. * @global boolean $cfg['Export']['texytext_columns']
  1420. */
  1421. $cfg['Export']['texytext_columns'] = false;
  1422. /**
  1423. * @global string $cfg['Export']['texytext_null']
  1424. */
  1425. $cfg['Export']['texytext_null'] = 'NULL';
  1426. /**
  1427. * @global boolean $cfg['Export']['csv_columns']
  1428. */
  1429. $cfg['Export']['csv_columns'] = false;
  1430. /**
  1431. * @global string $cfg['Export']['csv_structure_or_data']
  1432. */
  1433. $cfg['Export']['csv_structure_or_data'] = 'data';
  1434. /**
  1435. * @global string $cfg['Export']['csv_null']
  1436. */
  1437. $cfg['Export']['csv_null'] = 'NULL';
  1438. /**
  1439. * @global string $cfg['Export']['csv_separator']
  1440. */
  1441. $cfg['Export']['csv_separator'] = ',';
  1442. /**
  1443. * @global string $cfg['Export']['csv_enclosed']
  1444. */
  1445. $cfg['Export']['csv_enclosed'] = '"';
  1446. /**
  1447. * @global string $cfg['Export']['csv_escaped']
  1448. */
  1449. $cfg['Export']['csv_escaped'] = '"';
  1450. /**
  1451. * @global string $cfg['Export']['csv_terminated']
  1452. */
  1453. $cfg['Export']['csv_terminated'] = 'AUTO';
  1454. /**
  1455. * @global string $cfg['Export']['csv_removeCRLF']
  1456. */
  1457. $cfg['Export']['csv_removeCRLF'] = false;
  1458. /**
  1459. * @global boolean $cfg['Export']['excel_columns']
  1460. */
  1461. $cfg['Export']['excel_columns'] = true;
  1462. /**
  1463. * @global string $cfg['Export']['excel_null']
  1464. */
  1465. $cfg['Export']['excel_null'] = 'NULL';
  1466. /**
  1467. * win/mac
  1468. *
  1469. * @global string $cfg['Export']['excel_edition']
  1470. */
  1471. $cfg['Export']['excel_edition'] = 'win';
  1472. /**
  1473. * @global string $cfg['Export']['excel_removeCRLF']
  1474. */
  1475. $cfg['Export']['excel_removeCRLF'] = false;
  1476. /**
  1477. * @global string $cfg['Export']['excel_structure_or_data']
  1478. */
  1479. $cfg['Export']['excel_structure_or_data'] = 'data';
  1480. /**
  1481. * @global string $cfg['Export']['latex_structure_or_data']
  1482. */
  1483. $cfg['Export']['latex_structure_or_data'] = 'structure_and_data';
  1484. /**
  1485. * @global boolean $cfg['Export']['latex_columns']
  1486. */
  1487. $cfg['Export']['latex_columns'] = true;
  1488. /**
  1489. * @global boolean $cfg['Export']['latex_relation']
  1490. */
  1491. $cfg['Export']['latex_relation'] = true;
  1492. /**
  1493. * @global boolean $cfg['Export']['latex_comments']
  1494. */
  1495. $cfg['Export']['latex_comments'] = true;
  1496. /**
  1497. * @global boolean $cfg['Export']['latex_mime']
  1498. */
  1499. $cfg['Export']['latex_mime'] = true;
  1500. /**
  1501. * @global string $cfg['Export']['latex_null']
  1502. */
  1503. $cfg['Export']['latex_null'] = '\textit{NULL}';
  1504. /**
  1505. * @global boolean $cfg['Export']['latex_caption']
  1506. */
  1507. $cfg['Export']['latex_caption'] = true;
  1508. /**
  1509. * @global string $cfg['Export']['latex_structure_caption']
  1510. */
  1511. $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
  1512. /**
  1513. * @global string $cfg['Export']['latex_structure_continued_caption']
  1514. */
  1515. $cfg['Export']['latex_structure_continued_caption']
  1516. = 'strLatexStructure strLatexContinued';
  1517. /**
  1518. * @global string $cfg['Export']['latex_data_caption']
  1519. */
  1520. $cfg['Export']['latex_data_caption'] = 'strLatexContent';
  1521. /**
  1522. * @global string $cfg['Export']['latex_data_continued_caption']
  1523. */
  1524. $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
  1525. /**
  1526. * @global string $cfg['Export']['latex_data_label']
  1527. */
  1528. $cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';
  1529. /**
  1530. * @global string $cfg['Export']['latex_structure_label']
  1531. */
  1532. $cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';
  1533. /**
  1534. * @global string $cfg['Export']['mediawiki_structure_or_data']
  1535. */
  1536. $cfg['Export']['mediawiki_structure_or_data'] = 'data';
  1537. /**
  1538. * @global boolean $cfg['Export']['mediawiki_caption']
  1539. */
  1540. $cfg['Export']['mediawiki_caption'] = true;
  1541. /**
  1542. * @global boolean $cfg['Export']['mediawiki_headers']
  1543. */
  1544. $cfg['Export']['mediawiki_headers'] = true;
  1545. /**
  1546. * @global string $cfg['Export']['ods_structure_or_data']
  1547. */
  1548. $cfg['Export']['ods_structure_or_data'] = 'data';
  1549. /**
  1550. * @global string $cfg['Export']['pdf_structure_or_data']
  1551. */
  1552. $cfg['Export']['pdf_structure_or_data'] = 'data';
  1553. /**
  1554. * @global string $cfg['Export']['phparray_structure_or_data']
  1555. */
  1556. $cfg['Export']['phparray_structure_or_data'] = 'data';
  1557. /**
  1558. * @global string $cfg['Export']['json_structure_or_data']
  1559. */
  1560. $cfg['Export']['json_structure_or_data'] = 'data';
  1561. /**
  1562. * Export functions
  1563. *
  1564. * @global string $cfg['Export']['json_pretty_print']
  1565. */
  1566. $cfg['Export']['json_pretty_print'] = false;
  1567. /**
  1568. * Export functions
  1569. *
  1570. * @global string $cfg['Export']['json_unicode']
  1571. */
  1572. $cfg['Export']['json_unicode'] = true;
  1573. /**
  1574. * @global string $cfg['Export']['sql_structure_or_data']
  1575. */
  1576. $cfg['Export']['sql_structure_or_data'] = 'structure_and_data';
  1577. /**
  1578. * @global string $cfg['Export']['sql_compatibility']
  1579. */
  1580. $cfg['Export']['sql_compatibility'] = 'NONE';
  1581. /**
  1582. * Whether to include comments in SQL export.
  1583. *
  1584. * @global string $cfg['Export']['sql_include_comments']
  1585. */
  1586. $cfg['Export']['sql_include_comments'] = true;
  1587. /**
  1588. * @global boolean $cfg['Export']['sql_disable_fk']
  1589. */
  1590. $cfg['Export']['sql_disable_fk'] = false;
  1591. /**
  1592. * @global boolean $cfg['Export']['sql_views_as_tables']
  1593. */
  1594. $cfg['Export']['sql_views_as_tables'] = false;
  1595. /**
  1596. * @global boolean $cfg['Export']['sql_metadata']
  1597. */
  1598. $cfg['Export']['sql_metadata'] = false;
  1599. /**
  1600. * @global boolean $cfg['Export']['sql_use_transaction']
  1601. */
  1602. $cfg['Export']['sql_use_transaction'] = true;
  1603. /**
  1604. * @global boolean $cfg['Export']['sql_create_database']
  1605. */
  1606. $cfg['Export']['sql_create_database'] = false;
  1607. /**
  1608. * @global boolean $cfg['Export']['sql_drop_database']
  1609. */
  1610. $cfg['Export']['sql_drop_database'] = false;
  1611. /**
  1612. * @global boolean $cfg['Export']['sql_drop_table']
  1613. */
  1614. $cfg['Export']['sql_drop_table'] = false;
  1615. /**
  1616. * true by default for correct behavior when dealing with exporting
  1617. * of VIEWs and the stand-in table
  1618. *
  1619. * @global boolean $cfg['Export']['sql_if_not_exists']
  1620. */
  1621. $cfg['Export']['sql_if_not_exists'] = false;
  1622. /**
  1623. * @global boolean $cfg['Export']['sql_view_current_user']
  1624. */
  1625. $cfg['Export']['sql_view_current_user'] = false;
  1626. /**
  1627. * @global boolean $cfg['Export']['sql_or_replace']
  1628. */
  1629. $cfg['Export']['sql_or_replace_view'] = false;
  1630. /**
  1631. * @global boolean $cfg['Export']['sql_procedure_function']
  1632. */
  1633. $cfg['Export']['sql_procedure_function'] = true;
  1634. /**
  1635. * @global boolean $cfg['Export']['sql_create_table']
  1636. */
  1637. $cfg['Export']['sql_create_table'] = true;
  1638. /**
  1639. * @global boolean $cfg['Export']['sql_create_view']
  1640. */
  1641. $cfg['Export']['sql_create_view'] = true;
  1642. /**
  1643. * @global boolean $cfg['Export']['sql_create_trigger']
  1644. */
  1645. $cfg['Export']['sql_create_trigger'] = true;
  1646. /**
  1647. * @global boolean $cfg['Export']['sql_auto_increment']
  1648. */
  1649. $cfg['Export']['sql_auto_increment'] = true;
  1650. /**
  1651. * @global boolean $cfg['Export']['sql_backquotes']
  1652. */
  1653. $cfg['Export']['sql_backquotes'] = true;
  1654. /**
  1655. * @global boolean $cfg['Export']['sql_dates']
  1656. */
  1657. $cfg['Export']['sql_dates'] = false;
  1658. /**
  1659. * @global boolean $cfg['Export']['sql_relation']
  1660. */
  1661. $cfg['Export']['sql_relation'] = false;
  1662. /**
  1663. * @global boolean $cfg['Export']['sql_truncate']
  1664. */
  1665. $cfg['Export']['sql_truncate'] = false;
  1666. /**
  1667. * @global boolean $cfg['Export']['sql_delayed']
  1668. */
  1669. $cfg['Export']['sql_delayed'] = false;
  1670. /**
  1671. * @global boolean $cfg['Export']['sql_ignore']
  1672. */
  1673. $cfg['Export']['sql_ignore'] = false;
  1674. /**
  1675. * Export time in UTC.
  1676. *
  1677. * @global boolean $cfg['Export']['sql_utc_time']
  1678. */
  1679. $cfg['Export']['sql_utc_time'] = true;
  1680. /**
  1681. * @global boolean $cfg['Export']['sql_hex_for_binary']
  1682. */
  1683. $cfg['Export']['sql_hex_for_binary'] = true;
  1684. /**
  1685. * insert/update/replace
  1686. *
  1687. * @global string $cfg['Export']['sql_type']
  1688. */
  1689. $cfg['Export']['sql_type'] = 'INSERT';
  1690. /**
  1691. * @global integer $cfg['Export']['sql_max_query_size']
  1692. */
  1693. $cfg['Export']['sql_max_query_size'] = 50000;
  1694. /**
  1695. * @global boolean $cfg['Export']['sql_mime']
  1696. */
  1697. $cfg['Export']['sql_mime'] = false;
  1698. /**
  1699. * \n is replaced by new line
  1700. *
  1701. * @global string $cfg['Export']['sql_header_comment']
  1702. */
  1703. $cfg['Export']['sql_header_comment'] = '';
  1704. /**
  1705. * Whether to use complete inserts, extended inserts, both, or neither
  1706. *
  1707. * @global string $cfg['Export']['sql_insert_syntax']
  1708. */
  1709. $cfg['Export']['sql_insert_syntax'] = 'both';
  1710. /**
  1711. * @global string $cfg['Export']['pdf_report_title']
  1712. */
  1713. $cfg['Export']['pdf_report_title'] = '';
  1714. /**
  1715. * @global string $cfg['Export']['xml_structure_or_data']
  1716. */
  1717. $cfg['Export']['xml_structure_or_data'] = 'data';
  1718. /**
  1719. * Export schema for each structure
  1720. *
  1721. * @global string $cfg['Export']['xml_export_struc']
  1722. */
  1723. $cfg['Export']['xml_export_struc'] = true;
  1724. /**
  1725. * Export events
  1726. *
  1727. * @global string $cfg['Export']['xml_export_events']
  1728. */
  1729. $cfg['Export']['xml_export_events'] = true;
  1730. /**
  1731. * Export functions
  1732. *
  1733. * @global string $cfg['Export']['xml_export_functions']
  1734. */
  1735. $cfg['Export']['xml_export_functions'] = true;
  1736. /**
  1737. * Export procedures
  1738. *
  1739. * @global string $cfg['Export']['xml_export_procedures']
  1740. */
  1741. $cfg['Export']['xml_export_procedures'] = true;
  1742. /**
  1743. * Export schema for each table
  1744. *
  1745. * @global string $cfg['Export']['xml_export_tables']
  1746. */
  1747. $cfg['Export']['xml_export_tables'] = true;
  1748. /**
  1749. * Export triggers
  1750. *
  1751. * @global string $cfg['Export']['xml_export_triggers']
  1752. */
  1753. $cfg['Export']['xml_export_triggers'] = true;
  1754. /**
  1755. * Export views
  1756. *
  1757. * @global string $cfg['Export']['xml_export_views']
  1758. */
  1759. $cfg['Export']['xml_export_views'] = true;
  1760. /**
  1761. * Export contents data
  1762. *
  1763. * @global string $cfg['Export']['xml_export_contents']
  1764. */
  1765. $cfg['Export']['xml_export_contents'] = true;
  1766. /**
  1767. * @global string $cfg['Export']['yaml_structure_or_data']
  1768. */
  1769. $cfg['Export']['yaml_structure_or_data'] = 'data';
  1770. /*******************************************************************************
  1771. * Import defaults
  1772. */
  1773. $cfg['Import'] = [];
  1774. /**
  1775. * @global string $cfg['Import']['format']
  1776. */
  1777. $cfg['Import']['format'] = 'sql';
  1778. /**
  1779. * Default charset for import.
  1780. *
  1781. * @global string $cfg['Import']['charset']
  1782. */
  1783. $cfg['Import']['charset'] = '';
  1784. /**
  1785. * @global boolean $cfg['Import']['allow_interrupt']
  1786. */
  1787. $cfg['Import']['allow_interrupt'] = true;
  1788. /**
  1789. * @global integer $cfg['Import']['skip_queries']
  1790. */
  1791. $cfg['Import']['skip_queries'] = 0;
  1792. /**
  1793. * @global string $cfg['Import']['sql_compatibility']
  1794. */
  1795. $cfg['Import']['sql_compatibility'] = 'NONE';
  1796. /**
  1797. * @global string $cfg['Import']['sql_no_auto_value_on_zero']
  1798. */
  1799. $cfg['Import']['sql_no_auto_value_on_zero'] = true;
  1800. /**
  1801. * @global string $cfg['Import']['sql_read_as_multibytes']
  1802. */
  1803. $cfg['Import']['sql_read_as_multibytes'] = false;
  1804. /**
  1805. * @global boolean $cfg['Import']['csv_replace']
  1806. */
  1807. $cfg['Import']['csv_replace'] = false;
  1808. /**
  1809. * @global boolean $cfg['Import']['csv_ignore']
  1810. */
  1811. $cfg['Import']['csv_ignore'] = false;
  1812. /**
  1813. * @global string $cfg['Import']['csv_terminated']
  1814. */
  1815. $cfg['Import']['csv_terminated'] = ',';
  1816. /**
  1817. * @global string $cfg['Import']['csv_enclosed']
  1818. */
  1819. $cfg['Import']['csv_enclosed'] = '"';
  1820. /**
  1821. * @global string $cfg['Import']['csv_escaped']
  1822. */
  1823. $cfg['Import']['csv_escaped'] = '"';
  1824. /**
  1825. * @global string $cfg['Import']['csv_new_line']
  1826. */
  1827. $cfg['Import']['csv_new_line'] = 'auto';
  1828. /**
  1829. * @global string $cfg['Import']['csv_columns']
  1830. */
  1831. $cfg['Import']['csv_columns'] = '';
  1832. /**
  1833. * @global string $cfg['Import']['csv_col_names']
  1834. */
  1835. $cfg['Import']['csv_col_names'] = false;
  1836. /**
  1837. * @global boolean $cfg['Import']['ldi_replace']
  1838. */
  1839. $cfg['Import']['ldi_replace'] = false;
  1840. /**
  1841. * @global boolean $cfg['Import']['ldi_ignore']
  1842. */
  1843. $cfg['Import']['ldi_ignore'] = false;
  1844. /**
  1845. * @global string $cfg['Import']['ldi_terminated']
  1846. */
  1847. $cfg['Import']['ldi_terminated'] = ';';
  1848. /**
  1849. * @global string $cfg['Import']['ldi_enclosed']
  1850. */
  1851. $cfg['Import']['ldi_enclosed'] = '"';
  1852. /**
  1853. * @global string $cfg['Import']['ldi_escaped']
  1854. */
  1855. $cfg['Import']['ldi_escaped'] = '\\';
  1856. /**
  1857. * @global string $cfg['Import']['ldi_new_line']
  1858. */
  1859. $cfg['Import']['ldi_new_line'] = 'auto';
  1860. /**
  1861. * @global string $cfg['Import']['ldi_columns']
  1862. */
  1863. $cfg['Import']['ldi_columns'] = '';
  1864. /**
  1865. * 'auto' for auto-detection, true or false for forcing
  1866. *
  1867. * @global string $cfg['Import']['ldi_local_option']
  1868. */
  1869. $cfg['Import']['ldi_local_option'] = 'auto';
  1870. /**
  1871. * @global string $cfg['Import']['ods_col_names']
  1872. */
  1873. $cfg['Import']['ods_col_names'] = false;
  1874. /**
  1875. * @global string $cfg['Import']['ods_empty_rows']
  1876. */
  1877. $cfg['Import']['ods_empty_rows'] = true;
  1878. /**
  1879. * @global string $cfg['Import']['ods_recognize_percentages']
  1880. */
  1881. $cfg['Import']['ods_recognize_percentages'] = true;
  1882. /**
  1883. * @global string $cfg['Import']['ods_recognize_currency']
  1884. */
  1885. $cfg['Import']['ods_recognize_currency'] = true;
  1886. /*******************************************************************************
  1887. * Schema export defaults
  1888. */
  1889. $cfg['Schema'] = [];
  1890. /**
  1891. * pdf/eps/dia/svg
  1892. *
  1893. * @global string $cfg['Schema']['format']
  1894. */
  1895. $cfg['Schema']['format'] = 'pdf';
  1896. /**
  1897. * @global string $cfg['Schema']['pdf_show_color']
  1898. */
  1899. $cfg['Schema']['pdf_show_color'] = true;
  1900. /**
  1901. * @global string $cfg['Schema']['pdf_show_keys']
  1902. */
  1903. $cfg['Schema']['pdf_show_keys'] = false;
  1904. /**
  1905. * @global string $cfg['Schema']['pdf_all_tables_same_width']
  1906. */
  1907. $cfg['Schema']['pdf_all_tables_same_width'] = false;
  1908. /**
  1909. * L/P
  1910. *
  1911. * @global string $cfg['Schema']['pdf_orientation']
  1912. */
  1913. $cfg['Schema']['pdf_orientation'] = 'L';
  1914. /**
  1915. * @global string $cfg['Schema']['pdf_paper']
  1916. */
  1917. $cfg['Schema']['pdf_paper'] = 'A4';
  1918. /**
  1919. * @global string $cfg['Schema']['pdf_show_grid']
  1920. */
  1921. $cfg['Schema']['pdf_show_grid'] = false;
  1922. /**
  1923. * @global string $cfg['Schema']['pdf_with_doc']
  1924. */
  1925. $cfg['Schema']['pdf_with_doc'] = true;
  1926. /**
  1927. * @global string $cfg['Schema']['pdf_table_order']
  1928. */
  1929. $cfg['Schema']['pdf_table_order'] = '';
  1930. /**
  1931. * @global string $cfg['Schema']['dia_show_color']
  1932. */
  1933. $cfg['Schema']['dia_show_color'] = true;
  1934. /**
  1935. * @global string $cfg['Schema']['dia_show_keys']
  1936. */
  1937. $cfg['Schema']['dia_show_keys'] = false;
  1938. /**
  1939. * L/P
  1940. *
  1941. * @global string $cfg['Schema']['dia_orientation']
  1942. */
  1943. $cfg['Schema']['dia_orientation'] = 'L';
  1944. /**
  1945. * @global string $cfg['Schema']['dia_paper']
  1946. */
  1947. $cfg['Schema']['dia_paper'] = 'A4';
  1948. /**
  1949. * @global string $cfg['Schema']['eps_show_color']
  1950. */
  1951. $cfg['Schema']['eps_show_color'] = true;
  1952. /**
  1953. * @global string $cfg['Schema']['eps_show_keys']
  1954. */
  1955. $cfg['Schema']['eps_show_keys'] = false;
  1956. /**
  1957. * @global string $cfg['Schema']['eps_all_tables_same_width']
  1958. */
  1959. $cfg['Schema']['eps_all_tables_same_width'] = false;
  1960. /**
  1961. * L/P
  1962. *
  1963. * @global string $cfg['Schema']['eps_orientation']
  1964. */
  1965. $cfg['Schema']['eps_orientation'] = 'L';
  1966. /**
  1967. * @global string $cfg['Schema']['svg_show_color']
  1968. */
  1969. $cfg['Schema']['svg_show_color'] = true;
  1970. /**
  1971. * @global string $cfg['Schema']['svg_show_keys']
  1972. */
  1973. $cfg['Schema']['svg_show_keys'] = false;
  1974. /**
  1975. * @global string $cfg['Schema']['svg_all_tables_same_width']
  1976. */
  1977. $cfg['Schema']['svg_all_tables_same_width'] = false;
  1978. /*******************************************************************************
  1979. * PDF options
  1980. */
  1981. /**
  1982. * @global array $cfg['PDFPageSizes']
  1983. */
  1984. $cfg['PDFPageSizes'] = [
  1985. 'A3',
  1986. 'A4',
  1987. 'A5',
  1988. 'letter',
  1989. 'legal',
  1990. ];
  1991. /**
  1992. * @global string $cfg['PDFDefaultPageSize']
  1993. */
  1994. $cfg['PDFDefaultPageSize'] = 'A4';
  1995. /*******************************************************************************
  1996. * Language and character set conversion settings
  1997. */
  1998. /**
  1999. * Default language to use, if not browser-defined or user-defined
  2000. *
  2001. * @global string $cfg['DefaultLang']
  2002. */
  2003. $cfg['DefaultLang'] = 'en';
  2004. /**
  2005. * Default connection collation
  2006. *
  2007. * @global string $cfg['DefaultConnectionCollation']
  2008. */
  2009. $cfg['DefaultConnectionCollation'] = 'utf8mb4_unicode_ci';
  2010. /**
  2011. * Force: always use this language, e.g. 'en'
  2012. *
  2013. * @global string $cfg['Lang']
  2014. */
  2015. $cfg['Lang'] = '';
  2016. /**
  2017. * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
  2018. * English only
  2019. *
  2020. * @global string $cfg['FilterLanguages']
  2021. */
  2022. $cfg['FilterLanguages'] = '';
  2023. /**
  2024. * You can select here which functions will be used for character set conversion.
  2025. * Possible values are:
  2026. * auto - automatically use available one (first is tested iconv, then
  2027. * recode)
  2028. * iconv - use iconv or libiconv functions
  2029. * recode - use recode_string function
  2030. * mb - use mbstring extension
  2031. * none - disable encoding conversion
  2032. *
  2033. * @global string $cfg['RecodingEngine']
  2034. */
  2035. $cfg['RecodingEngine'] = 'auto';
  2036. /**
  2037. * Specify some parameters for iconv used in character set conversion. See iconv
  2038. * documentation for details:
  2039. * https://www.gnu.org/savannah-checkouts/gnu/libiconv/documentation/libiconv-1.15/iconv_open.3.html
  2040. *
  2041. * @global string $cfg['IconvExtraParams']
  2042. */
  2043. $cfg['IconvExtraParams'] = '//TRANSLIT';
  2044. /**
  2045. * Available character sets for MySQL conversion. currently contains all which could
  2046. * be found in lang/* files and few more.
  2047. * Character sets will be shown in same order as here listed, so if you frequently
  2048. * use some of these move them to the top.
  2049. *
  2050. * @global array $cfg['AvailableCharsets']
  2051. */
  2052. $cfg['AvailableCharsets'] = [
  2053. 'iso-8859-1',
  2054. 'iso-8859-2',
  2055. 'iso-8859-3',
  2056. 'iso-8859-4',
  2057. 'iso-8859-5',
  2058. 'iso-8859-6',
  2059. 'iso-8859-7',
  2060. 'iso-8859-8',
  2061. 'iso-8859-9',
  2062. 'iso-8859-10',
  2063. 'iso-8859-11',
  2064. 'iso-8859-12',
  2065. 'iso-8859-13',
  2066. 'iso-8859-14',
  2067. 'iso-8859-15',
  2068. 'windows-1250',
  2069. 'windows-1251',
  2070. 'windows-1252',
  2071. 'windows-1256',
  2072. 'windows-1257',
  2073. 'koi8-r',
  2074. 'big5',
  2075. 'gb2312',
  2076. 'utf-16',
  2077. 'utf-8',
  2078. 'utf-7',
  2079. 'x-user-defined',
  2080. 'euc-jp',
  2081. 'ks_c_5601-1987',
  2082. 'tis-620',
  2083. 'SHIFT_JIS',
  2084. 'SJIS',
  2085. 'SJIS-win',
  2086. ];
  2087. /*******************************************************************************
  2088. * Customization & design
  2089. *
  2090. * The graphical settings are now located in themes/theme-name/scss/_variables.scss
  2091. */
  2092. /**
  2093. * enable the left panel pointer
  2094. *
  2095. * @global boolean $cfg['NavigationTreePointerEnable']
  2096. */
  2097. $cfg['NavigationTreePointerEnable'] = true;
  2098. /**
  2099. * enable the browse pointer
  2100. *
  2101. * @global boolean $cfg['BrowsePointerEnable']
  2102. */
  2103. $cfg['BrowsePointerEnable'] = true;
  2104. /**
  2105. * enable the browse marker
  2106. *
  2107. * @global boolean $cfg['BrowseMarkerEnable']
  2108. */
  2109. $cfg['BrowseMarkerEnable'] = true;
  2110. /**
  2111. * textarea size (columns) in edit mode
  2112. * (this value will be emphasized (*2) for SQL
  2113. * query textareas and (*1.25) for query window)
  2114. *
  2115. * @global integer $cfg['TextareaCols']
  2116. */
  2117. $cfg['TextareaCols'] = 40;
  2118. /**
  2119. * textarea size (rows) in edit mode
  2120. *
  2121. * @global integer $cfg['TextareaRows']
  2122. */
  2123. $cfg['TextareaRows'] = 15;
  2124. /**
  2125. * double size of textarea size for LONGTEXT columns
  2126. *
  2127. * @global boolean $cfg['LongtextDoubleTextarea']
  2128. */
  2129. $cfg['LongtextDoubleTextarea'] = true;
  2130. /**
  2131. * auto-select when clicking in the textarea of the query-box
  2132. *
  2133. * @global boolean $cfg['TextareaAutoSelect']
  2134. */
  2135. $cfg['TextareaAutoSelect'] = false;
  2136. /**
  2137. * textarea size (columns) for CHAR/VARCHAR
  2138. *
  2139. * @global integer $cfg['CharTextareaCols']
  2140. */
  2141. $cfg['CharTextareaCols'] = 40;
  2142. /**
  2143. * textarea size (rows) for CHAR/VARCHAR
  2144. *
  2145. * @global integer $cfg['CharTextareaRows']
  2146. */
  2147. $cfg['CharTextareaRows'] = 2;
  2148. /**
  2149. * Max field data length in browse mode for all non-numeric fields
  2150. *
  2151. * @global integer $cfg['LimitChars']
  2152. */
  2153. $cfg['LimitChars'] = 50;
  2154. /**
  2155. * Where to show the edit/copy/delete links in browse mode
  2156. * Possible values are 'left', 'right', 'both' and 'none'.
  2157. *
  2158. * @global string $cfg['RowActionLinks']
  2159. */
  2160. $cfg['RowActionLinks'] = 'left';
  2161. /**
  2162. * Whether to show row links (Edit, Copy, Delete) and checkboxes for
  2163. * multiple row operations even when the selection does not have a unique key.
  2164. *
  2165. * @global boolean $cfg['RowActionLinksWithoutUnique']
  2166. */
  2167. $cfg['RowActionLinksWithoutUnique'] = false;
  2168. /**
  2169. * Default sort order by primary key.
  2170. *
  2171. * @global string $cfg['TablePrimaryKeyOrder']
  2172. */
  2173. $cfg['TablePrimaryKeyOrder'] = 'NONE';
  2174. /**
  2175. * remember the last way a table sorted
  2176. *
  2177. * @global string $cfg['RememberSorting']
  2178. */
  2179. $cfg['RememberSorting'] = true;
  2180. /**
  2181. * shows column comments in 'browse' mode.
  2182. *
  2183. * @global boolean $cfg['ShowBrowseComments']
  2184. */
  2185. $cfg['ShowBrowseComments'] = true;
  2186. /**
  2187. * shows column comments in 'table property' mode.
  2188. *
  2189. * @global boolean $cfg['ShowPropertyComments']
  2190. */
  2191. $cfg['ShowPropertyComments'] = true;
  2192. /**
  2193. * repeat header names every X cells? (0 = deactivate)
  2194. *
  2195. * @global integer $cfg['RepeatCells']
  2196. */
  2197. $cfg['RepeatCells'] = 100;
  2198. /**
  2199. * Set to true if you want DB-based query history.If false, this utilizes
  2200. * JS-routines to display query history (lost by window close)
  2201. *
  2202. * @global boolean $cfg['QueryHistoryDB']
  2203. */
  2204. $cfg['QueryHistoryDB'] = false;
  2205. /**
  2206. * When using DB-based query history, how many entries should be kept?
  2207. *
  2208. * @global integer $cfg['QueryHistoryMax']
  2209. */
  2210. $cfg['QueryHistoryMax'] = 25;
  2211. /**
  2212. * Use MIME-Types (stored in column comments table) for
  2213. *
  2214. * @global boolean $cfg['BrowseMIME']
  2215. */
  2216. $cfg['BrowseMIME'] = true;
  2217. /**
  2218. * When approximate count < this, PMA will get exact count for table rows.
  2219. *
  2220. * @global integer $cfg['MaxExactCount']
  2221. */
  2222. $cfg['MaxExactCount'] = 50000;
  2223. /**
  2224. * Zero means that no row count is done for views; see the doc
  2225. *
  2226. * @global integer $cfg['MaxExactCountViews']
  2227. */
  2228. $cfg['MaxExactCountViews'] = 0;
  2229. /**
  2230. * Sort table and database in natural order
  2231. *
  2232. * @global boolean $cfg['NaturalOrder']
  2233. */
  2234. $cfg['NaturalOrder'] = true;
  2235. /**
  2236. * Initial state for sliders
  2237. * (open | closed | disabled)
  2238. *
  2239. * @global string $cfg['InitialSlidersState']
  2240. */
  2241. $cfg['InitialSlidersState'] = 'closed';
  2242. /**
  2243. * User preferences: disallow these settings
  2244. * For possible setting names look in libraries/config/user_preferences.forms.php
  2245. *
  2246. * @global array $cfg['UserprefsDisallow']
  2247. */
  2248. $cfg['UserprefsDisallow'] = [];
  2249. /**
  2250. * User preferences: enable the Developer tab
  2251. */
  2252. $cfg['UserprefsDeveloperTab'] = false;
  2253. /*******************************************************************************
  2254. * Window title settings
  2255. */
  2256. /**
  2257. * title of browser window when a table is selected
  2258. *
  2259. * @global string $cfg['TitleTable']
  2260. */
  2261. $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
  2262. /**
  2263. * title of browser window when a database is selected
  2264. *
  2265. * @global string $cfg['TitleDatabase']
  2266. */
  2267. $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
  2268. /**
  2269. * title of browser window when a server is selected
  2270. *
  2271. * @global string $cfg['TitleServer']
  2272. */
  2273. $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
  2274. /**
  2275. * title of browser window when nothing is selected
  2276. *
  2277. * @global string $cfg['TitleDefault']
  2278. */
  2279. $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
  2280. /*******************************************************************************
  2281. * theme manager
  2282. */
  2283. /**
  2284. * if you want to use selectable themes and if ThemesPath not empty
  2285. * set it to true, else set it to false (default is false);
  2286. *
  2287. * @global boolean $cfg['ThemeManager']
  2288. */
  2289. $cfg['ThemeManager'] = true;
  2290. /**
  2291. * set up default theme, you can set up here an valid
  2292. * path to themes or 'original' for the original pma-theme
  2293. *
  2294. * @global string $cfg['ThemeDefault']
  2295. */
  2296. $cfg['ThemeDefault'] = 'pmahomme';
  2297. /**
  2298. * allow different theme for each configured server
  2299. *
  2300. * @global boolean $cfg['ThemePerServer']
  2301. */
  2302. $cfg['ThemePerServer'] = false;
  2303. /**
  2304. * Default query for table
  2305. *
  2306. * @global string $cfg['DefaultQueryTable']
  2307. */
  2308. $cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';
  2309. /**
  2310. * Default query for database
  2311. *
  2312. * @global string $cfg['DefaultQueryDatabase']
  2313. */
  2314. $cfg['DefaultQueryDatabase'] = '';
  2315. /*******************************************************************************
  2316. * SQL Query box settings
  2317. * These are the links display in all of the SQL Query boxes
  2318. *
  2319. * @global array $cfg['SQLQuery']
  2320. */
  2321. $cfg['SQLQuery'] = [];
  2322. /**
  2323. * Display an "Edit" link on the results page to change a query
  2324. *
  2325. * @global boolean $cfg['SQLQuery']['Edit']
  2326. */
  2327. $cfg['SQLQuery']['Edit'] = true;
  2328. /**
  2329. * Display an "Explain SQL" link on the results page
  2330. *
  2331. * @global boolean $cfg['SQLQuery']['Explain']
  2332. */
  2333. $cfg['SQLQuery']['Explain'] = true;
  2334. /**
  2335. * Display a "Create PHP code" link on the results page to wrap a query in PHP
  2336. *
  2337. * @global boolean $cfg['SQLQuery']['ShowAsPHP']
  2338. */
  2339. $cfg['SQLQuery']['ShowAsPHP'] = true;
  2340. /**
  2341. * Display a "Refresh" link on the results page
  2342. *
  2343. * @global boolean $cfg['SQLQuery']['Refresh']
  2344. */
  2345. $cfg['SQLQuery']['Refresh'] = true;
  2346. /**
  2347. * Enables autoComplete for table & column names in SQL queries
  2348. *
  2349. * default = 'true'
  2350. */
  2351. $cfg['EnableAutocompleteForTablesAndColumns'] = true;
  2352. /*******************************************************************************
  2353. * Web server upload/save/import directories
  2354. */
  2355. /**
  2356. * Directory for uploaded files that can be executed by phpMyAdmin.
  2357. * For example './upload'. Leave empty for no upload directory support.
  2358. * Use %u for username inclusion.
  2359. *
  2360. * @global string $cfg['UploadDir']
  2361. */
  2362. $cfg['UploadDir'] = '';
  2363. /**
  2364. * Directory where phpMyAdmin can save exported data on server.
  2365. * For example './save'. Leave empty for no save directory support.
  2366. * Use %u for username inclusion.
  2367. *
  2368. * @global string $cfg['SaveDir']
  2369. */
  2370. $cfg['SaveDir'] = '';
  2371. /**
  2372. * Directory where phpMyAdmin can save temporary files.
  2373. *
  2374. * @global string $cfg['TempDir']
  2375. */
  2376. if (defined('TEMP_DIR')) {
  2377. $cfg['TempDir'] = TEMP_DIR;
  2378. } else {
  2379. $cfg['TempDir'] = ROOT_PATH . 'tmp' . DIRECTORY_SEPARATOR;
  2380. }
  2381. /**
  2382. * Misc. settings
  2383. */
  2384. /**
  2385. * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
  2386. * which is the only safe way to determine GD version.
  2387. *
  2388. * @global string $cfg['GD2Available']
  2389. */
  2390. $cfg['GD2Available'] = 'auto';
  2391. /**
  2392. * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
  2393. *
  2394. * @global array $cfg['TrustedProxies']
  2395. */
  2396. $cfg['TrustedProxies'] = [];
  2397. /**
  2398. * We normally check the permissions on the configuration file to ensure
  2399. * it's not world writable. However, phpMyAdmin could be installed on
  2400. * a NTFS filesystem mounted on a non-Windows server, in which case the
  2401. * permissions seems wrong but in fact cannot be detected. In this case
  2402. * a sysadmin would set the following to false.
  2403. */
  2404. $cfg['CheckConfigurationPermissions'] = true;
  2405. /**
  2406. * Limit for length of URL in links. When length would be above this limit, it
  2407. * is replaced by form with button.
  2408. * This is required as some web servers (IIS) have problems with long URLs.
  2409. * The recommended limit is 2000
  2410. * (see https://www.boutell.com/newfaq/misc/urllength.html) but we put
  2411. * 1000 to accommodate Suhosin, see bug #3358750.
  2412. */
  2413. $cfg['LinkLengthLimit'] = 1000;
  2414. /**
  2415. * Additional string to allow in CSP headers.
  2416. */
  2417. $cfg['CSPAllow'] = '';
  2418. /**
  2419. * Disable the table maintenance mass operations, like optimizing or
  2420. * repairing the selected tables of a database. An accidental execution
  2421. * of such a maintenance task can enormously slow down a bigger database.
  2422. */
  2423. $cfg['DisableMultiTableMaintenance'] = false;
  2424. /**
  2425. * Whether or not to query the user before sending the error report to
  2426. * the phpMyAdmin team when a JavaScript error occurs
  2427. *
  2428. * Available options
  2429. * (ask | always | never)
  2430. *
  2431. * @global string $cfg['SendErrorReports']
  2432. */
  2433. $cfg['SendErrorReports'] = 'ask';
  2434. /**
  2435. * Whether Enter or Ctrl+Enter executes queries in the console.
  2436. *
  2437. * @global boolean $cfg['ConsoleEnterExecutes']
  2438. */
  2439. $cfg['ConsoleEnterExecutes'] = false;
  2440. /**
  2441. * Zero Configuration mode.
  2442. *
  2443. * @global boolean $cfg['ZeroConf']
  2444. */
  2445. $cfg['ZeroConf'] = true;
  2446. /*******************************************************************************
  2447. * Developers ONLY!
  2448. *
  2449. * @global array $cfg['DBG']
  2450. */
  2451. $cfg['DBG'] = [];
  2452. /**
  2453. * Output executed queries and their execution times
  2454. *
  2455. * @global boolean $cfg['DBG']['sql']
  2456. */
  2457. $cfg['DBG']['sql'] = false;
  2458. /**
  2459. * Log executed queries and their execution times to syslog
  2460. *
  2461. * @global boolean $cfg['DBG']['sqllog']
  2462. */
  2463. $cfg['DBG']['sqllog'] = false;
  2464. /**
  2465. * Enable to let server present itself as demo server.
  2466. *
  2467. * @global boolean $cfg['DBG']['demo']
  2468. */
  2469. $cfg['DBG']['demo'] = false;
  2470. /**
  2471. * Enable Simple two-factor authentication
  2472. *
  2473. * @global boolean $cfg['DBG']['simple2fa']
  2474. */
  2475. $cfg['DBG']['simple2fa'] = false;
  2476. /**
  2477. * Sets the working environment
  2478. *
  2479. * This only needs to be changed when you are developing phpMyAdmin itself.
  2480. * The development mode may display debug information in some places.
  2481. *
  2482. * Possible values are 'production' or 'development'
  2483. */
  2484. $cfg['environment'] = 'production';
  2485. /*******************************************************************************
  2486. * MySQL settings
  2487. */
  2488. /**
  2489. * Default functions for above defined groups
  2490. *
  2491. * @global array $cfg['DefaultFunctions']
  2492. */
  2493. $cfg['DefaultFunctions'] = [
  2494. 'FUNC_CHAR' => '',
  2495. 'FUNC_DATE' => '',
  2496. 'FUNC_NUMBER' => '',
  2497. 'FUNC_SPATIAL' => 'GeomFromText',
  2498. 'FUNC_UUID' => 'UUID',
  2499. 'first_timestamp' => 'NOW',
  2500. ];
  2501. /**
  2502. * Max rows retrieved for zoom search
  2503. */
  2504. $cfg['maxRowPlotLimit'] = 500;
  2505. /**
  2506. * Show Git revision if applicable
  2507. *
  2508. * @global boolean $cfg['ShowGitRevision']
  2509. */
  2510. $cfg['ShowGitRevision'] = true;
  2511. /**
  2512. * MySQL minimal version required
  2513. *
  2514. * @global array $cfg['MysqlMinVersion']
  2515. */
  2516. $cfg['MysqlMinVersion'] = [
  2517. 'internal' => 50500,
  2518. 'human' => '5.5.0',
  2519. ];
  2520. /**
  2521. * Disable shortcuts
  2522. *
  2523. * @global array $cfg['DisableShortcutKeys']
  2524. */
  2525. $cfg['DisableShortcutKeys'] = false;
  2526. /**
  2527. * Console configuration
  2528. *
  2529. * This is mostly meant for user preferences.
  2530. */
  2531. $cfg['Console'] = [
  2532. 'StartHistory' => false,
  2533. 'AlwaysExpand' => false,
  2534. 'CurrentQuery' => true,
  2535. 'EnterExecutes' => false,
  2536. 'DarkTheme' => false,
  2537. 'Mode' => 'info',
  2538. 'Height' => 92,
  2539. 'GroupQueries' => false,
  2540. 'OrderBy' => 'exec',
  2541. 'Order' => 'asc',
  2542. ];
  2543. /*******************************************************************************
  2544. * Default options for transformations
  2545. */
  2546. /**
  2547. * Initialize default transformations array
  2548. *
  2549. * @global array $cfg['DefaultTransformations']
  2550. */
  2551. $cfg['DefaultTransformations'] = [];
  2552. /**
  2553. * Default transformations for Substring
  2554. *
  2555. * @global array $cfg['DefaultTransformations']['Substring']
  2556. */
  2557. $cfg['DefaultTransformations']['Substring'] = [
  2558. 0,
  2559. 'all',
  2560. '…',
  2561. ];
  2562. /**
  2563. * Default transformations for Bool2Text
  2564. *
  2565. * @global array $cfg['DefaultTransformations']['Bool2Text']
  2566. */
  2567. $cfg['DefaultTransformations']['Bool2Text'] = [
  2568. 'T',
  2569. 'F',
  2570. ];
  2571. /**
  2572. * Default transformations for External
  2573. *
  2574. * @global array $cfg['DefaultTransformations']['External']
  2575. */
  2576. $cfg['DefaultTransformations']['External'] = [
  2577. 0,
  2578. '-f /dev/null -i -wrap -q',
  2579. 1,
  2580. 1,
  2581. ];
  2582. /**
  2583. * Default transformations for PreApPend
  2584. *
  2585. * @global array $cfg['DefaultTransformations']['PreApPend']
  2586. */
  2587. $cfg['DefaultTransformations']['PreApPend'] = [
  2588. '',
  2589. '',
  2590. ];
  2591. /**
  2592. * Default transformations for Hex
  2593. *
  2594. * @global array $cfg['DefaultTransformations']['Hex']
  2595. */
  2596. $cfg['DefaultTransformations']['Hex'] = ['2'];
  2597. /**
  2598. * Default transformations for DateFormat
  2599. *
  2600. * @global array $cfg['DefaultTransformations']['DateFormat']
  2601. */
  2602. $cfg['DefaultTransformations']['DateFormat'] = [
  2603. 0,
  2604. '',
  2605. 'local',
  2606. ];
  2607. /**
  2608. * Set default for FirstDayOfCalendar
  2609. *
  2610. * @global integer $cfg['FirstDayOfCalendar']
  2611. */
  2612. $cfg['FirstDayOfCalendar'] = 0;
  2613. /**
  2614. * Default transformations for Inline
  2615. *
  2616. * @global array $cfg['DefaultTransformations']['Inline']
  2617. */
  2618. $cfg['DefaultTransformations']['Inline'] = [
  2619. '100',
  2620. 100,
  2621. ];
  2622. $cfg['DefaultTransformations']['Inline']['wrapper_link'] = null;
  2623. $cfg['DefaultTransformations']['Inline']['wrapper_params'] = [];
  2624. /**
  2625. * Default transformations for TextImageLink
  2626. *
  2627. * @global array $cfg['DefaultTransformations']['TextImageLink']
  2628. */
  2629. $cfg['DefaultTransformations']['TextImageLink'] = [
  2630. null,
  2631. 100,
  2632. 50,
  2633. ];
  2634. /**
  2635. * Default transformations for TextLink
  2636. *
  2637. * @global array $cfg['DefaultTransformations']['TextLink']
  2638. */
  2639. $cfg['DefaultTransformations']['TextLink'] = [
  2640. null,
  2641. null,
  2642. null,
  2643. ];