pmaexporttemplates End of servers configuration

Pmaexporttemplates end of servers configuration

This preview shows page 88 - 91 out of 196 pages.

// $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates'; / ** * End of servers configuration * / / ** * Directories for saving/loading files from server * / $cfg [ 'UploadDir' ] = '' ; $cfg [ 'SaveDir' ] = '' ; / ** * Whether to display icons or text or both icons and text in table row * action segment. Value can be either of 'icons', 'text' or 'both'. * default = 'both' * / //$cfg['RowActionType'] = 'icons'; / ** * Defines whether a user should be displayed a "show all (records)" * button in browse mode or not. * default = false * / //$cfg['ShowAll'] = true; / ** * Number of rows displayed when browsing a result set. If the result * set contains more rows, "Previous" and "Next". * Possible values: 25, 50, 100, 250, 500 82 Capítulo 4. Configuración
phpMyAdmin Documentation, Versión 4.8.0-dev * default = 25 * / //$cfg['MaxRows'] = 50; / ** * Disallow editing of binary fields * valid values are: * false allow editing * 'blob' allow editing except for BLOB fields * 'noblob' disallow editing except for BLOB fields * 'all' disallow editing * default = 'blob' * / //$cfg['ProtectBinary'] = false; / ** * Default language to use, if not browser-defined or user-defined * (you find all languages in the locale folder) * uncomment the desired line: * default = 'en' * / //$cfg['DefaultLang'] = 'en'; //$cfg['DefaultLang'] = 'de'; / ** * How many columns should be used for table display of a database? * (a value larger than 1 results in some information being hidden) * default = 1 * / //$cfg['PropertiesNumColumns'] = 2; / ** * Set to true if you want DB-based query history.If false, this utilizes * JS-routines to display query history (lost by window close) * * This requires configuration storage enabled, see above. * default = false * / //$cfg['QueryHistoryDB'] = true; / ** * When using DB-based query history, how many entries should be kept? * default = 25 * / //$cfg['QueryHistoryMax'] = 100; / ** * Whether or not to query the user before sending the error report to * the phpMyAdmin team when a JavaScript error occurs * * Available options * ('ask' | 'always' | 'never') * default = 'ask' * / //$cfg['SendErrorReports'] = 'always'; / ** * You can find more configuration options in the documentation 4.28. Examples 83
phpMyAdmin Documentation, Versión 4.8.0-dev * in the doc/ folder or at <;. * / Advertencia: Don’t use the controluser “pma” if it does not yet exist and don’t use “pmapass” as password. 4.28.2 Example for signon authentication This example uses examples/signon.php to demonstrate usage of Método de autenticación «signon» : <? php $i = 0 ; $i ++ ; $cfg [ 'Servers' ][ $i ][ 'extension' ] = 'mysqli' ; $cfg [ 'Servers' ][ $i ][ 'auth_type' ] = 'signon' ; $cfg [ 'Servers' ][ $i ][ 'SignonSession' ] = 'SignonSession' ; $cfg [ 'Servers' ][ $i ][ 'SignonURL' ] = 'examples/signon.php' ; ?> ` 4.28.3 Example for IP address limited autologin If you want to automatically login when accessing phpMyAdmin locally while asking for a password when accessing remotely, you can achieve it using following snippet: if ( $_SERVER [ "REMOTE_ADDR" ] == "127.0.0.1" ) { $cfg [ 'Servers' ][ $i ][ 'auth_type' ] = 'config' ; $cfg [ 'Servers' ][ $i ][ 'user' ] = 'root' ; $cfg [ 'Servers' ][ $i ][ 'password' ] = 'yourpassword' ; } else { $cfg [ 'Servers' ][ $i ][ 'auth_type' ] = 'cookie' ; } Nota: Filtering based on IP addresses isn’t reliable over the internet, use it only for local address.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture