Se connecter / S'enregistrer
Votre question

cherche un fichier config.inc.php pour phpmyadmin 2.8.0.3

Tags :
  • Php
  • Programmation
Dernière réponse : dans Programmation
10 Mai 2006 20:00:59

Bonjour tout le monde,
J'ai installé phpmyadmin sur mon serveur iis 6 mais il y avait pas de fichier config.inc.php dans l'archive Si vous pouvez me donner un fichier config.inc.php ce serait genti.
Merci d'avance ;-)

Autres pages sur : cherche fichier config inc php phpmyadmin

a c 232 L Programmation
10 Mai 2006 23:51:19

Il me semble que le fichier n'est pas nécessaire, il te sert juste à configurer, donc tu n'en as pas besoin.

Si tu en as besoin, c'est à toi de le faire, et faudrait pas prendre la configuration de quelqu'un d'autre je pense.

Pas sûr de ma réponse...
11 Mai 2006 20:29:29

merci de me repondre mais j'ai deja essayer sans congig.inc.php mais il y a un probleme de connection à la base de données mysql.
Donc je cherche un exemple ou un totoriel.
Nicolas
Contenus similaires
a c 232 L Programmation
11 Mai 2006 22:08:09

je t'envoie ça par mail d'ici 2 minutes
12 Mai 2006 00:47:14

Salut,

tu dois avoir ce fichier. Peut-être a-t-il été déplacé dans un dossier dans cette nouvelle version.

Si tu as téléchargé la version CVS, assure toi d'avoir tout prit.
16 Mai 2006 19:34:44

Salut,
Merci de ton e-mail.
Maintenant sa fonctionne.
Et pour info j'ai telechargé le fichier compressé.
;-)
25 Juin 2006 07:45:29

Salut à tous.
Moi aussi je n'ai pas le fichier config.inc.php. Si OmaR_ShaRif avait la gentillesse de me l'envoyer aussi se serai sympa Merci.
25 Juin 2006 12:57:59

