.. 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`.
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 some 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['McryptDisableWarning']
:type: boolean
:default: false
Disable the default warning that is displayed if mcrypt is missing for
cookie authentication.
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 not longer be displayed
.. config:option:: $cfg['TranslationWarningThreshold']
:type: integer
:default: 80
Show warning about incomplete translations on certain threshold.
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
.. 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:`$cfg['Servers'][$i]['host']`.
.. config:option:: $cfg['Servers'][$i]['socket']
:type: string
:default: ``''``
The path to the socket to use. Leave blank for default. To determine
the correct socket, check your MySQL configuration or, using the
:command:`mysql` command–line client, issue the ``status`` command. Among the
resulting information displayed will be the socket used.
.. config:option:: $cfg['Servers'][$i]['ssl']
:type: boolean
:default: false
Whether to enable SSL for connection to MySQL server.
.. config:option:: $cfg['Servers'][$i]['connect_type']
:type: string
:default: ``'tcp'``
What type connection to use with the MySQL server. Your options are
``'socket'`` and ``'tcp'``. It defaults to tcp as that is nearly guaranteed
to be available on all MySQL servers, while sockets are not supported on
some platforms. To use the socket mode, your MySQL server must be on the
same machine as the Web server.
.. config:option:: $cfg['Servers'][$i]['extension']
:type: string
:default: ``'mysqli'``
What php MySQL extension to use for the connection. Valid options are:
``mysql``
The classic MySQL extension.
``mysqli``
The improved MySQL extension. This extension became available with PHP
5.0.0 and is the recommended way to connect to a server running MySQL
4.1.x or newer.
.. config:option:: $cfg['Servers'][$i]['compress']
:type: boolean
:default: false
Whether to use a compressed protocol for the MySQL server connection
or no
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
phpMyAdmin 4.0.4 官方中文版 (1113个子文件)
RELEASE-DATE-4.0.4 29B
make.bat 5KB
.buildinfo 230B
ChangeLog 12KB
swekey.sample.conf 2KB
musbe-ca.crt 1KB
jquery-ui-1.9.2.custom.css 32KB
jquery-ui-1.9.2.custom.css 32KB
styles.css 11KB
basic.css 8KB
style.css 8KB
default.css 4KB
pygments.css 4KB
print.css 1KB
ie6-style.css 165B
google.css 143B
framedCloud.css 0B
config.doctree 914KB
faq.doctree 581KB
credits.doctree 132KB
setup.doctree 129KB
glossary.doctree 117KB
transformations.doctree 33KB
intro.doctree 28KB
require.doctree 16KB
privileges.doctree 12KB
vendors.doctree 9KB
copyright.doctree 7KB
index.doctree 6KB
other.doctree 5KB
developers.doctree 5KB
user.doctree 3KB
ajax_clock_small.gif 2KB
ajax_clock_small.gif 2KB
close.gif 1KB
b_globe.gif 1KB
b_globe.gif 1KB
ajax-loader.gif 673B
overview_replacement.gif 79B
dot.gif 43B
cleardot.gif 43B
blank.gif 42B
blank.gif 42B
.htaccess 118B
.htaccess 118B
.htaccess 118B
config.html 251KB
faq.html 177KB
genindex.html 115KB
setup.html 41KB
glossary.html 32KB
credits.html 22KB
transformations.html 12KB
index.html 12KB
intro.html 10KB
privileges.html 8KB
require.html 7KB
vendors.html 6KB
user.html 5KB
other.html 5KB
copyright.html 5KB
developers.html 5KB
search.html 3KB
favicon.ico 18KB
error.ico 5KB
favicon.ico 1KB
error.ico 1KB
gettext.inc 17KB
objects.inv 9KB
OpenLayers.js 772KB
jquery-ui-1.9.2.custom.js 250KB
jquery.jqplot.js 167KB
jquery-1.8.3.js 103KB
jquery.js 70KB
codemirror.js 64KB
functions.js 52KB
searchindex.js 49KB
canvg.js 48KB
server_status_monitor.js 41KB
jquery-ui-timepicker-addon.js 40KB
websupport.js 25KB
makegrid.js 25KB
move.js 22KB
excanvas.js 19KB
jqplot.cursor.js 18KB
jquery.svg.js 18KB
flashcanvas.js 17KB
jquery.tablesorter.js 16KB
searchtools.js 16KB
jqplot.canvasTextRenderer.js 15KB
jqplot.pieRenderer.js 13KB
jqplot.barRenderer.js 13KB
history.js 13KB
navigation.js 13KB
rte.js 12KB
config.js 10KB
sql.js 10KB
jqplot.dateAxisRenderer.js 10KB
jqplot.categoryAxisRenderer.js 9KB
tbl_zoom_plot_jqplot.js 9KB
共 1113 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
wrskook
- 粉丝: 2
- 资源: 61
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功