Basic settings ¶
$cfg['PmaAbsoluteUri']
¶-
Type: string Default value: ''
Changed in version 4.6.5: This setting was not available in phpMyAdmin 4.6.0 - 4.6.4.
Sets here the complete 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 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.
See also
1.40 When accessing phpMyAdmin via an Apache reverse proxy, cookie login does not work., 2.5 Each time I want to insert or change a row or drop a database or a table, an error 404 (page not found) is displayed or, with HTTP or cookie authentication, I'm asked to log in again. What's wrong?, 4.7 Authentication window is displayed more than once, why?, 5.16 With Internet Explorer, I get "Access is denied" Javascript errors. Or I cannot make phpMyAdmin work under Windows.
$cfg['PmaNoRelation_DisableWarning']
¶-
Type: boolean Default value: false Starting with version 2.3.0 phpMyAdmin offers a lot of features to work with master / foreign - tables (see
$cfg['Servers'][$i]['pmadb']
).If you tried to set this up and it does not work for you, have a look on the 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.
$cfg['AuthLog']
¶-
Type: string Default value: 'auto'
New in version 4.8.0: This is supported since phpMyAdmin 4.8.0.
Configure authentication logging destination. Failed (or all, depending on
$cfg['AuthLogSuccess']
) authentication attempts will be logged according to this directive:auto
- Let phpMyAdmin automatically choose between
syslog
andphp
. syslog
- Log using syslog, using AUTH facility, on most systems this ends up in
/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
$cfg['TempDir']
:
$cfg['AuthLogSuccess']
¶-
Type: boolean Default value: false New in version 4.8.0: This is supported since phpMyAdmin 4.8.0.
Whether to log successful authentication attempts into
$cfg['AuthLog']
.
$cfg['SuhosinDisableWarning']
¶-
Type: boolean Default value: 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.
$cfg['LoginCookieValidityDisableWarning']
¶-
Type: boolean Default value: 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.
$cfg['ServerLibraryDifference_DisableWarning']
¶-
Type: boolean Default value: false Deprecated since version 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.
$cfg['ReservedWordDisableWarning']
¶-
Type: boolean Default value: 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.
$cfg['TranslationWarningThreshold']
¶-
Type: integer Default value: 80 Show warning about incomplete translations on certain threshold.
$cfg['SendErrorReports']
¶-
Type: string Default value: '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$cfg['UserprefsDisallow']
directive should contain'SendErrorReports'
in one of its array values.
$cfg['ConsoleEnterExecutes']
¶-
Type: boolean Default value: 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.
$cfg['AllowThirdPartyFraming']
¶-
Type: boolean|string Default value: 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.