phpMyAdmin unter CentOS 6.x
Zur komfortablen Administration unseres mySQL-Datenbankserver unter CentOS 6.x greifen wir auf das PHP-Projekt phpMyAdmin zurück.
Installation
Zu erst installieren wir die benötigten Pakete und Programme.
Statt die Web-Applikation selbst aus den Programmquellen zu installieren, benutzen wir das vorgefertigte RPM aus dem Projekt Extra Packages for Enterprise Linux kurz EPEL. Hierzu binden wir erst einmal das EPEL-Repository, wie im Kapitel 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 MySQL-Datenbankserver unter CentOS 6.x und ein passender 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 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
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
Konfiguration
Anpassung Datenbankkonfiguration
In der Regel werden wir auf unserem Datenbank- keinen Webserver installiert haben, sondern hierzu zwei eigenständige Server verwenden. Im Kapitel Installation absichern hatten wir bei der 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.$ mysql -h 127.0.0.1 -u root -p
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>
- neuen Benutzer anlegen
Mit folgendem Befehl legen wir uns einen neuen Nutzer an:mysql> CREATE USER 'databaseuser'@'vml000090.dmz.nausch.org' IDENTIFIED BY 'databasepassword'; Query OK, 0 rows affected (0.00 sec) mysql>
sowie
mysql> CREATE USER 'databaseuser'@'10.0.0.90' IDENTIFIED BY 'databasepassword'; Query OK, 0 rows affected (0.00 sec) mysql>
- Benutzerprivilegien setzen und zuweisen
Anschließend setzen wir die Benutzerrechte unseres gerade angelegten Datenbanknutzers.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>
und
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>
- Rechte des Nutzers in der Datenbank neu laden
Im letzten Schritt laden wir nun die Rechte unseres neuen Datenbankusers.mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql>
- mySQL-Datenbankverbindung beenden
Unsere Konfiguration unseres neuen Datenbanknutzers ist hiermit beendet und wir können die Verbindung zur Datenbank wieder schließen.mysql> exit Bye
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:
- /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
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.
- /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>
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
- /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; ?>
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/
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.
- /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'] = ''; ?>
erweiterte Konfiguration
PMADB
Mit Hilfe der PMADB1), 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 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.$ mysql -h 127.0.0.1 -u root -p
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>
mysql> CREATE USER 'datenbankuser'@'localhost' IDENTIFIED BY 'passwort'; Query OK, 0 rows affected (0.00 sec) mysql>
mysql> CREATE USER 'datenbankuser'@'127.0.0.1' IDENTIFIED BY 'passwort'; Query OK, 0 rows affected (0.00 sec) mysql>
mysql> CREATE USER 'datenbankuser'@'vml000090.dmz.nausch.org' IDENTIFIED BY 'passwort'; Query OK, 0 rows affected (0.00 sec) mysql>
mysql> CREATE USER 'datenbankuser'@'10.0.0.90' IDENTIFIED BY 'passwort'; Query OK, 0 rows affected (0.00 sec) mysql>
- 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.Vor dem Start des Scriptes, muss dieses unbedingt noch den lokalen Gegebenheiten nach angepasst werden!
Hierzu kopieren wir uns erst einmal das Beispielscript.
# cp /usr/share/phpMyAdmin/scripts/create_tables.sql /usr/share/phpMyAdmin/scripts/create_tables_lokal.sql
Anschließend passen wir den Inhalt unseren lokalen Gegebenheiten an.
# vim /usr/share/phpMyAdmin/scripts/create_tables_lokal.sql
Hier fügen wir beim Abschnitt – Privileges folgende Zeilen ein:
-- -- 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';
Unser angepasstes Script kopieren wir nun auf unseren Datenbankhost.
# scp /usr/share/phpMyAdmin/scripts/create_tables_lokal.sql datenbankhost.dmz.nausch.org:/tmp/
Abschließend führen wird das Script mit unseren individuellen Ergänzungen wie folgt aus:
$ mysql -h 127.0.0.1 -u root -p < /tmp/create_tables_lokal.sql Enter password:
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.
- /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'; ?>
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
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
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.
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.
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
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
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:
- /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; ?>
Links
1)
PHPMyAdminDataBase
127.0.0.1