.. 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:`$
没有合适的资源?快使用搜索试试~ 我知道了~
phpMyAdmin-4.4.15.10-all-languages安装包
共2019个文件
php:793个
js:517个
png:502个
需积分: 14 1 下载量 195 浏览量
2022-12-02
09:25:27
上传
评论
收藏 8.56MB 7Z 举报
温馨提示
phpMyAdmin-4.4.15.10-all-languages DBMS • 在Server01上完成MariaDB数据库的安装,添加数据库root用户密码为Chinaskill22! • 安装MariaDB 数据库服务器组件; • MariaDB数据库管理员信息:User: root/ Password: Chinaskill20!; • 安装MariaDB WEB 管理面板 “phpMyAdmin”,通过apache 进行发布 • 安装phpMyAdmin ,MariaDB 的web管理面板组件; • 安装apache,配置php环境,用于发布phpMyAdmin; DBMS配置及搭建看本人主页
资源推荐
资源详情
资源评论
收起资源包目录
phpMyAdmin-4.4.15.10-all-languages安装包 (2019个子文件)
RELEASE-DATE-4.4.15.10 29B
make.bat 6KB
.buildinfo 230B
test.bz2 49B
ChangeLog 26KB
jquery-ui-1.11.2.css 34KB
jquery-ui-1.11.2.css 34KB
styles.css 11KB
basic.css 10KB
style.css 8KB
classic.css 4KB
pygments.css 4KB
firebug.css 3KB
print.css 1KB
ie6-style.css 165B
google.css 143B
default.css 28B
framedCloud.css 0B
db_test_ldi.csv 57B
db_test.csv 57B
DCO 2KB
phpunit.xml.dist 2KB
config.doctree 780KB
faq.doctree 543KB
setup.doctree 141KB
credits.doctree 122KB
glossary.doctree 91KB
transformations.doctree 30KB
intro.doctree 23KB
require.doctree 14KB
privileges.doctree 11KB
copyright.doctree 9KB
vendors.doctree 8KB
index.doctree 6KB
import_export.doctree 5KB
other.doctree 5KB
developers.doctree 4KB
user.doctree 3KB
test.file 10B
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
test.gz 40B
phpunit.xml.hhvm 1KB
.htaccess 304B
config.html 260KB
faq.html 186KB
genindex.html 118KB
setup.html 69KB
glossary.html 31KB
credits.html 24KB
transformations.html 13KB
index.html 12KB
intro.html 10KB
index.html 10KB
privileges.html 8KB
require.html 8KB
copyright.html 7KB
import_export.html 7KB
vendors.html 6KB
user.html 6KB
other.html 6KB
developers.html 5KB
search.html 4KB
firebug.html 651B
mixed_sort.html 600B
sRGB.icc 7KB
favicon.ico 18KB
error.ico 5KB
favicon.ico 1KB
error.ico 1KB
gettext.inc 17KB
travis.php.ini 143B
install-browserstack 233B
install-runkit 323B
objects.inv 10KB
OpenLayers.js 927KB
jquery.jqplot.js 456KB
codemirror.js 335KB
jquery.js 278KB
jquery.js 262KB
jquery-ui-1.11.2.min.js 234KB
functions.js 150KB
jquery-1.11.1.min.js 94KB
server_status_monitor.js 84KB
makegrid.js 83KB
Map.js 82KB
canvg.js 78KB
datepicker.js 76KB
jquery-ui-timepicker-addon.js 74KB
move.js 68KB
selector.js 60KB
共 2019 条
- 1
- 2
- 3
- 4
- 5
- 6
- 21
资源评论
新时代先锋
- 粉丝: 1536
- 资源: 46
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 农村信用社联合社计算机信息系统投产与变更管理办.docx
- 农村信用社联合社计算机信息系统数据管理办法.docx
- 利用SPSS作临床效度分析线上计算网站介绍-医学研究部统计谘.(医学PPT课件).ppt
- 利用Zabbix监控mysqldump定时备份数据库状态.docx
- 利用计算机解决问题的基本过程.doc
- 化工铁路通信工程总结.doc
- 北京大学网络教育软件工程作业.docx
- 医药公司(连锁店)计算机操作规程未新系统的自行按照旧制修改-新系统过制的编号加修模版.doc
- 医药公司(连锁店)计算机系统操作规程模版.doc
- 医药连锁门店计算机系统的操作和管理程序未新系统的自行按照旧制修改-新系统过制的编号加修模版.docx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功