基于PHP的MyAdmin(MySQL数据库管理) 官方版.zip

.. index:: config.inc.php .. _config: Configuration ============= All configurable data is placed in :file:`config.inc.php` in phpMyAdmin's toplevel directory. If this file does not exist, please refer to the :ref:`setup` section to create one. This file only needs to contain the parameters you want to change from their corresponding default value in :file:`libraries/config.default.php` (this file is not intended for changes). .. seealso:: :ref:`config-examples` for examples of configurations If a directive is missing from your file, you can just add another line with the file. This file is for over-writing the defaults; if you wish to use the default value there's no need to add a line here. The parameters which relate to design (like colors) are placed in :file:`themes/themename/scss/_variables.scss`. You might also want to create :file:`config.footer.inc.php` and :file:`config.header.inc.php` files to add your site specific code to be included on start and end of each page. .. note:: Some distributions (eg. Debian or Ubuntu) store :file:`config.inc.php` in ``/etc/phpmyadmin`` instead of within phpMyAdmin sources. Basic settings -------------- .. config:option:: $cfg['PmaAbsoluteUri'] :type: string :default: ``''`` .. versionchanged:: 4.6.5 This setting was not available in phpMyAdmin 4.6.0 - 4.6.4. Sets here the complete :term:`URL` (with full path) to your phpMyAdmin installation's directory. E.g. ``https://www.example.net/path_to_your_phpMyAdmin_directory/``. Note also that the :term:`URL` on most of web servers are case sensitive (even on Windows). Don’t forget the trailing slash at the end. Starting with version 2.3.0, it is advisable to try leaving this blank. In most cases phpMyAdmin automatically detects the proper setting. Users of port forwarding or complex reverse proxy setup might need to set this. A good test is to browse a table, edit a row and save it. There should be an error message if phpMyAdmin is having trouble auto–detecting the correct value. If you get an error that this must be set or if the autodetect code fails to detect your path, please post a bug report on our bug tracker so we can improve the code. .. seealso:: :ref:`faq1_40`, :ref:`faq2_5`, :ref:`faq4_7`, :ref:`faq5_16` .. config:option:: $cfg['PmaNoRelation_DisableWarning'] :type: boolean :default: false Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign – tables (see :config:option:`$cfg['Servers'][$i]['pmadb']`). If you tried to set this up and it does not work for you, have a look on the :guilabel:`Structure` page of one database where you would like to use it. You will find a link that will analyze why those features have been disabled. If you do not want to use those features set this variable to ``true`` to stop this message from appearing. .. config:option:: $cfg['AuthLog'] :type: string :default: ``'auto'`` .. versionadded:: 4.8.0 This is supported since phpMyAdmin 4.8.0. Configure authentication logging destination. Failed (or all, depending on :config:option:`$cfg['AuthLogSuccess']`) authentication attempts will be logged according to this directive: ``auto`` Let phpMyAdmin automatically choose between ``syslog`` and ``php``. ``syslog`` Log using syslog, using AUTH facility, on most systems this ends up in :file:`/var/log/auth.log`. ``php`` Log into PHP error log. ``sapi`` Log into PHP SAPI logging. ``/path/to/file`` Any other value is treated as a filename and log entries are written there. .. note:: When logging to a file, make sure its permissions are correctly set for a web server user, the setup should closely match instructions described in :config:option:`$cfg['TempDir']`: .. config:option:: $cfg['AuthLogSuccess'] :type: boolean :default: false .. versionadded:: 4.8.0 This is supported since phpMyAdmin 4.8.0. Whether to log successful authentication attempts into :config:option:`$cfg['AuthLog']`. .. config:option:: $cfg['SuhosinDisableWarning'] :type: boolean :default: false A warning is displayed on the main page if Suhosin is detected. You can set this parameter to ``true`` to stop this message from appearing. .. config:option:: $cfg['LoginCookieValidityDisableWarning'] :type: boolean :default: false A warning is displayed on the main page if the PHP parameter session.gc_maxlifetime is lower than cookie validity configured in phpMyAdmin. You can set this parameter to ``true`` to stop this message from appearing. .. config:option:: $cfg['ServerLibraryDifference_DisableWarning'] :type: boolean :default: false .. deprecated:: 4.7.0 This setting was removed as the warning has been removed as well. A warning is displayed on the main page if there is a difference between the MySQL library and server version. You can set this parameter to ``true`` to stop this message from appearing. .. config:option:: $cfg['ReservedWordDisableWarning'] :type: boolean :default: false This warning is displayed on the Structure page of a table if one or more column names match with words which are MySQL reserved. If you want to turn off this warning, you can set it to ``true`` and warning will no longer be displayed. .. config:option:: $cfg['TranslationWarningThreshold'] :type: integer :default: 80 Show warning about incomplete translations on certain threshold. .. config:option:: $cfg['SendErrorReports'] :type: string :default: ``'ask'`` Sets the default behavior for JavaScript error reporting. Whenever an error is detected in the JavaScript execution, an error report may be sent to the phpMyAdmin team if the user agrees. The default setting of ``'ask'`` will ask the user everytime there is a new error report. However you can set this parameter to ``'always'`` to send error reports without asking for confirmation or you can set it to ``'never'`` to never send error reports. This directive is available both in the configuration file and in users preferences. If the person in charge of a multi-user installation prefers to disable this feature for all users, a value of ``'never'`` should be set, and the :config:option:`$cfg['UserprefsDisallow']` directive should contain ``'SendErrorReports'`` in one of its array values. .. config:option:: $cfg['ConsoleEnterExecutes'] :type: boolean :default: false Setting this to ``true`` allows the user to execute queries by pressing Enter instead of Ctrl+Enter. A new line can be inserted by pressing Shift + Enter. The behaviour of the console can be temporarily changed using console's settings interface. .. config:option:: $cfg['AllowThirdPartyFraming'] :type: boolean|string :default: false Setting this to ``true`` allows phpMyAdmin to be included inside a frame, and is a potential security hole allowing cross-frame scripting attacks or clickjacking. Setting this to 'sameorigin' prevents phpMyAdmin to be included from another document in a frame, unless that document belongs to the same domain. Server connection settings -------------------------- .. config:option:: $cfg['Servers'] :type: array :default: one server array with settings listed below Since version 1.4.2, phpMyAdmin supports the administration of multiple MySQL servers. Therefore, a :config:option:`$cfg['Servers']`-array has been added which contains the login information for the different servers. The first :config:option:`$cfg['Servers'][$i]['host']` contains the hostname of the first server, the second :config:option:`$cfg['Servers'][$i][