.. index:: config.inc.php
.. _config:
Configuration
=============
Almost all configurable data is placed in :file:`config.inc.php`. 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`.
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/layout.inc.php`. 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.
.. warning::
:term:`Mac` users should note that if you are on a version before
:term:`Mac OS X`, PHP does not seem to
like :term:`Mac` end of lines character (``\r``). So
ensure you choose the option that allows to use the \*nix end of line
character (``\n``) in your text editor before saving a script you have
modified.
Basic settings
--------------
.. config:option:: $cfg['PmaAbsoluteUri']
:type: string
:default: ``''``
Sets here the complete :term:`URL` (with full path) to your phpMyAdmin
installation's directory. E.g.
``http://www.example.net/path_to_your_phpMyAdmin_directory/``. Note also
that the :term:`URL` on most of web servers are case–sensitive. 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 will need to set :config:option:`$cfg['PmaAbsoluteUri']`
(`more info <https://sourceforge.net/p/phpmyadmin/support-requests/795/>`_).
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`
.. 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['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
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['AllowThirdPartyFraming']
:type: boolean
: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.
Server connection settings
--------------------------
.. config:option:: $cfg['Servers']
:type: array
:default: one server array with settings listed bellow
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]['host']`
the hostname of the second server, etc. In
:file:`libraries/config.default.php`, there is only one section for server
definition, however you can put as many as you need in
:file:`config.inc.php`, copy that block or needed parts (you don't have to
define all settings, just those you need to change).
.. note::
The :config:option:`$cfg['Servers']` array starts with
$cfg['Servers'][1]. Do not use $cfg['Servers'][0]. If you want more
than one server, just copy following section (including $i
incrementation) serveral times. There is no need to define full server
array, just define values you need to change.
.. config:option:: $cfg['Servers'][$i]['host']
:type: string
:default: ``'localhost'``
The hostname or :term:`IP` address of your $i-th MySQL-server. E.g.
``localhost``.
Possible values are:
* hostname, e.g., ``'localhost'`` or ``'mydb.example.org'``
* IP address, e.g., ``'127.0.0.1'`` or ``'192.168.10.1'``
* dot - ``'.'``, i.e., use named pipes on windows systems
* empty - ``''``, disables this server
.. note::
phpMyAdmin supports connecting to MySQL servers reachable via IPv6 only.
To connect to an IPv6 MySQL server, enter its IPv6 address in this field.
.. config:option:: $cfg['Servers'][$i]['port']
:type: string
:default: ``''``
The port-number of your $i-th MySQL-server. Default is 3306 (leave
blank).
.. note::
If you use ``localhost`` as the hostname, MySQL ignores this port number
and connects with the socket, so if you want to connect to a port
different from the default port, use ``127.0.0.1`` or the real hostname
in :config:option:`$
没有合适的资源?快使用搜索试试~ 我知道了~
基于PHP的MyAdminFinal多国语言绿色免费通过互联网来控制操作MySQL源码.zip
共135个文件
php:33个
html:18个
txt:16个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 133 浏览量
2023-08-27
23:51:11
上传
评论
收藏 1.05MB ZIP 举报
温馨提示
基于PHP的MyAdminFinal多国语言绿色免费通过互联网来控制操作MySQL源码.zip
资源推荐
资源详情
资源评论
收起资源包目录
基于PHP的MyAdminFinal多国语言绿色免费通过互联网来控制操作MySQL源码.zip (135个子文件)
make.bat 6KB
.buildinfo 230B
ChangeLog 19KB
swekey.sample.conf 2KB
basic.css 8KB
default.css 4KB
pygments.css 4KB
DCO 2KB
config.doctree 772KB
faq.doctree 542KB
setup.doctree 158KB
credits.doctree 122KB
glossary.doctree 91KB
transformations.doctree 30KB
intro.doctree 23KB
require.doctree 14KB
privileges.doctree 11KB
copyright.doctree 8KB
vendors.doctree 8KB
index.doctree 6KB
import_export.doctree 5KB
other.doctree 5KB
developers.doctree 4KB
user.doctree 3KB
ajax-loader.gif 673B
config.html 258KB
faq.html 184KB
genindex.html 119KB
setup.html 75KB
glossary.html 31KB
credits.html 23KB
transformations.html 12KB
index.html 12KB
intro.html 10KB
privileges.html 8KB
require.html 7KB
copyright.html 6KB
import_export.html 6KB
vendors.html 6KB
user.html 6KB
other.html 5KB
developers.html 5KB
search.html 3KB
favicon.ico 18KB
objects.inv 10KB
jquery.js 247KB
searchindex.js 51KB
underscore.js 46KB
websupport.js 25KB
searchtools.js 17KB
doctools.js 7KB
sidebar.js 5KB
composer.json 904B
Makefile 7KB
CONTRIBUTING.md 718B
import.php 25KB
index.php 21KB
gis_data_editor.php 15KB
export.php 15KB
db_tracking.php 11KB
db_structure.php 10KB
db_operations.php 9KB
db_datadict.php 6KB
db_designer.php 5KB
changelog.php 5KB
db_printview.php 5KB
db_central_columns.php 4KB
error_report.php 4KB
openid.php 4KB
db_create.php 4KB
config.sample.inc.php 4KB
db_qbe.php 4KB
import_status.php 3KB
db_export.php 3KB
signon.php 2KB
file_echo.php 2KB
config.manyhosts.inc.php 2KB
db_search.php 2KB
browse_foreigners.php 1KB
db_sql.php 925B
signon-script.php 805B
chk_rel.php 591B
db_sql_autocomplete.php 582B
db_import.php 504B
db_routines.php 454B
db_sql_format.php 419B
db_events.php 401B
db_triggers.php 364B
environment.pickle 223KB
comment-close.png 3KB
comment-bright.png 3KB
comment.png 3KB
file.png 392B
up-pressed.png 372B
down-pressed.png 368B
down.png 363B
up.png 363B
plus.png 199B
minus.png 199B
conf.py 9KB
共 135 条
- 1
- 2
资源评论
毕业_设计
- 粉丝: 1936
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功