centos:phpmyadmin_c6

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung
Vorhergehende Überarbeitung
centos:phpmyadmin_c6 [08.01.2012 13:47. ] – Dokumentation freigegeben djangocentos:phpmyadmin_c6 [20.04.2018 10:36. ] (aktuell) – Externe Bearbeitung 127.0.0.1
Zeile 1: Zeile 1:
 +====== phpMyAdmin unter CentOS 6.x ======
 +{{:centos:mysql-logo.png?nolink& |mySQL Logo}}
 +
 +Zur komfortablen Administration unseres [[centos:mysql|mySQL-Datenbankserver unter CentOS 6.x]] greifen wir auf das PHP-Projekt [[http://phpmyadmin.sourceforge.net/|phpMyAdmin]] zurück.
 +
 +===== Installation =====
 +Zu erst installieren wir die benötigten Pakete und Programme.
 +
 +Statt die Web-Applikation selbst aus den [[http://phpmyadmin.sourceforge.net/|Programmquellen]] zu installieren, benutzen wir das vorgefertigte **RPM** aus dem Projekt [[http://fedoraproject.org/wiki/EPEL|Extra Packages for Enterprise Linux]] kurz **EPEL**. 
 +Hierzu binden wir erst einmal das EPEL-Repository, wie im Kapitel [[centos:epel6|Einbinden des EPEL Repository unter CentOS 6.x]] beschrieben in unserem definierten Webserverhost ein.
 +
 +==== php-Pakete ====
 +Für unseren komfortablen Weg der Administration unseres **MySQl-Datenbankservers** muß natürlich ein funktionstüchtiger [[centos:mysql|MySQL-Datenbankserver unter CentOS 6.x]] und ein passender [[centos:webserver:start|Apache-Webserver]] zur Verfügung stehen. Bei letzterem werden folgende PHP-Module benötigt:
 +  * **php**
 +  * **php-cli**
 +  * **php-common**
 +  * **php-gd**
 +  * **php-mbstring**
 +  * **php-mcrypt**
 +  * **php-mysql**
 +  * **php-pdo**
 +Diese Pakete installieren wir, sofern diese nicht schon beid der Grunddinstallation unseres Apache-Webservers erfolgte, mit Hilfe von **YUM**
 +   # yum install php php-cli php-common php-gd php-mbstring php-mcrypt php-mysql php-pdo -y
 +
 +Anschließend starten wir bei Bedarf unseren Webserver einmal durch.
 +   # service httpd restart
 +
 +   Stopping httpd:                                            [  OK  ]
 +   Starting httpd:                                            [  OK  ]
 +
 +==== phpMyAdmin ====
 +Dank unseres [[centos:epel6|EPEL Repositories]] reicht nun auch hier für die Programminstallation ein Aufruf mit Unterstützung von **YUM**.
 +   # yum install phpMyAdmin -y
 +
 +Was uns das Paket **phpMyAdmin** alles mitbringt, zeigt uns der Aufruf von: 
 +   # rpm -qil phpMyAdmin
 +
 +<code>Name        : phpMyAdmin                   Relocations: (not relocatable)
 +Version     : 3.4.8                             Vendor: Fedora Project
 +Release     : 1.el6                         Build Date: Sun 04 Dec 2011 02:14:16 PM CET
 +Install Date: Sat 07 Jan 2012 11:05:13 PM CET      Build Host: x86-04.phx2.fedoraproject.org
 +Group       : Applications/Internet         Source RPM: phpMyAdmin-3.4.8-1.el6.src.rpm
 +Size        : 15618926                         License: GPLv2+
 +Signature   : RSA/8, Sun 04 Dec 2011 12:44:21 PM CET, Key ID 3b49df2a0608b895
 +Packager    : Fedora Project
 +URL         : http://www.phpmyadmin.net/
 +Summary     : Handle the administration of MySQL over the World Wide Web
 +Description :
 +phpMyAdmin is a tool written in PHP intended to handle the administration of
 +MySQL over the World Wide Web. Most frequently used operations are supported
 +by the user interface (managing databases, tables, fields, relations, indexes,
 +users, permissions), while you still have the ability to directly execute any
 +SQL statement.
 +
 +Features include an intuitive web interface, support for most MySQL features
 +(browse and drop databases, tables, views, fields and indexes, create, copy,
 +drop, rename and alter databases, tables, fields and indexes, maintenance
 +server, databases and tables, with proposals on server configuration, execute,
 +edit and bookmark any SQL-statement, even batch-queries, manage MySQL users
 +and privileges, manage stored procedures and triggers), import data from CSV
 +and SQL, export data to various formats: CSV, SQL, XML, PDF, OpenDocument Text
 +and Spreadsheet, Word, Excel, LATEX and others, administering multiple servers,
 +creating PDF graphics of your database layout, creating complex queries using
 +Query-by-example (QBE), searching globally in a database or a subset of it,
 +transforming stored data into any format using a set of predefined functions,
 +like displaying BLOB-data as image or download-link and much more...
 +/etc/httpd/conf.d/phpMyAdmin.conf
 +/etc/phpMyAdmin
 +/etc/phpMyAdmin/config.inc.php
 +/usr/share/doc/phpMyAdmin-3.4.8
 +/usr/share/doc/phpMyAdmin-3.4.8/CREDITS
 +/usr/share/doc/phpMyAdmin-3.4.8/ChangeLog
 +/usr/share/doc/phpMyAdmin-3.4.8/Documentation.txt
 +/usr/share/doc/phpMyAdmin-3.4.8/LICENSE
 +/usr/share/doc/phpMyAdmin-3.4.8/README
 +/usr/share/doc/phpMyAdmin-3.4.8/TODO
 +/usr/share/phpMyAdmin
 +/usr/share/phpMyAdmin/Documentation.html
 +/usr/share/phpMyAdmin/browse_foreigners.php
 +/usr/share/phpMyAdmin/bs_disp_as_mime_type.php
 +/usr/share/phpMyAdmin/bs_play_media.php
 +/usr/share/phpMyAdmin/changelog.php
 +/usr/share/phpMyAdmin/chk_rel.php
 +/usr/share/phpMyAdmin/config.sample.inc.php
 +/usr/share/phpMyAdmin/db_create.php
 +/usr/share/phpMyAdmin/db_datadict.php
 +/usr/share/phpMyAdmin/db_export.php
 +/usr/share/phpMyAdmin/db_import.php
 +/usr/share/phpMyAdmin/db_operations.php
 +/usr/share/phpMyAdmin/db_printview.php
 +/usr/share/phpMyAdmin/db_qbe.php
 +/usr/share/phpMyAdmin/db_search.php
 +/usr/share/phpMyAdmin/db_sql.php
 +/usr/share/phpMyAdmin/db_structure.php
 +/usr/share/phpMyAdmin/db_tracking.php
 +/usr/share/phpMyAdmin/docs.css
 +/usr/share/phpMyAdmin/enum_editor.php
 +/usr/share/phpMyAdmin/export.php
 +/usr/share/phpMyAdmin/favicon.ico
 +/usr/share/phpMyAdmin/import.php
 +/usr/share/phpMyAdmin/import_status.php
 +/usr/share/phpMyAdmin/index.php
 +/usr/share/phpMyAdmin/js
 +/usr/share/phpMyAdmin/js/common.js
 +/usr/share/phpMyAdmin/js/config.js
 +/usr/share/phpMyAdmin/js/cross_framing_protection.js
 +/usr/share/phpMyAdmin/js/db_operations.js
 +/usr/share/phpMyAdmin/js/db_search.js
 +/usr/share/phpMyAdmin/js/db_structure.js
 +/usr/share/phpMyAdmin/js/dom-drag.js
 +/usr/share/phpMyAdmin/js/export.js
 +/usr/share/phpMyAdmin/js/functions.js
 +/usr/share/phpMyAdmin/js/import.js
 +/usr/share/phpMyAdmin/js/indexes.js
 +/usr/share/phpMyAdmin/js/jquery
 +/usr/share/phpMyAdmin/js/jquery/jquery-1.4.4.js
 +/usr/share/phpMyAdmin/js/jquery/jquery-ui-1.8.custom.js
 +/usr/share/phpMyAdmin/js/jquery/jquery.json-2.2.js
 +/usr/share/phpMyAdmin/js/jquery/jquery.qtip-1.0.0.min.js
 +/usr/share/phpMyAdmin/js/jquery/jquery.sprintf.js
 +/usr/share/phpMyAdmin/js/jquery/timepicker.js
 +/usr/share/phpMyAdmin/js/keyhandler.js
 +/usr/share/phpMyAdmin/js/messages.php
 +/usr/share/phpMyAdmin/js/navigation.js
 +/usr/share/phpMyAdmin/js/pMap.js
 +/usr/share/phpMyAdmin/js/querywindow.js
 +/usr/share/phpMyAdmin/js/replication.js
 +/usr/share/phpMyAdmin/js/server_privileges.js
 +/usr/share/phpMyAdmin/js/server_synchronize.js
 +/usr/share/phpMyAdmin/js/sql.js
 +/usr/share/phpMyAdmin/js/tbl_change.js
 +/usr/share/phpMyAdmin/js/tbl_relation.js
 +/usr/share/phpMyAdmin/js/tbl_select.js
 +/usr/share/phpMyAdmin/js/tbl_structure.js
 +/usr/share/phpMyAdmin/js/update-location.js
 +/usr/share/phpMyAdmin/libraries
 +/usr/share/phpMyAdmin/libraries/Config.class.php
 +/usr/share/phpMyAdmin/libraries/Error.class.php
 +/usr/share/phpMyAdmin/libraries/Error_Handler.class.php
 +/usr/share/phpMyAdmin/libraries/File.class.php
 +/usr/share/phpMyAdmin/libraries/Index.class.php
 +/usr/share/phpMyAdmin/libraries/List.class.php
 +/usr/share/phpMyAdmin/libraries/List_Database.class.php
 +/usr/share/phpMyAdmin/libraries/Message.class.php
 +/usr/share/phpMyAdmin/libraries/PMA.php
 +/usr/share/phpMyAdmin/libraries/Partition.class.php
 +/usr/share/phpMyAdmin/libraries/StorageEngine.class.php
 +/usr/share/phpMyAdmin/libraries/Table.class.php
 +/usr/share/phpMyAdmin/libraries/Theme.class.php
 +/usr/share/phpMyAdmin/libraries/Theme_Manager.class.php
 +/usr/share/phpMyAdmin/libraries/Tracker.class.php
 +/usr/share/phpMyAdmin/libraries/auth
 +/usr/share/phpMyAdmin/libraries/auth/config.auth.lib.php
 +/usr/share/phpMyAdmin/libraries/auth/cookie.auth.lib.php
 +/usr/share/phpMyAdmin/libraries/auth/http.auth.lib.php
 +/usr/share/phpMyAdmin/libraries/auth/signon.auth.lib.php
 +/usr/share/phpMyAdmin/libraries/auth/swekey
 +/usr/share/phpMyAdmin/libraries/auth/swekey/authentication.inc.php
 +/usr/share/phpMyAdmin/libraries/auth/swekey/musbe-ca.crt
 +/usr/share/phpMyAdmin/libraries/auth/swekey/swekey.auth.lib.php
 +/usr/share/phpMyAdmin/libraries/auth/swekey/swekey.php
 +/usr/share/phpMyAdmin/libraries/blobstreaming.lib.php
 +/usr/share/phpMyAdmin/libraries/blowfish.php
 +/usr/share/phpMyAdmin/libraries/bookmark.lib.php
 +/usr/share/phpMyAdmin/libraries/build_html_for_db.lib.php
 +/usr/share/phpMyAdmin/libraries/charset_conversion.lib.php
 +/usr/share/phpMyAdmin/libraries/chart
 +/usr/share/phpMyAdmin/libraries/chart.lib.php
 +/usr/share/phpMyAdmin/libraries/chart/pChart
 +/usr/share/phpMyAdmin/libraries/chart/pChart/fonts
 +/usr/share/phpMyAdmin/libraries/chart/pChart/fonts/DejaVuSans.ttf
 +/usr/share/phpMyAdmin/libraries/chart/pChart/fonts/LICENSE
 +/usr/share/phpMyAdmin/libraries/chart/pChart/fonts/README
 +/usr/share/phpMyAdmin/libraries/chart/pChart/pCache.class
 +/usr/share/phpMyAdmin/libraries/chart/pChart/pChart.class
 +/usr/share/phpMyAdmin/libraries/chart/pChart/pData.class
 +/usr/share/phpMyAdmin/libraries/chart/pma_chart.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_chart.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_multi.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_multi_bar.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_multi_line.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_multi_radar.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_pie.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_single.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_single_bar.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_single_line.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_single_radar.php
 +/usr/share/phpMyAdmin/libraries/chart/pma_pchart_stacked_bar.php
 +/usr/share/phpMyAdmin/libraries/check_user_privileges.lib.php
 +/usr/share/phpMyAdmin/libraries/cleanup.lib.php
 +/usr/share/phpMyAdmin/libraries/common.inc.php
 +/usr/share/phpMyAdmin/libraries/common.lib.php
 +/usr/share/phpMyAdmin/libraries/config
 +/usr/share/phpMyAdmin/libraries/config.default.php
 +/usr/share/phpMyAdmin/libraries/config.values.php
 +/usr/share/phpMyAdmin/libraries/config/ConfigFile.class.php
 +/usr/share/phpMyAdmin/libraries/config/Form.class.php
 +/usr/share/phpMyAdmin/libraries/config/FormDisplay.class.php
 +/usr/share/phpMyAdmin/libraries/config/FormDisplay.tpl.php
 +/usr/share/phpMyAdmin/libraries/config/config_functions.lib.php
 +/usr/share/phpMyAdmin/libraries/config/messages.inc.php
 +/usr/share/phpMyAdmin/libraries/config/setup.forms.php
 +/usr/share/phpMyAdmin/libraries/config/user_preferences.forms.php
 +/usr/share/phpMyAdmin/libraries/config/validate.lib.php
 +/usr/share/phpMyAdmin/libraries/core.lib.php
 +/usr/share/phpMyAdmin/libraries/database_interface.lib.php
 +/usr/share/phpMyAdmin/libraries/db_common.inc.php
 +/usr/share/phpMyAdmin/libraries/db_events.inc.php
 +/usr/share/phpMyAdmin/libraries/db_info.inc.php
 +/usr/share/phpMyAdmin/libraries/db_links.inc.php
 +/usr/share/phpMyAdmin/libraries/db_routines.inc.php
 +/usr/share/phpMyAdmin/libraries/db_structure.lib.php
 +/usr/share/phpMyAdmin/libraries/db_table_exists.lib.php
 +/usr/share/phpMyAdmin/libraries/dbi
 +/usr/share/phpMyAdmin/libraries/dbi/mysql.dbi.lib.php
 +/usr/share/phpMyAdmin/libraries/dbi/mysqli.dbi.lib.php
 +/usr/share/phpMyAdmin/libraries/display_change_password.lib.php
 +/usr/share/phpMyAdmin/libraries/display_create_database.lib.php
 +/usr/share/phpMyAdmin/libraries/display_create_table.lib.php
 +/usr/share/phpMyAdmin/libraries/display_export.lib.php
 +/usr/share/phpMyAdmin/libraries/display_import.lib.php
 +/usr/share/phpMyAdmin/libraries/display_import_ajax.lib.php
 +/usr/share/phpMyAdmin/libraries/display_select_lang.lib.php
 +/usr/share/phpMyAdmin/libraries/display_tbl.lib.php
 +/usr/share/phpMyAdmin/libraries/engines
 +/usr/share/phpMyAdmin/libraries/engines/bdb.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/berkeleydb.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/binlog.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/innobase.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/innodb.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/memory.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/merge.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/mrg_myisam.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/myisam.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/ndbcluster.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/pbms.lib.php
 +/usr/share/phpMyAdmin/libraries/engines/pbxt.lib.php
 +/usr/share/phpMyAdmin/libraries/error.inc.php
 +/usr/share/phpMyAdmin/libraries/export
 +/usr/share/phpMyAdmin/libraries/export/codegen.php
 +/usr/share/phpMyAdmin/libraries/export/csv.php
 +/usr/share/phpMyAdmin/libraries/export/excel.php
 +/usr/share/phpMyAdmin/libraries/export/htmlword.php
 +/usr/share/phpMyAdmin/libraries/export/json.php
 +/usr/share/phpMyAdmin/libraries/export/latex.php
 +/usr/share/phpMyAdmin/libraries/export/mediawiki.php
 +/usr/share/phpMyAdmin/libraries/export/ods.php
 +/usr/share/phpMyAdmin/libraries/export/odt.php
 +/usr/share/phpMyAdmin/libraries/export/pdf.php
 +/usr/share/phpMyAdmin/libraries/export/php_array.php
 +/usr/share/phpMyAdmin/libraries/export/sql.php
 +/usr/share/phpMyAdmin/libraries/export/texytext.php
 +/usr/share/phpMyAdmin/libraries/export/xml.php
 +/usr/share/phpMyAdmin/libraries/export/yaml.php
 +/usr/share/phpMyAdmin/libraries/file_listing.php
 +/usr/share/phpMyAdmin/libraries/footer.inc.php
 +/usr/share/phpMyAdmin/libraries/grab_globals.lib.php
 +/usr/share/phpMyAdmin/libraries/header.inc.php
 +/usr/share/phpMyAdmin/libraries/header_http.inc.php
 +/usr/share/phpMyAdmin/libraries/header_meta_style.inc.php
 +/usr/share/phpMyAdmin/libraries/header_printview.inc.php
 +/usr/share/phpMyAdmin/libraries/header_scripts.inc.php
 +/usr/share/phpMyAdmin/libraries/iconv_wrapper.lib.php
 +/usr/share/phpMyAdmin/libraries/import
 +/usr/share/phpMyAdmin/libraries/import.lib.php
 +/usr/share/phpMyAdmin/libraries/import/README
 +/usr/share/phpMyAdmin/libraries/import/csv.php
 +/usr/share/phpMyAdmin/libraries/import/docsql.php
 +/usr/share/phpMyAdmin/libraries/import/ldi.php
 +/usr/share/phpMyAdmin/libraries/import/ods.php
 +/usr/share/phpMyAdmin/libraries/import/sql.php
 +/usr/share/phpMyAdmin/libraries/import/upload
 +/usr/share/phpMyAdmin/libraries/import/upload/apc.php
 +/usr/share/phpMyAdmin/libraries/import/upload/noplugin.php
 +/usr/share/phpMyAdmin/libraries/import/upload/uploadprogress.php
 +/usr/share/phpMyAdmin/libraries/import/xml.php
 +/usr/share/phpMyAdmin/libraries/information_schema_relations.lib.php
 +/usr/share/phpMyAdmin/libraries/ip_allow_deny.lib.php
 +/usr/share/phpMyAdmin/libraries/js_escape.lib.php
 +/usr/share/phpMyAdmin/libraries/kanji-encoding.lib.php
 +/usr/share/phpMyAdmin/libraries/language_stats.inc.php
 +/usr/share/phpMyAdmin/libraries/logging.lib.php
 +/usr/share/phpMyAdmin/libraries/mime.lib.php
 +/usr/share/phpMyAdmin/libraries/mult_submits.inc.php
 +/usr/share/phpMyAdmin/libraries/mysql_charsets.lib.php
 +/usr/share/phpMyAdmin/libraries/navigation_header.inc.php
 +/usr/share/phpMyAdmin/libraries/ob.lib.php
 +/usr/share/phpMyAdmin/libraries/opendocument.lib.php
 +/usr/share/phpMyAdmin/libraries/parse_analyze.lib.php
 +/usr/share/phpMyAdmin/libraries/plugin_interface.lib.php
 +/usr/share/phpMyAdmin/libraries/relation.lib.php
 +/usr/share/phpMyAdmin/libraries/relation_cleanup.lib.php
 +/usr/share/phpMyAdmin/libraries/replication.inc.php
 +/usr/share/phpMyAdmin/libraries/replication_gui.lib.php
 +/usr/share/phpMyAdmin/libraries/sanitizing.lib.php
 +/usr/share/phpMyAdmin/libraries/schema
 +/usr/share/phpMyAdmin/libraries/schema/Dia_Relation_Schema.class.php
 +/usr/share/phpMyAdmin/libraries/schema/Eps_Relation_Schema.class.php
 +/usr/share/phpMyAdmin/libraries/schema/Export_Relation_Schema.class.php
 +/usr/share/phpMyAdmin/libraries/schema/Pdf_Relation_Schema.class.php
 +/usr/share/phpMyAdmin/libraries/schema/Svg_Relation_Schema.class.php
 +/usr/share/phpMyAdmin/libraries/schema/User_Schema.class.php
 +/usr/share/phpMyAdmin/libraries/schema/Visio_Relation_Schema.class.php
 +/usr/share/phpMyAdmin/libraries/select_lang.lib.php
 +/usr/share/phpMyAdmin/libraries/select_server.lib.php
 +/usr/share/phpMyAdmin/libraries/server_common.inc.php
 +/usr/share/phpMyAdmin/libraries/server_links.inc.php
 +/usr/share/phpMyAdmin/libraries/server_synchronize.lib.php
 +/usr/share/phpMyAdmin/libraries/server_variables_doc.php
 +/usr/share/phpMyAdmin/libraries/session.inc.php
 +/usr/share/phpMyAdmin/libraries/sql_query_form.lib.php
 +/usr/share/phpMyAdmin/libraries/sqlparser.data.php
 +/usr/share/phpMyAdmin/libraries/sqlparser.lib.php
 +/usr/share/phpMyAdmin/libraries/sqlvalidator.class.php
 +/usr/share/phpMyAdmin/libraries/sqlvalidator.lib.php
 +/usr/share/phpMyAdmin/libraries/string.lib.php
 +/usr/share/phpMyAdmin/libraries/string_mb.lib.php
 +/usr/share/phpMyAdmin/libraries/string_native.lib.php
 +/usr/share/phpMyAdmin/libraries/string_type_ctype.lib.php
 +/usr/share/phpMyAdmin/libraries/string_type_native.lib.php
 +/usr/share/phpMyAdmin/libraries/tbl_common.php
 +/usr/share/phpMyAdmin/libraries/tbl_info.inc.php
 +/usr/share/phpMyAdmin/libraries/tbl_links.inc.php
 +/usr/share/phpMyAdmin/libraries/tbl_properties.inc.php
 +/usr/share/phpMyAdmin/libraries/tbl_replace_fields.inc.php
 +/usr/share/phpMyAdmin/libraries/tbl_triggers.lib.php
 +/usr/share/phpMyAdmin/libraries/tcpdf
 +/usr/share/phpMyAdmin/libraries/tcpdf/CHANGELOG.TXT
 +/usr/share/phpMyAdmin/libraries/tcpdf/LICENSE.TXT
 +/usr/share/phpMyAdmin/libraries/tcpdf/README.TXT
 +/usr/share/phpMyAdmin/libraries/tcpdf/cache
 +/usr/share/phpMyAdmin/libraries/tcpdf/cache/chapter_demo_1.txt
 +/usr/share/phpMyAdmin/libraries/tcpdf/cache/chapter_demo_2.txt
 +/usr/share/phpMyAdmin/libraries/tcpdf/cache/table_data_demo.txt
 +/usr/share/phpMyAdmin/libraries/tcpdf/cache/utf8test.txt
 +/usr/share/phpMyAdmin/libraries/tcpdf/config
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/afr.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/ara.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/aze.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/bel.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/bra.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/cat.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/ces.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/chi.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/cym.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/dan.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/eng.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/est.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/eus.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/fra.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/ger.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/gle.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/glg.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/hat.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/heb.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/hrv.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/hun.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/hye.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/ind.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/ita.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/kat.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/kor.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/mkd.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/mlt.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/msa.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/nld.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/nob.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/pol.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/por.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/ron.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/rus.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/slv.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/spa.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/sqi.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/srp.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/swa.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/swe.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/urd.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/yid.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/lang/zho.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/tcpdf_config.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/config/tcpdf_config_alt.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/README.TXT
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/courier.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/courierb.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/courierbi.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/courieri.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavu-fonts-ttf-2.32
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavu-fonts-ttf-2.32/LICENSE
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavu-fonts-ttf-2.32/README
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavusans.ctg.z
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavusans.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavusans.z
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavusansb.ctg.z
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavusansb.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavusansb.z
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavuserif.ctg.z
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavuserif.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavuserif.z
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavuserifb.ctg.z
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavuserifb.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/dejavuserifb.z
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/helvetica.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/helveticab.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/helveticabi.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/helveticai.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/symbol.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/times.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/timesb.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/timesbi.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/timesi.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/fonts/zapfdingbats.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/htmlcolors.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/spotcolors.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/tcpdf.crt
 +/usr/share/phpMyAdmin/libraries/tcpdf/tcpdf.fdf
 +/usr/share/phpMyAdmin/libraries/tcpdf/tcpdf.p12
 +/usr/share/phpMyAdmin/libraries/tcpdf/tcpdf.php
 +/usr/share/phpMyAdmin/libraries/tcpdf/unicode_data.php
 +/usr/share/phpMyAdmin/libraries/transformations
 +/usr/share/phpMyAdmin/libraries/transformations.lib.php
 +/usr/share/phpMyAdmin/libraries/transformations/README
 +/usr/share/phpMyAdmin/libraries/transformations/TEMPLATE
 +/usr/share/phpMyAdmin/libraries/transformations/TEMPLATE_MIMETYPE
 +/usr/share/phpMyAdmin/libraries/transformations/application_octetstream__download.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/application_octetstream__hex.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/generator.sh
 +/usr/share/phpMyAdmin/libraries/transformations/global.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/image_jpeg__inline.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/image_jpeg__link.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/image_png__inline.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/template_generator.sh
 +/usr/share/phpMyAdmin/libraries/transformations/template_generator_mimetype.sh
 +/usr/share/phpMyAdmin/libraries/transformations/text_plain__dateformat.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/text_plain__external.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/text_plain__formatted.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/text_plain__imagelink.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/text_plain__link.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/text_plain__longToIpv4.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/text_plain__sql.inc.php
 +/usr/share/phpMyAdmin/libraries/transformations/text_plain__substr.inc.php
 +/usr/share/phpMyAdmin/libraries/url_generating.lib.php
 +/usr/share/phpMyAdmin/libraries/user_preferences.inc.php
 +/usr/share/phpMyAdmin/libraries/user_preferences.lib.php
 +/usr/share/phpMyAdmin/libraries/vendor_config.php
 +/usr/share/phpMyAdmin/libraries/zip.lib.php
 +/usr/share/phpMyAdmin/libraries/zip_extension.lib.php
 +/usr/share/phpMyAdmin/license.php
 +/usr/share/phpMyAdmin/locale
 +/usr/share/phpMyAdmin/locale/ar
 +/usr/share/phpMyAdmin/locale/ar/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/ar/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/be
 +/usr/share/phpMyAdmin/locale/be/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/be/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/be@latin
 +/usr/share/phpMyAdmin/locale/be@latin/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/be@latin/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/bg
 +/usr/share/phpMyAdmin/locale/bg/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/bg/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/bn
 +/usr/share/phpMyAdmin/locale/bn/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/bn/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/ca
 +/usr/share/phpMyAdmin/locale/ca/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/ca/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/cs
 +/usr/share/phpMyAdmin/locale/cs/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/cs/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/da
 +/usr/share/phpMyAdmin/locale/da/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/da/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/de
 +/usr/share/phpMyAdmin/locale/de/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/de/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/el
 +/usr/share/phpMyAdmin/locale/el/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/el/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/en_GB
 +/usr/share/phpMyAdmin/locale/en_GB/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/en_GB/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/es
 +/usr/share/phpMyAdmin/locale/es/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/es/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/et
 +/usr/share/phpMyAdmin/locale/et/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/et/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/fi
 +/usr/share/phpMyAdmin/locale/fi/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/fi/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/fr
 +/usr/share/phpMyAdmin/locale/fr/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/fr/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/gl
 +/usr/share/phpMyAdmin/locale/gl/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/gl/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/hi
 +/usr/share/phpMyAdmin/locale/hi/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/hi/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/hr
 +/usr/share/phpMyAdmin/locale/hr/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/hr/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/hu
 +/usr/share/phpMyAdmin/locale/hu/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/hu/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/id
 +/usr/share/phpMyAdmin/locale/id/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/id/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/it
 +/usr/share/phpMyAdmin/locale/it/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/it/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/ja
 +/usr/share/phpMyAdmin/locale/ja/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/ja/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/ka
 +/usr/share/phpMyAdmin/locale/ka/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/ka/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/lt
 +/usr/share/phpMyAdmin/locale/lt/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/lt/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/mn
 +/usr/share/phpMyAdmin/locale/mn/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/mn/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/nb
 +/usr/share/phpMyAdmin/locale/nb/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/nb/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/nl
 +/usr/share/phpMyAdmin/locale/nl/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/nl/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/pl
 +/usr/share/phpMyAdmin/locale/pl/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/pl/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/pt_BR
 +/usr/share/phpMyAdmin/locale/pt_BR/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/pt_BR/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/ro
 +/usr/share/phpMyAdmin/locale/ro/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/ro/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/ru
 +/usr/share/phpMyAdmin/locale/ru/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/ru/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/si
 +/usr/share/phpMyAdmin/locale/si/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/si/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/sk
 +/usr/share/phpMyAdmin/locale/sk/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/sk/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/sl
 +/usr/share/phpMyAdmin/locale/sl/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/sl/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/sr
 +/usr/share/phpMyAdmin/locale/sr/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/sr/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/sr@latin
 +/usr/share/phpMyAdmin/locale/sr@latin/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/sr@latin/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/sv
 +/usr/share/phpMyAdmin/locale/sv/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/sv/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/tr
 +/usr/share/phpMyAdmin/locale/tr/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/tr/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/uz
 +/usr/share/phpMyAdmin/locale/uz/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/uz/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/uz@latin
 +/usr/share/phpMyAdmin/locale/uz@latin/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/uz@latin/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/zh_CN
 +/usr/share/phpMyAdmin/locale/zh_CN/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/zh_CN/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/locale/zh_TW
 +/usr/share/phpMyAdmin/locale/zh_TW/LC_MESSAGES
 +/usr/share/phpMyAdmin/locale/zh_TW/LC_MESSAGES/phpmyadmin.mo
 +/usr/share/phpMyAdmin/main.php
 +/usr/share/phpMyAdmin/navigation.php
 +/usr/share/phpMyAdmin/phpdoctor.ini
 +/usr/share/phpMyAdmin/phpinfo.php
 +/usr/share/phpMyAdmin/phpmyadmin.css.php
 +/usr/share/phpMyAdmin/pmd
 +/usr/share/phpMyAdmin/pmd/images
 +/usr/share/phpMyAdmin/pmd/images/2leftarrow.png
 +/usr/share/phpMyAdmin/pmd/images/2leftarrow_m.png
 +/usr/share/phpMyAdmin/pmd/images/2rightarrow.png
 +/usr/share/phpMyAdmin/pmd/images/2rightarrow_m.png
 +/usr/share/phpMyAdmin/pmd/images/and_icon.png
 +/usr/share/phpMyAdmin/pmd/images/ang_direct.png
 +/usr/share/phpMyAdmin/pmd/images/bord.png
 +/usr/share/phpMyAdmin/pmd/images/bottom.png
 +/usr/share/phpMyAdmin/pmd/images/def.png
 +/usr/share/phpMyAdmin/pmd/images/display_field.png
 +/usr/share/phpMyAdmin/pmd/images/downarrow1.png
 +/usr/share/phpMyAdmin/pmd/images/downarrow2.png
 +/usr/share/phpMyAdmin/pmd/images/downarrow2_m.png
 +/usr/share/phpMyAdmin/pmd/images/exec.png
 +/usr/share/phpMyAdmin/pmd/images/exec_small.png
 +/usr/share/phpMyAdmin/pmd/images/favicon.ico
 +/usr/share/phpMyAdmin/pmd/images/grid.png
 +/usr/share/phpMyAdmin/pmd/images/help.png
 +/usr/share/phpMyAdmin/pmd/images/help_relation.png
 +/usr/share/phpMyAdmin/pmd/images/or_icon.png
 +/usr/share/phpMyAdmin/pmd/images/pdf.png
 +/usr/share/phpMyAdmin/pmd/images/query_builder.png
 +/usr/share/phpMyAdmin/pmd/images/relation.png
 +/usr/share/phpMyAdmin/pmd/images/reload.png
 +/usr/share/phpMyAdmin/pmd/images/resize.png
 +/usr/share/phpMyAdmin/pmd/images/rightarrow1.png
 +/usr/share/phpMyAdmin/pmd/images/rightarrow2.png
 +/usr/share/phpMyAdmin/pmd/images/save.png
 +/usr/share/phpMyAdmin/pmd/images/table.png
 +/usr/share/phpMyAdmin/pmd/images/uparrow2_m.png
 +/usr/share/phpMyAdmin/pmd/scripts
 +/usr/share/phpMyAdmin/pmd/scripts/ajax.js
 +/usr/share/phpMyAdmin/pmd/scripts/history.js
 +/usr/share/phpMyAdmin/pmd/scripts/iecanvas.js
 +/usr/share/phpMyAdmin/pmd/scripts/move.js
 +/usr/share/phpMyAdmin/pmd/styles
 +/usr/share/phpMyAdmin/pmd/styles/default
 +/usr/share/phpMyAdmin/pmd/styles/default/images
 +/usr/share/phpMyAdmin/pmd/styles/default/images/1.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/2.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/3.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/4.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/5.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/6.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/7.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/8.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/FieldKey_small.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/Field_small.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/Field_small_char.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/Field_small_date.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/Field_small_int.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/Header.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/Header_Linked.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/left_panel_butt.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/left_panel_tab.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/minus.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/plus.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/small_tab.png
 +/usr/share/phpMyAdmin/pmd/styles/default/images/top_panel.png
 +/usr/share/phpMyAdmin/pmd/styles/default/style1.css
 +/usr/share/phpMyAdmin/pmd_common.php
 +/usr/share/phpMyAdmin/pmd_display_field.php
 +/usr/share/phpMyAdmin/pmd_general.php
 +/usr/share/phpMyAdmin/pmd_help.php
 +/usr/share/phpMyAdmin/pmd_pdf.php
 +/usr/share/phpMyAdmin/pmd_relation_new.php
 +/usr/share/phpMyAdmin/pmd_relation_upd.php
 +/usr/share/phpMyAdmin/pmd_save_pos.php
 +/usr/share/phpMyAdmin/prefs_forms.php
 +/usr/share/phpMyAdmin/prefs_manage.php
 +/usr/share/phpMyAdmin/print.css
 +/usr/share/phpMyAdmin/querywindow.php
 +/usr/share/phpMyAdmin/schema_edit.php
 +/usr/share/phpMyAdmin/schema_export.php
 +/usr/share/phpMyAdmin/scripts
 +/usr/share/phpMyAdmin/scripts/convertcfg.pl
 +/usr/share/phpMyAdmin/scripts/create_tables.sql
 +/usr/share/phpMyAdmin/scripts/decode_bug.php
 +/usr/share/phpMyAdmin/scripts/openid.php
 +/usr/share/phpMyAdmin/scripts/remove-incomplete-mo
 +/usr/share/phpMyAdmin/scripts/signon.php
 +/usr/share/phpMyAdmin/scripts/update-po-foreign
 +/usr/share/phpMyAdmin/scripts/upgrade.pl
 +/usr/share/phpMyAdmin/scripts/upgrade_tables_mysql_4_1_2+.sql
 +/usr/share/phpMyAdmin/server_binlog.php
 +/usr/share/phpMyAdmin/server_collations.php
 +/usr/share/phpMyAdmin/server_databases.php
 +/usr/share/phpMyAdmin/server_engines.php
 +/usr/share/phpMyAdmin/server_export.php
 +/usr/share/phpMyAdmin/server_import.php
 +/usr/share/phpMyAdmin/server_privileges.php
 +/usr/share/phpMyAdmin/server_processlist.php
 +/usr/share/phpMyAdmin/server_replication.php
 +/usr/share/phpMyAdmin/server_sql.php
 +/usr/share/phpMyAdmin/server_status.php
 +/usr/share/phpMyAdmin/server_synchronize.php
 +/usr/share/phpMyAdmin/server_variables.php
 +/usr/share/phpMyAdmin/setup
 +/usr/share/phpMyAdmin/setup/config.php
 +/usr/share/phpMyAdmin/setup/frames
 +/usr/share/phpMyAdmin/setup/frames/config.inc.php
 +/usr/share/phpMyAdmin/setup/frames/form.inc.php
 +/usr/share/phpMyAdmin/setup/frames/index.inc.php
 +/usr/share/phpMyAdmin/setup/frames/menu.inc.php
 +/usr/share/phpMyAdmin/setup/frames/servers.inc.php
 +/usr/share/phpMyAdmin/setup/index.php
 +/usr/share/phpMyAdmin/setup/lib
 +/usr/share/phpMyAdmin/setup/lib/ConfigGenerator.class.php
 +/usr/share/phpMyAdmin/setup/lib/common.inc.php
 +/usr/share/phpMyAdmin/setup/lib/form_processing.lib.php
 +/usr/share/phpMyAdmin/setup/lib/index.lib.php
 +/usr/share/phpMyAdmin/setup/scripts.js
 +/usr/share/phpMyAdmin/setup/styles.css
 +/usr/share/phpMyAdmin/setup/validate.php
 +/usr/share/phpMyAdmin/show_config_errors.php
 +/usr/share/phpMyAdmin/sql.php
 +/usr/share/phpMyAdmin/tbl_addfield.php
 +/usr/share/phpMyAdmin/tbl_alter.php
 +/usr/share/phpMyAdmin/tbl_change.php
 +/usr/share/phpMyAdmin/tbl_chart.php
 +/usr/share/phpMyAdmin/tbl_create.php
 +/usr/share/phpMyAdmin/tbl_export.php
 +/usr/share/phpMyAdmin/tbl_get_field.php
 +/usr/share/phpMyAdmin/tbl_import.php
 +/usr/share/phpMyAdmin/tbl_indexes.php
 +/usr/share/phpMyAdmin/tbl_move_copy.php
 +/usr/share/phpMyAdmin/tbl_operations.php
 +/usr/share/phpMyAdmin/tbl_printview.php
 +/usr/share/phpMyAdmin/tbl_relation.php
 +/usr/share/phpMyAdmin/tbl_replace.php
 +/usr/share/phpMyAdmin/tbl_row_action.php
 +/usr/share/phpMyAdmin/tbl_select.php
 +/usr/share/phpMyAdmin/tbl_sql.php
 +/usr/share/phpMyAdmin/tbl_structure.php
 +/usr/share/phpMyAdmin/tbl_tracking.php
 +/usr/share/phpMyAdmin/themes
 +/usr/share/phpMyAdmin/themes.php
 +/usr/share/phpMyAdmin/themes/original
 +/usr/share/phpMyAdmin/themes/original/css
 +/usr/share/phpMyAdmin/themes/original/css/theme_left.css.php
 +/usr/share/phpMyAdmin/themes/original/css/theme_print.css.php
 +/usr/share/phpMyAdmin/themes/original/css/theme_right.css.php
 +/usr/share/phpMyAdmin/themes/original/img
 +/usr/share/phpMyAdmin/themes/original/img/ajax_clock_small.gif
 +/usr/share/phpMyAdmin/themes/original/img/arrow_ltr.png
 +/usr/share/phpMyAdmin/themes/original/img/arrow_rtl.png
 +/usr/share/phpMyAdmin/themes/original/img/b_bookmark.png
 +/usr/share/phpMyAdmin/themes/original/img/b_browse.png
 +/usr/share/phpMyAdmin/themes/original/img/b_calendar.png
 +/usr/share/phpMyAdmin/themes/original/img/b_chart.png
 +/usr/share/phpMyAdmin/themes/original/img/b_close.png
 +/usr/share/phpMyAdmin/themes/original/img/b_comment.png
 +/usr/share/phpMyAdmin/themes/original/img/b_dbstatistics.png
 +/usr/share/phpMyAdmin/themes/original/img/b_deltbl.png
 +/usr/share/phpMyAdmin/themes/original/img/b_docs.png
 +/usr/share/phpMyAdmin/themes/original/img/b_drop.png
 +/usr/share/phpMyAdmin/themes/original/img/b_edit.png
 +/usr/share/phpMyAdmin/themes/original/img/b_empty.png
 +/usr/share/phpMyAdmin/themes/original/img/b_engine.png
 +/usr/share/phpMyAdmin/themes/original/img/b_export.png
 +/usr/share/phpMyAdmin/themes/original/img/b_ftext.png
 +/usr/share/phpMyAdmin/themes/original/img/b_help.png
 +/usr/share/phpMyAdmin/themes/original/img/b_home.png
 +/usr/share/phpMyAdmin/themes/original/img/b_import.png
 +/usr/share/phpMyAdmin/themes/original/img/b_index.png
 +/usr/share/phpMyAdmin/themes/original/img/b_info.png
 +/usr/share/phpMyAdmin/themes/original/img/b_inline_edit.png
 +/usr/share/phpMyAdmin/themes/original/img/b_insrow.png
 +/usr/share/phpMyAdmin/themes/original/img/b_minus.png
 +/usr/share/phpMyAdmin/themes/original/img/b_more.png
 +/usr/share/phpMyAdmin/themes/original/img/b_newdb.png
 +/usr/share/phpMyAdmin/themes/original/img/b_newtbl.png
 +/usr/share/phpMyAdmin/themes/original/img/b_plus.png
 +/usr/share/phpMyAdmin/themes/original/img/b_primary.png
 +/usr/share/phpMyAdmin/themes/original/img/b_print.png
 +/usr/share/phpMyAdmin/themes/original/img/b_props.png
 +/usr/share/phpMyAdmin/themes/original/img/b_relations.png
 +/usr/share/phpMyAdmin/themes/original/img/b_save.png
 +/usr/share/phpMyAdmin/themes/original/img/b_sbrowse.png
 +/usr/share/phpMyAdmin/themes/original/img/b_search.png
 +/usr/share/phpMyAdmin/themes/original/img/b_selboard.png
 +/usr/share/phpMyAdmin/themes/original/img/b_select.png
 +/usr/share/phpMyAdmin/themes/original/img/b_snewtbl.png
 +/usr/share/phpMyAdmin/themes/original/img/b_sql.png
 +/usr/share/phpMyAdmin/themes/original/img/b_sqlhelp.png
 +/usr/share/phpMyAdmin/themes/original/img/b_tblanalyse.png
 +/usr/share/phpMyAdmin/themes/original/img/b_tblexport.png
 +/usr/share/phpMyAdmin/themes/original/img/b_tblimport.png
 +/usr/share/phpMyAdmin/themes/original/img/b_tblops.png
 +/usr/share/phpMyAdmin/themes/original/img/b_tbloptimize.png
 +/usr/share/phpMyAdmin/themes/original/img/b_tipp.png
 +/usr/share/phpMyAdmin/themes/original/img/b_unique.png
 +/usr/share/phpMyAdmin/themes/original/img/b_usradd.png
 +/usr/share/phpMyAdmin/themes/original/img/b_usrcheck.png
 +/usr/share/phpMyAdmin/themes/original/img/b_usrdrop.png
 +/usr/share/phpMyAdmin/themes/original/img/b_usredit.png
 +/usr/share/phpMyAdmin/themes/original/img/b_usrlist.png
 +/usr/share/phpMyAdmin/themes/original/img/b_view.png
 +/usr/share/phpMyAdmin/themes/original/img/b_views.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_browse.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_deltbl.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_drop.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_empty.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_ftext.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_index.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_insrow.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_primary.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_sbrowse.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_select.png
 +/usr/share/phpMyAdmin/themes/original/img/bd_unique.png
 +/usr/share/phpMyAdmin/themes/original/img/docs_menu_bg.png
 +/usr/share/phpMyAdmin/themes/original/img/error.ico
 +/usr/share/phpMyAdmin/themes/original/img/eye.png
 +/usr/share/phpMyAdmin/themes/original/img/eye_grey.png
 +/usr/share/phpMyAdmin/themes/original/img/item_ltr.png
 +/usr/share/phpMyAdmin/themes/original/img/item_rtl.png
 +/usr/share/phpMyAdmin/themes/original/img/logo_left.png
 +/usr/share/phpMyAdmin/themes/original/img/logo_right.png
 +/usr/share/phpMyAdmin/themes/original/img/more.png
 +/usr/share/phpMyAdmin/themes/original/img/new_data.jpg
 +/usr/share/phpMyAdmin/themes/original/img/new_data_hovered.jpg
 +/usr/share/phpMyAdmin/themes/original/img/new_data_selected.jpg
 +/usr/share/phpMyAdmin/themes/original/img/new_data_selected_hovered.jpg
 +/usr/share/phpMyAdmin/themes/original/img/new_struct.jpg
 +/usr/share/phpMyAdmin/themes/original/img/new_struct_hovered.jpg
 +/usr/share/phpMyAdmin/themes/original/img/new_struct_selected.jpg
 +/usr/share/phpMyAdmin/themes/original/img/new_struct_selected_hovered.jpg
 +/usr/share/phpMyAdmin/themes/original/img/s_asc.png
 +/usr/share/phpMyAdmin/themes/original/img/s_asci.png
 +/usr/share/phpMyAdmin/themes/original/img/s_cancel.png
 +/usr/share/phpMyAdmin/themes/original/img/s_db.png
 +/usr/share/phpMyAdmin/themes/original/img/s_desc.png
 +/usr/share/phpMyAdmin/themes/original/img/s_error.png
 +/usr/share/phpMyAdmin/themes/original/img/s_error2.png
 +/usr/share/phpMyAdmin/themes/original/img/s_fulltext.png
 +/usr/share/phpMyAdmin/themes/original/img/s_host.png
 +/usr/share/phpMyAdmin/themes/original/img/s_lang.png
 +/usr/share/phpMyAdmin/themes/original/img/s_loggoff.png
 +/usr/share/phpMyAdmin/themes/original/img/s_notice.png
 +/usr/share/phpMyAdmin/themes/original/img/s_partialtext.png
 +/usr/share/phpMyAdmin/themes/original/img/s_passwd.png
 +/usr/share/phpMyAdmin/themes/original/img/s_process.png
 +/usr/share/phpMyAdmin/themes/original/img/s_really.png
 +/usr/share/phpMyAdmin/themes/original/img/s_reload.png
 +/usr/share/phpMyAdmin/themes/original/img/s_replication.png
 +/usr/share/phpMyAdmin/themes/original/img/s_rights.png
 +/usr/share/phpMyAdmin/themes/original/img/s_status.png
 +/usr/share/phpMyAdmin/themes/original/img/s_success.png
 +/usr/share/phpMyAdmin/themes/original/img/s_sync.png
 +/usr/share/phpMyAdmin/themes/original/img/s_tbl.png
 +/usr/share/phpMyAdmin/themes/original/img/s_theme.png
 +/usr/share/phpMyAdmin/themes/original/img/s_vars.png
 +/usr/share/phpMyAdmin/themes/original/img/s_views.png
 +/usr/share/phpMyAdmin/themes/original/img/spacer.png
 +/usr/share/phpMyAdmin/themes/original/img/vertical_line.png
 +/usr/share/phpMyAdmin/themes/original/img/window-new.png
 +/usr/share/phpMyAdmin/themes/original/info.inc.php
 +/usr/share/phpMyAdmin/themes/original/jquery
 +/usr/share/phpMyAdmin/themes/original/jquery/images
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-bg_flat_0_aaaaaa_40x100.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-bg_flat_75_ffffff_40x100.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-bg_glass_55_fbf9ee_1x400.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-bg_glass_65_ffffff_1x400.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-bg_glass_75_dadada_1x400.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-bg_glass_75_e6e6e6_1x400.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-bg_glass_95_fef1ec_1x400.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-bg_highlight-soft_75_cccccc_1x100.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-icons_222222_256x240.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-icons_2e83ff_256x240.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-icons_454545_256x240.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-icons_888888_256x240.png
 +/usr/share/phpMyAdmin/themes/original/jquery/images/ui-icons_cd0a0a_256x240.png
 +/usr/share/phpMyAdmin/themes/original/jquery/jquery-ui-1.8.custom.css
 +/usr/share/phpMyAdmin/themes/original/layout.inc.php
 +/usr/share/phpMyAdmin/themes/original/screen.png
 +/usr/share/phpMyAdmin/themes/pmahomme
 +/usr/share/phpMyAdmin/themes/pmahomme/css
 +/usr/share/phpMyAdmin/themes/pmahomme/css/theme_left.css.php
 +/usr/share/phpMyAdmin/themes/pmahomme/css/theme_print.css.php
 +/usr/share/phpMyAdmin/themes/pmahomme/css/theme_right.css.php
 +/usr/share/phpMyAdmin/themes/pmahomme/img
 +/usr/share/phpMyAdmin/themes/pmahomme/img/ajax_clock_small.gif
 +/usr/share/phpMyAdmin/themes/pmahomme/img/arrow_ltr.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/arrow_rtl.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/asc_order.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_bookmark.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_browse.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_calendar.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_chart.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_close.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_comment.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_dbstatistics.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_deltbl.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_docs.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_docsql.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_drop.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_edit.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_empty.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_engine.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_export.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_firstpage.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_ftext.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_help.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_home.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_import.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_index.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_info.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_inline_edit.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_insrow.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_lastpage.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_minus.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_more.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_newdb.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_newtbl.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_nextpage.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_pdfdoc.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_plus.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_prevpage.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_primary.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_print.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_props.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_relations.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_save.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_sbrowse.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_sdb.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_search.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_selboard.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_select.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_snewtbl.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_sql.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_sqldoc.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_sqlhelp.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_tblanalyse.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_tblexport.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_tblimport.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_tblops.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_tbloptimize.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_tipp.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_unique.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_usradd.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_usrcheck.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_usrdrop.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_usredit.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_usrlist.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_view.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/b_views.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_browse.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_deltbl.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_drop.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_empty.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_firstpage.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_ftext.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_index.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_insrow.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_lastpage.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_nextpage.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_prevpage.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_primary.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_sbrowse.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_select.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/bd_unique.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/body_bg.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/database.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/database_list_li_hover.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/docs_menu_bg.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/error.ico
 +/usr/share/phpMyAdmin/themes/pmahomme/img/eye.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/eye_grey.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/input_bg.gif
 +/usr/share/phpMyAdmin/themes/pmahomme/img/item.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/item_ltr.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/item_rtl.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/left_nav_bg.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/logo_left.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/logo_right.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/marked_bg.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/more.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/new_data.jpg
 +/usr/share/phpMyAdmin/themes/pmahomme/img/new_data_hovered.jpg
 +/usr/share/phpMyAdmin/themes/pmahomme/img/new_data_selected.jpg
 +/usr/share/phpMyAdmin/themes/pmahomme/img/new_data_selected_hovered.jpg
 +/usr/share/phpMyAdmin/themes/pmahomme/img/new_struct.jpg
 +/usr/share/phpMyAdmin/themes/pmahomme/img/new_struct_hovered.jpg
 +/usr/share/phpMyAdmin/themes/pmahomme/img/new_struct_selected.jpg
 +/usr/share/phpMyAdmin/themes/pmahomme/img/new_struct_selected_hovered.jpg
 +/usr/share/phpMyAdmin/themes/pmahomme/img/php_sym.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/pma_logo2.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_asc.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_asci.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_attention.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_cancel.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_cancel2.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_db.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_desc.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_error.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_error2.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_fulltext.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_host.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_info.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_lang.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_loggoff.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_notice.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_okay.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_partialtext.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_passwd.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_process.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_really.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_reload.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_replication.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_rights.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_status.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_success.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_sync.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_tbl.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_theme.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_vars.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/s_views.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/spacer.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/tab_bg.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/tab_hover_bg.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/tabactive_bg.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/vertical_line.png
 +/usr/share/phpMyAdmin/themes/pmahomme/img/window-new.png
 +/usr/share/phpMyAdmin/themes/pmahomme/info.inc.php
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-bg_flat_0_aaaaaa_40x100.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-bg_flat_75_ffffff_40x100.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-bg_glass_55_fbf9ee_1x400.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-bg_glass_65_ffffff_1x400.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-bg_glass_75_dadada_1x400.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-bg_glass_75_e6e6e6_1x400.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-bg_glass_95_fef1ec_1x400.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-bg_highlight-soft_75_cccccc_1x100.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-icons_222222_256x240.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-icons_2e83ff_256x240.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-icons_454545_256x240.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-icons_888888_256x240.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/images/ui-icons_cd0a0a_256x240.png
 +/usr/share/phpMyAdmin/themes/pmahomme/jquery/jquery-ui-1.8.custom.css
 +/usr/share/phpMyAdmin/themes/pmahomme/layout.inc.php
 +/usr/share/phpMyAdmin/themes/pmahomme/screen.png
 +/usr/share/phpMyAdmin/themes/svg_gradient.php
 +/usr/share/phpMyAdmin/transformation_overview.php
 +/usr/share/phpMyAdmin/transformation_wrapper.php
 +/usr/share/phpMyAdmin/url.php
 +/usr/share/phpMyAdmin/user_password.php
 +/usr/share/phpMyAdmin/view_create.php
 +/usr/share/phpMyAdmin/view_operations.php
 +/usr/share/phpMyAdmin/webapp.php
 +/var/lib/phpMyAdmin
 +/var/lib/phpMyAdmin/config
 +/var/lib/phpMyAdmin/save
 +/var/lib/phpMyAdmin/upload
 +</code>
 +
 +===== Konfiguration =====
 +==== Anpassung Datenbankkonfiguration ====
 +In der Regel werden wir auf unserem Datenbank- keinen Webserver installiert haben, sondern hierzu zwei eigenständige Server verwenden.
 +Im Kapitel [[centos:mysql#installation_absichern|Installation absichern]] hatten wir bei der [[centos:mysql|Installation unseres MySQL-Datenbankservers]] unter anderem den Remotezugang für den Datenbankuser **root** unterbunden.
 +
 +Wir werden uns daher einen eigenen Datenbanknutzer anlegen, der die entsprechenden Rechte besitzt. Hierzu sind folgende Schritte notwendig:
 +  * neuen Benutzer anlegen
 +  * dem neuen Benutzer alle Privilegien
 +  * für einen remote Zugriff geben
 +  - **Anmelden auf dem Datenbankserver** \\ Als erstes melden wir uns auf unserem Datenbankserver als Nutzer **root** an. <code> mysql -h 127.0.0.1 -u root -p</code> <code>Enter password: 
 +Welcome to the MySQL monitor.  Commands end with ; or \g.
 +Your MySQL connection id is 2
 +Server version: 5.1.52 Source distribution
 +
 +Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
 +This software comes with ABSOLUTELY NO WARRANTY. This is free software,
 +and you are welcome to modify and redistribute it under the GPL v2 license
 +
 +Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 +
 +mysql>
 +</code>
 +  - **neuen Benutzer anlegen** \\ Mit folgendem Befehl legen wir uns einen neuen Nutzer an:<code>mysql> CREATE USER 'databaseuser'@'vml000090.dmz.nausch.org' IDENTIFIED BY 'databasepassword';
 +Query OK, 0 rows affected (0.00 sec)
 +
 +mysql>  </code> sowie <code>mysql> CREATE USER 'databaseuser'@'10.0.0.90' IDENTIFIED BY 'databasepassword';
 +Query OK, 0 rows affected (0.00 sec)
 +
 +mysql> </code>
 +  - **Benutzerprivilegien setzen und zuweisen** \\ Anschließend setzen wir die Benutzerrechte unseres gerade angelegten Datenbanknutzers. <code>mysql> GRANT ALL PRIVILEGES ON * . * TO 'databaseuser'@'vml000090.dmz.nausch.org' IDENTIFIED BY 'databasepassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
 +Query OK, 0 rows affected (0.01 sec)
 +
 +mysql></code> und <code>mysql> GRANT ALL PRIVILEGES ON * . * TO 'databaseuser'@'10.0.0.90' IDENTIFIED BY 'databasepassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
 +Query OK, 0 rows affected (0.01 sec)
 +
 +mysql></code>
 +  - **Rechte des Nutzers in der Datenbank neu laden** \\ Im letzten Schritt laden wir nun die Rechte unseres neuen Datenbankusers.<code>mysql> FLUSH PRIVILEGES;
 +Query OK, 0 rows affected (0.00 sec)
 +
 +mysql></code>
 +  - **mySQL-Datenbankverbindung beenden** \\ Unsere Konfiguration unseres neuen Datenbanknutzers ist hiermit beendet und wir können die Verbindung zur Datenbank wieder schließen.<code>mysql> exit
 +Bye
 +</code>
 +==== Anpassung Webserver ====
 +Hier haben wir nun zwei Möglichkeiten phpLDAPadmin bereitzustellen.
 +
 +=== phpldapadmin.conf ===
 +Im Verzeichnis **/etc/httpd/conf.d/** wurde bei der Installation des RPMs eine Konfigurationsdatei mit dem Namen **phpmyadmin.conf** mit folgendem Inhalte abgelegt:
 +<file apache /etc/httpd/conf.d/phpmyadmin.conf>
 +#
 +#  Web application to manage MySQL
 +#
 +
 +<Directory "/usr/share/phpmyadmin">
 +  Order Deny,Allow
 +  Deny from all
 +  Allow from 127.0.0.1
 +</Directory>
 +
 +Alias /phpmyadmin /usr/share/phpmyadmin
 +Alias /phpMyAdmin /usr/share/phpmyadmin
 +Alias /mysqladmin /usr/share/phpmyadmin
 +</file>
 +Bei Bedarf passen wir unserer Umgebung entsprechend an.
 +
 +=== virtueller Host ===
 +Oder wir legen uns alternativ zu der vorgenannten Variante einen vHOST an. Hierzu ergänzen wir unsere **/etc/httpd/conf.d/vhosts.conf** um folgende Zeilen.
 +<file apache /etc/httpd/conf.d/apache vhost.conf>
 +#
 +# Web application to manage MySQL
 +# phpmyadmin.nausch.org
 +#
 +<VirtualHost *:80>
 +        ServerAdmin webmaster@nausch.org
 +        ServerName phpmyadmin.nausch.org
 +        ServerAlias www.phpmyadmin.nausch.org
 +        ServerPath /
 +        DocumentRoot "/usr/share/phpMyAdmin"
 +        <Directory "/usr/share/phpMyAdmin">
 +                Options -Indexes FollowSymLinks
 +                AllowOverride None
 +                Order deny,allow
 +                Deny from all
 +                Allow from 127.0.0.1
 +                Allow from 10.0
 +        </Directory>
 +        <Directory "/usr/share/phpMyAdmin/setup">
 +                Options -Indexes FollowSymLinks
 +                AllowOverride None
 +                Order deny,allow
 +                Deny from all
 +                Allow from 127.0.0.1
 +                Allow from 10.0
 +        </Directory>
 +        <Directory "/usr/share/phpMyAdmin/libraries">
 +                Order deny,allow
 +                Deny from all
 +        </Directory>
 +        <Directory "/usr/share/phpMyAdmin/setup/lib">
 +                Order deny,allow
 +                Deny from all
 +        </Directory>
 +        <Directory "/usr/share/phpMyAdmin/setup/frames">
 +                Order deny,allow
 +                Deny from all
 +        </Directory>
 +        DirectoryIndex index.php
 +        ErrorLog logs/phpmyadmin_error.log
 +        CustomLog logs/phpmyadmin_access.log combined
 +</VirtualHost>
 +</file>
 +Nutzen wir die Zugriffsvariante über einen vHOST, so deaktivieren wir noch den Zugriff über das Verzeichnis, in dem wir die zugehörige Konfigurationsdatei umbenennen.
 +   # mv /etc/httpd/conf.d/phpmyadmin.conf /etc/httpd/conf.d/phpmyadmin.conf.orig
 +
 +Egal welche der beiden Variante wir nutzen, damit der Webserver von den Änderungen auch etwas mitbekommt ist dieser nurchzustarten.
 +   # service httpd restart
 +
 +   httpd beenden:                                              OK  ]
 +   httpd starten:                                              OK  ]
 +
 +===== Anwendungskonfiguration =====
 +Die Konfiguration der Webanwendung selbst kann über zwei Wege erfolgen. Entweder man editiert die aus dem RPM-Paket mitgelieferte Konfigurationsdatei //**/etc/phpMyAdmin/config.inc.php**// oder man benutzt die Konfigurationsseite der PHP-Anwendung selbst.
 +==== manueller Weg====
 +Möchte man die PHP-Anwendung per Hand editieren beutzt man seinen Editor der Wahl, so z.B. **vim** 
 +   # vim /etc/phpMyAdmin/config.inc.php
 +
 +<file php /etc/phpMyAdmin/config.inc.php>
 +<?php
 +/**
 + * phpMyAdmin configuration file, you can use it as base for the manual
 + * configuration. For easier setup you can use "setup/".
 + *
 + * All directives are explained in Documentation.html and on phpMyAdmin
 + * wiki <http://wiki.phpmyadmin.net>.
 + */
 +
 +/*
 + * This is needed for cookie based authentication to encrypt password in
 + * cookie
 + */
 +$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
 +
 +/**
 + * Server(s) configuration
 + */
 +$i = 0;
 +
 +// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use
 +// $cfg['Servers'][0]. You can disable a server config entry by setting host
 +// to ''. 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.
 +$i++;
 +$cfg['Servers'][$i]['host'         = 'localhost'; // MySQL hostname or IP address
 +$cfg['Servers'][$i]['port'         = '';          // MySQL port - leave blank for default port
 +$cfg['Servers'][$i]['socket'       = '';          // Path to the socket - leave blank for default socket
 +$cfg['Servers'][$i]['connect_type' = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
 +$cfg['Servers'][$i]['extension'    = 'mysqli';    // The php MySQL extension to use ('mysql' or 'mysqli')
 +$cfg['Servers'][$i]['compress'     = FALSE;       // Use compressed protocol for the MySQL connection
 +                                                    // (requires PHP >= 4.3.0)
 +$cfg['Servers'][$i]['controluser'  = '';          // MySQL control user settings
 +                                                    // (this user must have read-only
 +$cfg['Servers'][$i]['controlpass'  = '';          // access to the "mysql/user"
 +                                                    // and "mysql/db" tables).
 +                                                    // The controluser is also
 +                                                    // used for all relational
 +                                                    // features (pmadb)
 +$cfg['Servers'][$i]['auth_type'    = 'http';      // Authentication method (config, http or cookie based)?
 +$cfg['Servers'][$i]['user'         = '';          // MySQL user
 +$cfg['Servers'][$i]['password'     = '';          // MySQL password (only needed
 +                                                    // with 'config' auth_type)
 +$cfg['Servers'][$i]['only_db'      = '';          // If set to a db-name, only
 +                                                    // this db is displayed in left frame
 +                                                    // It may also be an array of db-names, where sorting order is relevant.
 +$cfg['Servers'][$i]['hide_db'      = '';          // Database name to be hidden from listings
 +$cfg['Servers'][$i]['verbose'      = '';          // Verbose name for this host - leave blank to show the hostname
 +
 +$cfg['Servers'][$i]['pmadb'        = '';          // Database used for Relation, Bookmark and PDF Features
 +                                                    // (see scripts/create_tables.sql)
 +                                                    //   - leave blank for no support
 +                                                    //     DEFAULT: 'phpmyadmin'
 +$cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
 +                                                    //   - leave blank for no bookmark support
 +                                                    //     DEFAULT: 'pma_bookmark'
 +$cfg['Servers'][$i]['relation'     = '';          // table to describe the relation between links (see doc)
 +                                                    //   - leave blank for no relation-links support
 +                                                    //     DEFAULT: 'pma_relation'
 +$cfg['Servers'][$i]['table_info'   = '';          // table to describe the display fields
 +                                                    //   - leave blank for no display fields support
 +                                                    //     DEFAULT: 'pma_table_info'
 +$cfg['Servers'][$i]['table_coords' = '';          // table to describe the tables position for the PDF schema
 +                                                    //   - leave blank for no PDF schema support
 +                                                    //     DEFAULT: 'pma_table_coords'
 +$cfg['Servers'][$i]['pdf_pages'    = '';          // table to describe pages of relationpdf
 +                                                    //   - leave blank if you don't want to use this
 +                                                    //     DEFAULT: 'pma_pdf_pages'
 +$cfg['Servers'][$i]['column_info'  = '';          // table to store column information
 +                                                    //   - leave blank for no column comments/mime types
 +                                                    //     DEFAULT: 'pma_column_info'
 +$cfg['Servers'][$i]['history'      = '';          // table to store SQL history
 +                                                    //   - leave blank for no SQL query history
 +                                                    //     DEFAULT: 'pma_history'
 +$cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
 +                                                    // are up to date. This prevents compatibility
 +                                                    // checks and thereby increases performance.
 +$cfg['Servers'][$i]['AllowRoot'    = TRUE;        // whether to allow root login
 +$cfg['Servers'][$i]['AllowDeny']['order'          // Host authentication order, leave blank to not use
 +                                     = '';
 +$cfg['Servers'][$i]['AllowDeny']['rules'          // Host authentication rules, leave blank for defaults
 +                                     = array();
 +$cfg['Servers'][$i]['AllowNoPassword'             // Allow logins without a password. Do not change the FALSE
 +                                     = FALSE;       // default unless you're running a passwordless MySQL server
 +$cfg['Servers'][$i]['designer_coords'             // Leave blank (default) for no Designer support, otherwise
 +                                     = '';          // set to suggested 'pma_designer_coords' if really needed
 +$cfg['Servers'][$i]['bs_garbage_threshold'        // Blobstreaming: Recommented default value from upstream
 +                                     = 50;          //   DEFAULT: '50'
 +$cfg['Servers'][$i]['bs_repository_threshold'     // Blobstreaming: Recommented default value from upstream
 +                                     = '32M';       //   DEFAULT: '32M'
 +$cfg['Servers'][$i]['bs_temp_blob_timeout'        // Blobstreaming: Recommented default value from upstream
 +                                     = 600;         //   DEFAULT: '600'
 +$cfg['Servers'][$i]['bs_temp_log_threshold'       // Blobstreaming: Recommented default value from upstream
 +                                     = '32M';       //   DEFAULT: '32M'
 +/*
 + * End of servers configuration
 + */
 +
 +/*
 + * Directories for saving/loading files from server
 + */
 +$cfg['UploadDir'] = '/var/lib/phpMyAdmin/upload';
 +$cfg['SaveDir'  = '/var/lib/phpMyAdmin/save';
 +
 +/*
 + * Disable the default warning that is displayed on the DB Details Structure
 + * page if any of the required Tables for the relation features is not found
 + */
 +$cfg['PmaNoRelation_DisableWarning'] = TRUE;
 +?>
 +</file>
 +==== menügeführte Konfiguration ====
 +Die komfortablere Variante ist sicherlich der Weg über die Webanwendung selbst. Die Konfigurationsseite von **phpMyAdmin** ist Dank unserer vHOST-Konfiguration an unserem Apache-Webserver,unter folgender URL erreichbar: http://phpmyadmin.nausch.org/setup/
 +
 +{{ :centos:phpmyadmin.png?600 |Bild: phpMyAdmin Konfigurationsbildschirm}} 
 +
 +Entscheiden wir uns für den menügeführten Weg, so müssen wir beachten, dass die hiermit erzeugte Konfigurationsdatei unter folgendem Verzeichnis abgelegt wird: //**/var/lib/phpMyAdmin/config**// 
 +
 +Damit nun diese automatisch erstellte Datei auch im Konfigurationsverzeichnis //**/etc/phpMyAdmin/**// vorliegt, verschieben wir die dortige Datei erst einmal. 
 +   # mv /etc/phpMyAdmin/config.inc.php /etc/phpMyAdmin/config.inc.php.orig 
 +
 +Anschließend verlinken wir die mit Hilfe der Konfiguartions-GUI erstelle Datei mit dem originaler Konfigurationstatei unter **/etc**. 
 +   # ln -s /var/lib/phpMyAdmin/config/config.inc.php /etc/phpMyAdmin/config.inc.php
 +
 +Das folgende Beispiel zeigt eine Konfigurationsdatei, die mit Hilfe der WebGUI erstellt wurde. 
 +<file php /etc/phpMyAdmin/config.inc.php>
 +<?php
 +/*
 + * Generated configuration file
 + * Generated by: phpMyAdmin 3.4.8 setup script
 + * Date: Sat, 07 Jan 2012 23:46:15 +0100
 + */
 +
 +/* Servers configuration */
 +$i = 0;
 +
 +/* Server: mysql.dmz.nausch.org [1] */
 +$i++;
 +$cfg['Servers'][$i]['verbose'] = 'mysql.dmz.nausch.org';
 +$cfg['Servers'][$i]['host'] = 'vml000090.dmz.nausch.org';
 +$cfg['Servers'][$i]['port'] = '';
 +$cfg['Servers'][$i]['socket'] = '';
 +$cfg['Servers'][$i]['connect_type'] = 'tcp';
 +$cfg['Servers'][$i]['extension'] = 'mysqli';
 +$cfg['Servers'][$i]['compress'] = true;
 +$cfg['Servers'][$i]['auth_type'] = 'cookie';
 +$cfg['Servers'][$i]['user'] = '';
 +$cfg['Servers'][$i]['password'] = '';
 +
 +/* End of servers configuration */
 +
 +$cfg['blowfish_secret'] = '4f08cb2c892551.14081967';
 +$cfg['DefaultLang'] = 'en';
 +$cfg['ServerDefault'] = 1;
 +$cfg['UploadDir'] = '';
 +$cfg['SaveDir'] = '';
 +?>
 +</file>
 +
 +===== erweiterte Konfiguration =====
 +==== PMADB ====
 +Mit Hilfe der **PMADB**((**P**HP**M**y**A**dmin**D**ata**B**ase)), einer internen Datenbanktabelle auf unserem Datenbankserver, können weitere Funktionen für phpMyAdmin zur Verfügung gestellt werden. 
 +
 +Folgende Zusatzfunktionen können Dank dieser Datenbanktabelle bei Bedarf genutzt werden:
 +  * **bookmarks** - Lesezeichen
 +  * **comments** - Kommentarmöglichkeiten
 +  * **SQL-history** - Historie von SQL-Befehlen
 +  * **tracking mechanism** - Aufzeichnungsmöglichkeiten und -funktionen
 +  * **PDF-generation** - Erstellen von PDF-Dateien bei der Ausgabe
 +
 +Für weitere detaillierte Informationen zu den Funktionen nutzt man am besten die Dokumente und Informationen auf der [[http://wiki.phpmyadmin.net/pma/pmadb|Wikiseite von phpMyAdmin]].
 +
 +Damit die oben aufgezeigten Zusatzfunktionen genutzt werden können, benötigen wir einen speziellen Nutzer, der vom Webserver aus auf die benötigte Tabelle zugreifen kann. Wir werden also die drei nötigen Schritte nacheinander vornehmen:
 +  - **Datenbanknutzer anlegen** \\ Auf unserem Datenbankserver verbinden wir uns als erstes als Datenbankuser **root** mit unserem Server. <code>$ mysql -h 127.0.0.1 -u root -p</code> <code>Enter password: 
 +Welcome to the MySQL monitor.  Commands end with ; or \g.
 +Your MySQL connection id is 13
 +Server version: 5.1.52 Source distribution
 +
 +Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
 +This software comes with ABSOLUTELY NO WARRANTY. This is free software,
 +and you are welcome to modify and redistribute it under the GPL v2 license
 +
 +Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 +
 +mysql>
 +</code> <code>mysql> CREATE USER 'datenbankuser'@'localhost' IDENTIFIED BY 'passwort';
 +Query OK, 0 rows affected (0.00 sec)
 +
 +mysql></code> <code>mysql> CREATE USER 'datenbankuser'@'127.0.0.1' IDENTIFIED BY 'passwort';
 +Query OK, 0 rows affected (0.00 sec)
 +
 +mysql></code> <code>mysql> CREATE USER 'datenbankuser'@'vml000090.dmz.nausch.org' IDENTIFIED BY 'passwort';
 +Query OK, 0 rows affected (0.00 sec)
 +
 +mysql></code> <code>mysql> CREATE USER 'datenbankuser'@'10.0.0.90' IDENTIFIED BY 'passwort';
 +Query OK, 0 rows affected (0.00 sec)
 +
 +mysql></code>
 +  - **Datenbank(tabellen) erstellen** \\ Die benötigte Datenbank mit ihren Tabellen erzeugen wir am einfachsten mit Hilfe des Scriptes \\ //**/usr/share/phpMyAdmin/scripts/create_tables.sql**// \\ welches bei der Installation des RPM-Paketes mitgeliefert wurde. <WRAP round important>Vor dem Start des Scriptes, muss dieses unbedingt noch den lokalen Gegebenheiten nach angepasst werden!</WRAP> Hierzu kopieren wir uns erst einmal das Beispielscript. <code># cp /usr/share/phpMyAdmin/scripts/create_tables.sql /usr/share/phpMyAdmin/scripts/create_tables_lokal.sql</code> Anschließend passen wir den Inhalt unseren lokalen Gegebenheiten an. <code># vim /usr/share/phpMyAdmin/scripts/create_tables_lokal.sql</code> Hier fügen wir beim Abschnitt **//-- Privileges//** folgende Zeilen ein:<code bash>-- 
 +-- Privileges
 +-- 
 +-- (activate this statement if necessary)
 +-- GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
 +--    'pma'@localhost;
 +-- Django : 2012-01-08
 +-- Anpassung an die lokalen Gegebenheiten, sprich Datenbankuser und Passwort
 +GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'datenbankuser'@localhost;
 +GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'datenbankuser'@127.0.0.1;
 +GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'datenbankuser'@vml000090.dmz.nausch.org;
 +GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'datenbankuser'@10.0.0.90;
 +
 +GRANT USAGE ON mysql.* TO 'datenbankuser'@'localhost';
 +GRANT SELECT (
 +  Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
 +  Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv,
 +  Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv
 +  ) ON mysql.user TO 'datenbankuser'@'localhost';
 +GRANT SELECT ON mysql.db TO 'datenbankuser'@'localhost';
 +GRANT SELECT ON mysql.host TO 'datenbankuser'@'localhost';
 +GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'datenbankuser'@'localhost';
 +
 +GRANT USAGE ON mysql.* TO 'datenbankuser'@'127.0.0.1';
 +GRANT SELECT (
 +  Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
 +  Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv,
 +  Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv
 +  ) ON mysql.user TO 'datenbankuser'@'127.0.0.1';
 +GRANT SELECT ON mysql.db TO 'datenbankuser'@'127.0.0.1';
 +GRANT SELECT ON mysql.host TO 'datenbankuser'@'127.0.0.1';
 +GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'datenbankuser'@'127.0.0.1';
 +
 +GRANT USAGE ON mysql.* TO 'datenbankuser'@'vml000090.dmz.nausch.org';
 +GRANT SELECT (
 +  Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
 +  Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv,
 +  Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv
 +  ) ON mysql.user TO 'datenbankuser'@'vml000090.dmz.nausch.org';
 +GRANT SELECT ON mysql.db TO 'datenbankuser'@'vml000090.dmz.nausch.org';
 +GRANT SELECT ON mysql.host TO 'datenbankuser'@'vml000090.dmz.nausch.org';
 +GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv
 +  TO 'datenbankuser'@'vml000090.dmz.nausch.org';
 +
 +GRANT USAGE ON mysql.* TO 'datenbankuser'@'10.0.0.90';
 +GRANT SELECT (
 +  Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
 +  Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv,
 +  Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv
 +  ) ON mysql.user TO 'datenbankuser'@'10.0.0.90';
 +GRANT SELECT ON mysql.db TO 'datenbankuser'@'10.0.0.90';
 +GRANT SELECT ON mysql.host TO 'datenbankuser'@'10.0.0.90';
 +GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'datenbankuser'@'10.0.0.90';
 +
 +</code>Unser angepasstes Script kopieren wir nun auf unseren Datenbankhost. <code># scp /usr/share/phpMyAdmin/scripts/create_tables_lokal.sql datenbankhost.dmz.nausch.org:/tmp/</code>Abschließend führen wird das Script mit unseren individuellen Ergänzungen wie folgt aus:<code>$ mysql -h 127.0.0.1 -u root -p < /tmp/create_tables_lokal.sql 
 +Enter password: 
 +</code>
 +Rufen wir nun erneut die Konfigurations-GUI über die URL http://www.phpmyadmin.nausch.org/setup/ auf, so können wir uns nachfolgende exemplarische Beispielskonfiguration erzeugen.
 +<file php /etc/phpMyAdmin/config.inc.php>
 +<?php
 +/*
 + * Generated configuration file
 + * Generated by: phpMyAdmin 3.4.8 setup script
 + * Date: Sun, 08 Jan 2012 14:10:27 +0100
 + */
 +
 +/* Servers configuration */
 +$i = 0;
 +
 +/* Server: mysql.dmz.nausch.org [1] */
 +$i++;
 +$cfg['Servers'][$i]['verbose'] = 'mysql.dmz.nausch.org';
 +$cfg['Servers'][$i]['host'] = 'vml000030.dmz.nausch.org';
 +$cfg['Servers'][$i]['port'] = '';
 +$cfg['Servers'][$i]['socket'] = '';
 +$cfg['Servers'][$i]['connect_type'] = 'tcp';
 +$cfg['Servers'][$i]['extension'] = 'mysqli';
 +$cfg['Servers'][$i]['compress'] = true;
 +$cfg['Servers'][$i]['auth_type'] = 'cookie';
 +$cfg['Servers'][$i]['user'] = '';
 +$cfg['Servers'][$i]['password'] = '';
 +$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
 +$cfg['Servers'][$i]['controluser'] = 'datenbankuser';
 +$cfg['Servers'][$i]['controlpass'] = 'passwort';
 +$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
 +$cfg['Servers'][$i]['relation'] = 'pma_relation';
 +$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
 +$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
 +$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
 +$cfg['Servers'][$i]['history'] = 'pma_history';
 +$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
 +$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
 +$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
 +$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
 +
 +/* End of servers configuration */
 +
 +$cfg['blowfish_secret'] = '4f08cb2c892551.14081967';
 +$cfg['DefaultLang'] = 'de';
 +$cfg['ServerDefault'] = 1;
 +$cfg['UploadDir'] = '/var/lib/phpMyAdmin/upload';
 +$cfg['SaveDir'] = '/var/lib/phpMyAdmin/save';
 +?>
 +</file>
 +http://www.phpmyadmin.nausch.org/setup/
 +
 +==== recode-Modul ====
 +Im Menüpunkt **Features** kann man im Reiter **Sonstige Einstellungen** die //**Umwandlungs Engine**// aktivieren.
 +
 +Damit diese Option aktiviert werden kann, __muß__ die php-Erweiterung **php-recode** aus dem Base-Repository installiert werden.
 +   # yum install php-recode -y 
 +
 +Was uns dieses Paket mitbringt zeigt uns ein Blick ins RPM.
 +   # rpm -qil php-recode
 +<code>Name        : php-recode                   Relocations: (not relocatable)
 +Version     : 5.3.2                             Vendor: CentOS
 +Release     : 6.el6_0.1                     Build Date: Sat 25 Jun 2011 09:35:37 AM CEST
 +Install Date: Sun 08 Jan 2012 02:34:32 PM CET      Build Host: c6b5.bsys.dev.centos.org
 +Group       : System Environment/Libraries   Source RPM: php-5.3.2-6.el6_0.1.src.rpm
 +Size        : 8349                             License: PHP
 +Signature   : RSA/8, Wed 06 Jul 2011 03:44:48 AM CEST, Key ID 0946fca2c105b9de
 +Packager    : CentOS BuildSystem <http://bugs.centos.org>
 +URL         : http://www.php.net/
 +Summary     : A module for PHP applications for using the recode library
 +Description :
 +The php-recode package contains a dynamic shared object that will add
 +support for using the recode library to PHP.
 +/etc/php.d/recode.ini
 +/usr/lib64/php/modules/recode.so
 +</code>
 +Damit unser Webserver Kenntnis von dem neuen PHP-Modul bekommt, starten wird diesen einmal durch.
 +   # service httpd restart
 +
 +   Stopping httpd:                                            [  OK  ]
 +   Starting httpd:                                            [  OK  ]
 +
 +==== SQL-Prüfung ====
 +Im Menüpunkt **SQL-Abfragen** kann man im Reiter **SQL-Prüfung** den //**SQL-Validator**// aktivieren.
 +<WRAP round important>Wenn man das SQL-Verlaufsprotokoll Service benutzt, ist zu beachten, dass alle SQL Abfragen anonymisiert gespeichert und für statistische Auswertungen benutzt werden können.</WRAP>
 +Damit diese Option aktiviert werden kann, __muß__ die php-Erweiterung **php-soap** aus dem Base-Repository installiert werden.
 +   # yum install php-soap -y 
 +
 +Was uns dieses Paket mitbringt zeigt uns ein Blick ins RPM.
 +   # rpm -qil php-soap
 +<code>Name        : php-soap                     Relocations: (not relocatable)
 +Version     : 5.3.2                             Vendor: CentOS
 +Release     : 6.el6_0.1                     Build Date: Sat 25 Jun 2011 09:35:37 AM CEST
 +Install Date: Sun 08 Jan 2012 02:38:27 PM CET      Build Host: c6b5.bsys.dev.centos.org
 +Group       : Development/Languages         Source RPM: php-5.3.2-6.el6_0.1.src.rpm
 +Size        : 331409                           License: PHP
 +Signature   : RSA/8, Wed 06 Jul 2011 03:44:49 AM CEST, Key ID 0946fca2c105b9de
 +Packager    : CentOS BuildSystem <http://bugs.centos.org>
 +URL         : http://www.php.net/
 +Summary     : A module for PHP applications that use the SOAP protocol
 +Description :
 +The php-soap package contains a dynamic shared object that will add
 +support to PHP for using the SOAP web services protocol.
 +/etc/php.d/soap.ini
 +/usr/lib64/php/modules/soap.so
 +</code>
 +
 +Damit unser Webserver Kenntnis von dem neuen PHP-Modul bekommt, starten wird diesen einmal durch.
 +   # service httpd restart
 +
 +   Stopping httpd:                                            [  OK  ]
 +   Starting httpd:                                            [  OK  ]
 +
 +Abschließend können wir nun erneut die Konfigurations-GUI über die URL http://www.phpmyadmin.nausch.org/setup/ aufrufen und die fehlenden Optionen aktivieren und konfigurieren. Somit ergibt sich abschließend folgende mögliche Musterkonfiguration:
 +<file php /etc/phpMyAdmin/config.inc.php><?php
 +/*
 + * Generated configuration file
 + * Generated by: phpMyAdmin 3.4.8 setup script
 + * Date: Sun, 08 Jan 2012 14:39:50 +0100
 + */
 +
 +/* Servers configuration */
 +$i = 0;
 +
 +/* Server: mysql.dmz.nausch.org [1] */
 +$i++;
 +$cfg['Servers'][$i]['verbose'] = 'mysql.dmz.nausch.org';
 +$cfg['Servers'][$i]['host'] = 'vml000030.dmz.nausch.org';
 +$cfg['Servers'][$i]['port'] = '';
 +$cfg['Servers'][$i]['socket'] = '';
 +$cfg['Servers'][$i]['connect_type'] = 'tcp';
 +$cfg['Servers'][$i]['extension'] = 'mysqli';
 +$cfg['Servers'][$i]['compress'] = true;
 +$cfg['Servers'][$i]['auth_type'] = 'cookie';
 +$cfg['Servers'][$i]['user'] = '';
 +$cfg['Servers'][$i]['password'] = '';
 +$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
 +$cfg['Servers'][$i]['controluser'] = 'datenbankuser';
 +$cfg['Servers'][$i]['controlpass'] = 'passwort';
 +$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
 +$cfg['Servers'][$i]['relation'] = 'pma_relation';
 +$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
 +$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
 +$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
 +$cfg['Servers'][$i]['history'] = 'pma_history';
 +$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
 +$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
 +$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
 +$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
 +
 +/* End of servers configuration */
 +
 +$cfg['blowfish_secret'] = '4f08cb2c892551.14081967';
 +$cfg['DefaultLang'] = 'de';
 +$cfg['ServerDefault'] = 1;
 +$cfg['UploadDir'] = '/var/lib/phpMyAdmin/upload';
 +$cfg['SaveDir'] = '/var/lib/phpMyAdmin/save';
 +$cfg['RecodingEngine'] = 'recode';
 +$cfg['SQLValidator']['use'] = true;
 +$cfg['SQLQuery']['Validate'] = true;
 +$cfg['LeftDisplayServers'] = true;
 +$cfg['DisplayServersList'] = true;
 +$cfg['PropertiesIconic'] = true;
 +?>
 +</file>
 +
 +====== Links ======
 +  * **[[wiki:start|Zurück zu >>Projekte und Themenkapitel<<]]**
 +  * **[[http://dokuwiki.nausch.org/doku.php/|Zurück zur Startseite]]**
 +
  
  • centos/phpmyadmin_c6.txt
  • Zuletzt geändert: 20.04.2018 10:36.
  • von 127.0.0.1