Voici un fichier "config.inc", utilisé avec WAMP. Mais, je pense qu'il marchera aussi... Copies/colles ce fichier dans un *.php.

  1. <?php
  2.  
  3.  
  4. /* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! */
  5.  
  6.  
  7. /* $Id: config.default.php,v 2.20.2.1 2005/11/23 10:34:32 nijel Exp $ */
  8.  
  9. // vim: expandtab sw=4 ts=4 sts=4:
  10.  
  11. /**
  12. * phpMyAdmin default configuration, you can copy values from here to your
  13. * config.inc.php
  14. *
  15. * All directives are explained in Documentation.html
  16. */
  17.  
  18.  
  19. /**
  20. * Your phpMyAdmin URL.
  21. *
  22. * Complete the variable below with the full url ie
  23. * http://www.your_web.net/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. $cfg['PmaAbsoluteUri'] = '';
  35.  
  36. /**
  37. * Disable the default warning that is displayed on the DB Details Structure page if
  38. * any of the required Tables for the relationfeatures could not be found
  39. */
  40. $cfg['PmaNoRelation_DisableWarning'] = FALSE;
  41.  
  42. /**
  43. * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
  44. * at least one server configuration uses 'cookie' auth_type, enter here a
  45. * passphrase that will be used by blowfish. The maximum length seems to be 46
  46. * characters.
  47. */
  48. $cfg['blowfish_secret'] = '';
  49.  
  50. /**
  51. * Server(s) configuration
  52. */
  53. $i = 0;
  54. // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
  55. // $cfg['Servers'][0]. You can disable a server config entry by setting host
  56. // to ''. If you want more than one server, just copy following section
  57. // (including $i incrementation) serveral times. There is no need to define
  58. // full server array, just define values you need to change.
  59. $i++;
  60. $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
  61. $cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
  62. $cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
  63. $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
  64. $cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
  65. $cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
  66. // (requires PHP >= 4.3.0)
  67. $cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
  68. // (this user must have read-only
  69. $cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
  70. // and "mysql/db" tables).
  71. // The controluser is also
  72. // used for all relational
  73. // features (pmadb)
  74. $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
  75. $cfg['Servers'][$i]['user'] = 'root'; // MySQL user
  76. $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
  77. // with 'config' auth_type)
  78. $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
  79. // this db is displayed in left frame
  80. // It may also be an array of db-names, where sorting order is relevant.
  81. $cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
  82.  
  83. $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // Database used for Relation, Bookmark and PDF Features
  84. // (see scripts/create_tables.sql)
  85. // - leave blank for no support
  86. // DEFAULT: 'phpmyadmin'
  87. $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; // Bookmark table
  88. // - leave blank for no bookmark support
  89. // DEFAULT: 'pma_bookmark'
  90. $cfg['Servers'][$i]['relation'] = 'pma_relation'; // table to describe the relation between links (see doc)
  91. // - leave blank for no relation-links support
  92. // DEFAULT: 'pma_relation'
  93. $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; // table to describe the display fields
  94. // - leave blank for no display fields support
  95. // DEFAULT: 'pma_table_info'
  96. $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; // table to describe the tables position for the PDF schema
  97. // - leave blank for no PDF schema support
  98. // DEFAULT: 'pma_table_coords'
  99. $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; // table to describe pages of relationpdf
  100. // - leave blank if you don't want to use this
  101. // DEFAULT: 'pma_pdf_pages'
  102. $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; // table to store column information
  103. // - leave blank for no column comments/mime types
  104. // DEFAULT: 'pma_column_info'
  105. $cfg['Servers'][$i]['history'] = 'pma_history'; // table to store SQL history
  106. // - leave blank for no SQL query history
  107. // DEFAULT: 'pma_history'
  108. $cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables
  109. // are up to date. This prevents compatibility
  110. // checks and thereby increases performance.
  111. $cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login
  112. $cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use
  113. = '';
  114. $cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults
  115. = array();
  116.  
  117. // If you have more than one server configured, you can set $cfg['ServerDefault']
  118. // to any one of them to autoconnect to that server when phpMyAdmin is started,
  119. // or set it to 0 to be given a list of servers without logging in
  120. // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
  121. // set to that server.
  122. $cfg['ServerDefault'] = 1; // Default server (0 = no default server)
  123.  
  124. /**
  125. * Other core phpMyAdmin settings
  126. */
  127. $cfg['OBGzip'] = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')
  128. $cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database
  129. $cfg['ForceSLL'] = FALSE; // whether to force using https
  130. $cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)
  131. $cfg['SkipLockedTables'] = FALSE; // mark used tables, make possible to show
  132. // locked tables (since MySQL 3.23.30)
  133. $cfg['ShowSQL'] = TRUE; // show SQL queries as run
  134. $cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users
  135. $cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE'
  136. $cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not
  137. $cfg['LoginCookieValidity'] = 1800; // validity of cookie login (in seconds)
  138. $cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature
  139. // or not
  140. $cfg['IgnoreMultiSubmitErrors'] = FALSE; // if set to true, PMA continues computing multiple-statement queries
  141. // even if one of the queries failed
  142. $cfg['VerboseMultiSubmit'] = TRUE; // if set to true, PMA will show the affected rows of EACH statement on
  143. // multiple-statement queries. See the libraries/import.php file for
  144. // hardcoded defaults on how many queries a statement may contain!
  145. $cfg['AllowArbitraryServer'] = FALSE; // allow login to any user entered server in cookie based auth
  146.  
  147. // Left frame setup
  148. $cfg['LeftFrameLight'] = TRUE; // use a select-based menu and display only the
  149. // current tables in the left frame.
  150. $cfg['LeftFrameDBTree'] = TRUE; // turn the select-based light menu into a tree
  151. $cfg['LeftFrameDBSeparator'] = '_'; // the separator to sub-tree the select-based light menu tree
  152. $cfg['LeftFrameTableSeparator']= '__'; // Which string will be used to generate table prefixes
  153. // to split/nest tables into multiple categories
  154. $cfg['LeftFrameTableLevel'] = '1'; // How many sublevels should be displayed when splitting
  155. // up tables by the above Separator
  156. $cfg['ShowTooltip'] = TRUE; // display table comment as tooltip in left frame
  157. $cfg['ShowTooltipAliasDB'] = FALSE; // if ShowToolTip is enabled, this defines that table/db comments
  158. $cfg['ShowTooltipAliasTB'] = FALSE; // are shown (in the left menu and db_details_structure) instead of
  159. // table/db names. Setting ShowTooltipAliasTB to 'nested' will only
  160. // use the Aliases for nested descriptors, not the table itself.
  161.  
  162. $cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame
  163. $cfg['LeftDisplayServers'] = FALSE; // display server choice at top of left frame
  164. $cfg['DisplayServersList'] = FALSE; // server choice as links
  165.  
  166. // In the main frame, at startup...
  167. $cfg['ShowStats'] = TRUE; // allow to display statistics and space usage in
  168. // the pages about database details and table
  169. // properties
  170. $cfg['ShowPhpInfo'] = FALSE; // information" and "change password" links for
  171. $cfg['ShowChgPassword'] = FALSE; // simple users or not
  172. $cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty)
  173.  
  174. // In browse mode...
  175. $cfg['ShowBlob'] = FALSE; // display blob field contents
  176. $cfg['NavigationBarIconic'] = 'both'; // Use icons instead of text for the navigation bar buttons
  177. // and on right panel top menu (server db table) (TRUE|FALSE|'both')
  178. $cfg['ShowAll'] = FALSE; // allows to display all the rows
  179. $cfg['MaxRows'] = 30; // maximum number of rows to display
  180. $cfg['Order'] = 'ASC'; // default for 'ORDER BY' clause (valid
  181. // values are 'ASC', 'DESC' or 'SMART' -ie
  182. // descending order for fields of type
  183. // TIME, DATE, DATETIME & TIMESTAMP,
  184. // ascending order else-)
  185.  
  186. // In edit mode...
  187. $cfg['ProtectBinary'] = 'blob'; // disallow editing of binary fields
  188. // valid values are:
  189. // FALSE allow editing
  190. // 'blob' allow editing except for BLOB fields
  191. // 'all' disallow editing
  192. $cfg['ShowFunctionFields'] = TRUE; // Display the function fields in edit/insert mode
  193. $cfg['CharEditing'] = 'input';
  194. // Which editor should be used for CHAR/VARCHAR fields:
  195. // input - allows limiting of input length
  196. // textarea - allows newlines in fields
  197. $cfg['InsertRows'] = 2; // How many rows can be inserted at one time
  198.  
  199. $cfg['ForeignKeyDropdownOrder'] = // Sort order for items in a foreign-key dropdown box.
  200. array( 'content-id', 'id-content'); // 'content' is the referenced data, 'id' is the key value.
  201. $cfg['ForeignKeyMaxLimit'] = 100; // A dropdown will be used if fewer items are present
  202.  
  203.  
  204. // For the export features...
  205. $cfg['ZipDump'] = TRUE; // Allow the use of zip/gzip/bzip
  206. $cfg['GZipDump'] = TRUE; // compression for
  207. $cfg['BZipDump'] = TRUE; // dump files
  208. $cfg['CompressOnFly'] = TRUE; // Will compress gzip/bzip2 exports on
  209. // fly without need for much memory.
  210. // If you encounter problems with
  211. // created gzip/bzip2 files disable
  212. // this feature.
  213.  
  214. // Tabs display settings
  215. $cfg['LightTabs'] = FALSE; // use graphically less intense menu tabs
  216. $cfg['PropertiesIconic'] = TRUE; // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')
  217. $cfg['PropertiesNumColumns'] = 1; // How many columns should be used for table display of a database?
  218. // (a value larger than 1 results in some information being hidden)
  219.  
  220. $cfg['DefaultTabServer'] = 'main.php';
  221. // Possible values:
  222. // 'main.php' = the welcome page
  223. // (recommended for multiuser setups)
  224. // 'server_databases.php' = list of databases
  225. // 'server_status.php' = runtime information
  226. // 'server_variables.php' = MySQL server variables
  227. // 'server_privileges.php' = user management
  228. // 'server_processlist.php' = process list
  229. $cfg['DefaultTabDatabase'] = 'db_details_structure.php';
  230. // Possible values:
  231. // 'db_details_structure.php' = tables list
  232. // 'db_details.php' = sql form
  233. // 'db_search.php' = search query
  234. // 'db_operations.php' = operations on database
  235. $cfg['DefaultTabTable'] = 'tbl_properties_structure.php';
  236. // Possible values:
  237. // 'tbl_properties_structure.php' = fields list
  238. // 'tbl_properties.php' = sql form
  239. // 'tbl_select.php = select page
  240. // 'tbl_change.php = insert row page
  241.  
  242. /**
  243. * Export defaults
  244. */
  245.  
  246. $cfg['Export']['format'] = 'sql'; // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword
  247. $cfg['Export']['compression'] = 'none'; // none/zip/gzip/bzip2
  248.  
  249. $cfg['Export']['asfile'] = FALSE;
  250. $cfg['Export']['charset'] = '';
  251. $cfg['Export']['onserver'] = FALSE;
  252. $cfg['Export']['onserver_overwrite'] = FALSE;
  253. $cfg['Export']['remember_file_template'] = TRUE;
  254. $cfg['Export']['file_template_table'] = '__TABLE__';
  255. $cfg['Export']['file_template_database'] = '__DB__';
  256. $cfg['Export']['file_template_server'] = '__SERVER__';
  257.  
  258. $cfg['Export']['htmlexcel_columns'] = FALSE;
  259. $cfg['Export']['htmlexcel_null'] = 'NULL';
  260.  
  261. $cfg['Export']['htmlword_structure'] = TRUE;
  262. $cfg['Export']['htmlword_data'] = TRUE;
  263. $cfg['Export']['htmlword_columns'] = FALSE;
  264. $cfg['Export']['htmlword_null'] = 'NULL';
  265.  
  266. $cfg['Export']['xls_columns'] = FALSE;
  267. $cfg['Export']['xls_null'] = 'NULL';
  268.  
  269. $cfg['Export']['csv_columns'] = FALSE;
  270. $cfg['Export']['csv_null'] = 'NULL';
  271. $cfg['Export']['csv_separator'] = ';';
  272. $cfg['Export']['csv_enclosed'] = '"';
  273. $cfg['Export']['csv_escaped'] = '\\';
  274. $cfg['Export']['csv_terminated'] = 'AUTO';
  275. $cfg['Export']['excel_columns'] = FALSE;
  276. $cfg['Export']['excel_null'] = 'NULL';
  277. $cfg['Export']['excel_edition'] = 'win'; // win/mac
  278.  
  279. $cfg['Export']['latex_structure'] = TRUE;
  280. $cfg['Export']['latex_data'] = TRUE;
  281. $cfg['Export']['latex_columns'] = TRUE;
  282. $cfg['Export']['latex_relation'] = TRUE;
  283. $cfg['Export']['latex_comments'] = TRUE;
  284. $cfg['Export']['latex_mime'] = TRUE;
  285. $cfg['Export']['latex_null'] = '\textit{NULL}';
  286. $cfg['Export']['latex_caption'] = TRUE;
  287. $cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data';
  288. $cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';
  289.  
  290. $cfg['Export']['sql_structure'] = TRUE;
  291. $cfg['Export']['sql_data'] = TRUE;
  292. $cfg['Export']['sql_compat'] = 'NONE';
  293. $cfg['Export']['sql_disable_fk'] = FALSE;
  294. $cfg['Export']['sql_use_transaction'] = FALSE;
  295. $cfg['Export']['sql_drop_database'] = FALSE;
  296. $cfg['Export']['sql_drop_table'] = FALSE;
  297. $cfg['Export']['sql_if_not_exists'] = FALSE;
  298. $cfg['Export']['sql_auto_increment'] = TRUE;
  299. $cfg['Export']['sql_backquotes'] = TRUE;
  300. $cfg['Export']['sql_dates'] = FALSE;
  301. $cfg['Export']['sql_relation'] = FALSE;
  302. $cfg['Export']['sql_columns'] = FALSE;
  303. $cfg['Export']['sql_delayed'] = FALSE;
  304. $cfg['Export']['sql_ignore'] = FALSE;
  305. $cfg['Export']['sql_hex_for_binary'] = TRUE;
  306. $cfg['Export']['sql_type'] = 'insert'; // insert/update/replace
  307. $cfg['Export']['sql_extended'] = FALSE;
  308. $cfg['Export']['sql_max_query_size'] = 50000;
  309. $cfg['Export']['sql_comments'] = FALSE;
  310. $cfg['Export']['sql_mime'] = FALSE;
  311. $cfg['Export']['sql_header_comment'] = ''; // \n is replaced by new line
  312.  
  313. /**
  314. * Import defaults
  315. */
  316. $cfg['Import']['format'] = 'sql';
  317. $cfg['Import']['allow_interrupt'] = TRUE;
  318. $cfg['Import']['skip_queries'] = '0';
  319. $cfg['Import']['csv_replace'] = FALSE;
  320. $cfg['Import']['csv_terminated'] = ';';
  321. $cfg['Import']['csv_enclosed'] = '"';
  322. $cfg['Import']['csv_escaped'] = '\\';
  323. $cfg['Import']['csv_new_line'] = 'auto';
  324. $cfg['Import']['csv_columns'] = '';
  325. $cfg['Import']['ldi_replace'] = FALSE;
  326. $cfg['Import']['ldi_terminated'] = ';';
  327. $cfg['Import']['ldi_enclosed'] = '"';
  328. $cfg['Import']['ldi_escaped'] = '\\';
  329. $cfg['Import']['ldi_new_line'] = 'auto';
  330. $cfg['Import']['ldi_columns'] = '';
  331. $cfg['Import']['ldi_local_option'] = 'auto'; // 'auto' for autodetection, TRUE or FALSE for forcing
  332.  
  333.  
  334. /**
  335. * Link to the official MySQL documentation.
  336. * Be sure to include no trailing slash on the path.
  337. * See http://dev.mysql.com/doc/ for more information
  338. * about MySQL manuals and their types.
  339. */
  340. $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';
  341.  
  342. /**
  343. * Type of MySQL documentation:
  344. * viewable - "viewable online", current one used on MySQL website
  345. * searchable - "Searchable, with user comments"
  346. * chapters - "HTML, one page per chapter"
  347. * chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release
  348. * big - "HTML, all on one page"
  349. * old - old style used in phpMyAdmin 2.3.0 and sooner
  350. * none - do not show documentation links
  351. */
  352. $cfg['MySQLManualType'] = 'viewable';
  353.  
  354.  
  355. /**
  356. * PDF options
  357. */
  358. $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
  359. $cfg['PDFDefaultPageSize'] = 'A4';
  360.  
  361.  
  362. /**
  363. * Language and charset conversion settings
  364. */
  365. // Default language to use, if not browser-defined or user-defined
  366. $cfg['DefaultLang'] = 'en-iso-8859-1';
  367.  
  368. // Force: always use this language - must be defined in
  369. // libraries/select_lang.lib.php
  370. // $cfg['Lang'] = 'en-iso-8859-1';
  371.  
  372. // Regullar expression to limit listed languages, eg. '^(cs|en)' for Czech and
  373. // English only
  374. $cfg['FilterLanguages'] = '';
  375.  
  376. // Default charset to use for recoding of MySQL queries, does not take
  377. // any effect when charsets recoding is switched off by
  378. // $cfg['AllowAnywhereRecoding'] or in language file
  379. // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
  380. $cfg['DefaultCharset'] = 'iso-8859-1';
  381.  
  382. // Allow charset recoding of MySQL queries, must be also enabled in language
  383. // file to make harder using other language files than unicode.
  384. // Default value is FALSE to avoid problems on servers without the iconv
  385. // extension and where dl() is not supported
  386. $cfg['AllowAnywhereRecoding'] = FALSE;
  387.  
  388. // You can select here which functions will be used for charset conversion.
  389. // Possible values are:
  390. // auto - automatically use available one (first is tested iconv, then
  391. // recode)
  392. // iconv - use iconv or libiconv functions
  393. // recode - use recode_string function
  394. $cfg['RecodingEngine'] = 'auto';
  395.  
  396. // Specify some parameters for iconv used in charset conversion. See iconv
  397. // documentation for details:
  398. // http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
  399. $cfg['IconvExtraParams'] = '';
  400.  
  401. // Available charsets for MySQL conversion. currently contains all which could
  402. // be found in lang/* files and few more.
  403. // Charsets will be shown in same order as here listed, so if you frequently
  404. // use some of these move them to the top.
  405. $cfg['AvailableCharsets'] = array(
  406. 'iso-8859-1',
  407. 'iso-8859-2',
  408. 'iso-8859-3',
  409. 'iso-8859-4',
  410. 'iso-8859-5',
  411. 'iso-8859-6',
  412. 'iso-8859-7',
  413. 'iso-8859-8',
  414. 'iso-8859-9',
  415. 'iso-8859-10',
  416. 'iso-8859-11',
  417. 'iso-8859-12',
  418. 'iso-8859-13',
  419. 'iso-8859-14',
  420. 'iso-8859-15',
  421. 'windows-1250',
  422. 'windows-1251',
  423. 'windows-1252',
  424. 'windows-1256',
  425. 'windows-1257',
  426. 'koi8-r',
  427. 'big5',
  428. 'gb2312',
  429. 'utf-16',
  430. 'utf-8',
  431. 'utf-7',
  432. 'x-user-defined',
  433. 'euc-jp',
  434. 'ks_c_5601-1987',
  435. 'tis-620',
  436. 'SHIFT_JIS'
  437. );
  438.  
  439. /**
  440. * Customization & design
  441. *
  442. * The graphical settings are now located in themes/themename/layout.inc.php
  443. */
  444.  
  445. $cfg['LeftPointerEnable'] = TRUE; // enable the left panel pointer
  446. // (used when LeftFrameLight is FALSE)
  447. // see also LeftPointerColor
  448. // in layout.inc.php
  449.  
  450. $cfg['BrowsePointerEnable'] = TRUE; // enable the browse pointer
  451. // see also BrowsePointerColor
  452. // in layout.inc.php
  453.  
  454. $cfg['BrowseMarkerEnable'] = TRUE; // enable the browse marker
  455. // see also BrowseMarkerColor
  456. // in layout.inc.php
  457.  
  458. $cfg['TextareaCols'] = 40; // textarea size (columns) in edit mode
  459. // (this value will be emphasized (*2) for sql
  460. // query textareas and (*1.25) for query window)
  461. $cfg['TextareaRows'] = 7; // textarea size (rows) in edit mode
  462. $cfg['LongtextDoubleTextarea'] = TRUE; // double size of textarea size for longtext fields
  463. $cfg['TextareaAutoSelect'] = TRUE; // autoselect when clicking in the textarea of the querybox
  464. $cfg['CharTextareaCols'] = 40; // textarea size (columns) for CHAR/VARCHAR
  465. $cfg['CharTextareaRows'] = 2; // textarea size (rows) for CHAR/VARCHAR
  466. $cfg['CtrlArrowsMoving'] = TRUE; // Enable Ctrl+Arrows moving between fields when editing?
  467. $cfg['LimitChars'] = 50; // Max field data length in browse mode for all non-numeric fields
  468. $cfg['ModifyDeleteAtLeft'] = TRUE; // show edit/delete links on left side of browse
  469. // (or at the top with vertical browse)
  470. $cfg['ModifyDeleteAtRight'] = FALSE; // show edit/delete links on right side of browse
  471. // (or at the bottom with vertical browse)
  472. $cfg['DefaultDisplay'] = 'horizontal'; // default display direction
  473. // (horizontal|vertical|horizontalflipped)
  474. $cfg['DefaultPropDisplay'] = 'horizontal'; // default display direction for altering/
  475. // creating columns (tbl_properties)
  476. // (horizontal|vertical)
  477.  
  478. $cfg['HeaderFlipType'] = 'css'; // table-header rotation via faking or css? (css|fake)
  479. // NOTE: CSS only works in IE browsers!
  480. $cfg['ShowBrowseComments'] = TRUE; // shows stored relation-comments in 'browse' mode.
  481. $cfg['ShowPropertyComments']= TRUE; // shows stored relation-comments in 'table property' mode.
  482. $cfg['RepeatCells'] = 100; // repeat header names every X cells? (0 = deactivate)
  483.  
  484. $cfg['EditInWindow'] = TRUE; // Set to TRUE if Edit link should open the query to edit in the query window (assuming Javascript is enabled), and to FALSE if we should edit in the right panel
  485. $cfg['QueryWindowWidth'] = 550; // Width of Query window
  486. $cfg['QueryWindowHeight'] = 310; // Height of Query window
  487. $cfg['QueryHistoryDB'] = FALSE; // Set to TRUE if you want DB-based query history.
  488. // If FALSE, this utilizes JS-routines to display
  489. // query history (lost by window close)
  490. $cfg['QueryWindowDefTab'] = 'sql'; // which tab to display in the querywindow on startup
  491. // (sql|files|history|full)
  492. $cfg['QueryHistoryMax'] = 25; // When using DB-based query history, how many entries
  493. // should be kept?
  494. $cfg['BrowseMIME'] = TRUE; // Use MIME-Types (stored in column comments table) for
  495. $cfg['MaxExactCount'] = 20000; // When approximate count < this, PMA will get exact count for
  496. // table rows.
  497. $cfg['WYSIWYG-PDF'] = TRUE; // Utilize DHTML/JS capabilities to allow WYSIWYG editing of
  498. // the PDF page editor. Requires an IE6/Mozilla based browser.
  499.  
  500. $cfg['NaturalOrder'] = TRUE; // Sort table and database in natural order
  501.  
  502.  
  503. //-----------------------------------------------------------------------------
  504. // custom-setup by mkkeck: 2004-05-04
  505. // some specials for new icons and scrollings
  506. // FIXME:
  507. // 2004-05-08 rabus: We need to rearrange these variables.
  508.  
  509. $cfg['ShowHttpHostTitle'] = TRUE; // show HttpHost in browsers window title (true|false)?
  510. $cfg['SetHttpHostTitle'] = ''; // if ShowHttpHostTitle=true, please set your host (server)
  511. // or an other string, wich should be shown in browsers window title.
  512. // If not set (or empty), the PMA will get your real Host-Adress.
  513.  
  514. $cfg['ErrorIconic'] = TRUE; // show some icons for warning, error and information messages (true|false)?
  515. $cfg['MainPageIconic'] = TRUE; // show icons in list on main page and on menu tabs (true|false)?
  516. $cfg['ReplaceHelpImg'] = TRUE; // show help button instead of strDocu (true|false)?
  517.  
  518. // theme manager
  519. $cfg['ThemePath'] = './themes'; // using themes manager please set up here the path to 'themes'
  520. // else leave empty
  521. $cfg['ThemeManager'] = TRUE; // if you want to use selectable themes and if ThemesPath not empty
  522. // set it to true, else set it to false (default is false);
  523. $cfg['ThemeDefault'] = 'original'; // set up default theme, if ThemePath not empty
  524. // you can set up here an valid path to themes or 'original' for
  525. // the original pma-theme
  526. $cfg['ThemePerServer'] = FALSE; // allow diferent theme for each configured server
  527.  
  528. //-----------------------------------------------------------------------------
  529.  
  530.  
  531. /**
  532. * Default queries
  533. * %d will be replaced by the database name.
  534. * %t will be replaced by the table name.
  535. * %f will be replaced by a list of field names.
  536. * (%t and %f only applies to DefaultQueryTable)
  537. */
  538. $cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';
  539. $cfg['DefaultQueryDatabase'] = '';
  540.  
  541. /**
  542. * SQL Query box settings
  543. * These are the links display in all of the SQL Query boxes
  544. */
  545. $cfg['SQLQuery']['Edit'] = TRUE; // Edit link to change a query
  546. $cfg['SQLQuery']['Explain'] = TRUE; // EXPLAIN on SELECT queries
  547. $cfg['SQLQuery']['ShowAsPHP'] = TRUE; // Wrap a query in PHP
  548. $cfg['SQLQuery']['Validate'] = FALSE; // Validate a query (see $cfg['SQLValidator'] as well)
  549. $cfg['SQLQuery']['Refresh'] = TRUE; // Refresh the results page
  550.  
  551.  
  552. /**
  553. * Webserver upload/save/import directories
  554. */
  555. $cfg['UploadDir'] = ''; // Directory for uploaded files that can be executed by
  556. // phpMyAdmin. For example './upload'. Leave empty for
  557. // no upload directory support. Use %u for username
  558. // inclusion.
  559. $cfg['SaveDir'] = ''; // Directory where phpMyAdmin can save exported data on
  560. // server. For example './save'. Leave empty for no save
  561. // directory support. Use %u for username inclusion.
  562. $cfg['docSQLDir'] = ''; // Directory for docSQL imports, phpMyAdmin can import
  563. // docSQL files from that directory. For example
  564. // './docSQL'. Leave empty for no docSQL import support.
  565. $cfg['TempDir'] = ''; // Directory where phpMyAdmin can save temporary files.
  566. // This is needed for MS Excel export, see documentation
  567. // how to enable that.
  568.  
  569.  
  570. /**
  571. * Misc. settings
  572. */
  573. $cfg['GD2Available'] = 'auto'; // Is GD >= 2 available? Set to yes/no/auto. 'auto'
  574. // does autodetection, which is a bit expensive for
  575. // php < 4.3.0, but it is the only safe vay how to
  576. // determine GD version.
  577. /**
  578. * SQL Parser Settings
  579. */
  580. $cfg['SQP']['fmtType'] = 'html'; // Pretty-printing style to use on queries (html, text, none)
  581. $cfg['SQP']['fmtInd'] = '1'; // Amount to indent each level (floats ok)
  582. $cfg['SQP']['fmtIndUnit'] = 'em'; // Units for indenting each level (CSS Types - {em,px,pt})
  583. // The graphical settings are now located in themes/themename/layout.inc.php
  584.  
  585. /**
  586. * If you wish to use the SQL Validator service, you should be
  587. * aware of the following:
  588. * All SQL statements are stored anonymously for statistical purposes.
  589. * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
  590. * All rights reserved.
  591. */
  592. $cfg['SQLValidator']['use'] = FALSE; // Make the SQL Validator available
  593. $cfg['SQLValidator']['username'] = ''; // If you have a custom username, specify it here (defaults to anonymous)
  594. $cfg['SQLValidator']['password'] = ''; // Password for username
  595.  
  596. /**
  597. * Developers ONLY!
  598. * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
  599. */
  600. $cfg['DBG']['enable'] = FALSE; // Make the DBG stuff available
  601. $cfg['DBG']['profile']['enable'] = FALSE; // Produce profiling results of PHP
  602. $cfg['DBG']['profile']['threshold'] = 0.5; // Threshold of long running code to display
  603. // Anything below the threshold is not displayed
  604.  
  605.  
  606. /**
  607. * MySQL settings
  608. */
  609. // Column types;
  610. // varchar, tinyint, text and date are listed first, based on estimated popularity
  611. $cfg['ColumnTypes'] = array(
  612. 'VARCHAR',
  613. 'TINYINT',
  614. 'TEXT',
  615. 'DATE',
  616. 'SMALLINT',
  617. 'MEDIUMINT',
  618. 'INT',
  619. 'BIGINT',
  620. 'FLOAT',
  621. 'DOUBLE',
  622. 'DECIMAL',
  623. 'DATETIME',
  624. 'TIMESTAMP',
  625. 'TIME',
  626. 'YEAR',
  627. 'CHAR',
  628. 'TINYBLOB',
  629. 'TINYTEXT',
  630. 'BLOB',
  631. 'MEDIUMBLOB',
  632. 'MEDIUMTEXT',
  633. 'LONGBLOB',
  634. 'LONGTEXT',
  635. 'ENUM',
  636. 'SET',
  637. 'BOOL'
  638. );
  639.  
  640. // Attributes
  641. // Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically
  642. // for MySQL >= 4.1.2, in tbl_properties.inc.php
  643.  
  644. $cfg['AttributeTypes'] = array(
  645. '',
  646. 'BINARY',
  647. 'UNSIGNED',
  648. 'UNSIGNED ZEROFILL'
  649. );
  650.  
  651. // Available functions
  652. if ($cfg['ShowFunctionFields']) {
  653. $cfg['Functions'] = array(
  654. 'ASCII',
  655. 'CHAR',
  656. 'SOUNDEX',
  657. 'LCASE',
  658. 'UCASE',
  659. 'NOW',
  660. 'PASSWORD',
  661. 'OLD_PASSWORD',
  662. 'MD5',
  663. 'SHA1',
  664. 'ENCRYPT',
  665. 'COMPRESS',
  666. 'UNCOMPRESS',
  667. 'RAND',
  668. 'LAST_INSERT_ID',
  669. 'COUNT',
  670. 'AVG',
  671. 'SUM',
  672. 'CURDATE',
  673. 'CURTIME',
  674. 'FROM_DAYS',
  675. 'FROM_UNIXTIME',
  676. 'PERIOD_ADD',
  677. 'PERIOD_DIFF',
  678. 'TO_DAYS',
  679. 'UNIX_TIMESTAMP',
  680. 'USER',
  681. 'WEEKDAY',
  682. 'CONCAT'
  683. );
  684.  
  685. // Which column types will be mapped to which Group?
  686. $cfg['RestrictColumnTypes'] = array(
  687. 'VARCHAR' => 'FUNC_CHAR',
  688. 'TINYINT' => 'FUNC_NUMBER',
  689. 'TEXT' => 'FUNC_CHAR',
  690. 'DATE' => 'FUNC_DATE',
  691. 'SMALLINT' => 'FUNC_NUMBER',
  692. 'MEDIUMINT' => 'FUNC_NUMBER',
  693. 'INT' => 'FUNC_NUMBER',
  694. 'BIGINT' => 'FUNC_NUMBER',
  695. 'FLOAT' => 'FUNC_NUMBER',
  696. 'DOUBLE' => 'FUNC_NUMBER',
  697. 'DECIMAL' => 'FUNC_NUMBER',
  698. 'DATETIME' => 'FUNC_DATE',
  699. 'TIMESTAMP' => 'FUNC_DATE',
  700. 'TIME' => 'FUNC_DATE',
  701. 'YEAR' => 'FUNC_DATE',
  702. 'CHAR' => 'FUNC_CHAR',
  703. 'TINYBLOB' => 'FUNC_CHAR',
  704. 'TINYTEXT' => 'FUNC_CHAR',
  705. 'BLOB' => 'FUNC_CHAR',
  706. 'MEDIUMBLOB' => 'FUNC_CHAR',
  707. 'MEDIUMTEXT' => 'FUNC_CHAR',
  708. 'LONGBLOB' => 'FUNC_CHAR',
  709. 'LONGTEXT' => 'FUNC_CHAR',
  710. 'ENUM' => '',
  711. 'SET' => ''
  712. );
  713.  
  714. // Map above defined groups to any function
  715. $cfg['RestrictFunctions'] = array(
  716. 'FUNC_CHAR' => array(
  717. 'ASCII',
  718. 'CHAR',
  719. 'SOUNDEX',
  720. 'LCASE',
  721. 'UCASE',
  722. 'PASSWORD',
  723. 'OLD_PASSWORD',
  724. 'MD5',
  725. 'SHA1',
  726. 'ENCRYPT',
  727. 'COMPRESS',
  728. 'UNCOMPRESS',
  729. 'LAST_INSERT_ID',
  730. 'USER',
  731. 'CONCAT'
  732. ),
  733.  
  734. 'FUNC_DATE' => array(
  735. 'NOW',
  736. 'CURDATE',
  737. 'CURTIME',
  738. 'FROM_DAYS',
  739. 'FROM_UNIXTIME',
  740. 'PERIOD_ADD',
  741. 'PERIOD_DIFF',
  742. 'TO_DAYS',
  743. 'UNIX_TIMESTAMP',
  744. 'WEEKDAY'
  745. ),
  746.  
  747. 'FUNC_NUMBER' => array(
  748. 'ASCII',
  749. 'CHAR',
  750. 'MD5',
  751. 'SHA1',
  752. 'ENCRYPT',
  753. 'RAND',
  754. 'LAST_INSERT_ID',
  755. 'UNIX_TIMESTAMP',
  756. 'COUNT',
  757. 'AVG',
  758. 'SUM'
  759. )
  760. );
  761.  
  762. // Default functions for above defined groups
  763. $cfg['DefaultFunctions'] = array(
  764. 'FUNC_CHAR' => '',
  765. 'FUNC_DATE' => '',
  766. 'FUNC_NUMBER' => '',
  767. 'first_timestamp' => 'NOW'
  768. );
  769.  
  770.  
  771. } // end if
  772.  
  773. // Search operators
  774. $cfg['NumOperators'] = array(
  775. '=',
  776. '>',
  777. '>=',
  778. '<',
  779. '<=',
  780. '!=',
  781. 'LIKE',
  782. 'NOT LIKE'
  783. );
  784.  
  785. $cfg['TextOperators'] = array(
  786. 'LIKE',
  787. 'LIKE %...%',
  788. 'NOT LIKE',
  789. '=',
  790. '!=',
  791. 'REGEXP',
  792. 'NOT REGEXP'
  793. );
  794.  
  795. $cfg['EnumOperators'] = array(
  796. '=',
  797. '!='
  798. );
  799.  
  800. $cfg['SetOperators'] = array(
  801. 'IN',
  802. 'NOT IN'
  803. );
  804.  
  805. $cfg['NullOperators'] = array(
  806. 'IS NULL',
  807. 'IS NOT NULL'
  808. );
  809.  
  810. $cfg['UnaryOperators'] = array(
  811. 'IS NULL' => 1,
  812. 'IS NOT NULL' => 1
  813. );
  814.  
  815. ?>
26 Juin 2006 02:52:32

Je vais essayé merci
12 Septembre 2006 14:22:49

Bonjours, serait-il possible de recevoir le fichier par mail svp.
12 Septembre 2006 16:09:34

Salut....

Je crois que sur cette version de phpMyAdmin, il y a un utilitaire de création de ce fameux config.inc.php ....(Je l'ai essayé...Personnellement je ne l'ai pas trouvé très très compréhensible)
Tom's guide dans le monde
  • Allemagne
  • Italie
  • Irlande
  • Royaume Uni
  • Etats Unis
Suivre Tom's Guide
Inscrivez-vous à la Newsletter
  • ajouter à twitter
  • ajouter à facebook
  • ajouter un flux RSS