phpMyAdmin unter CentOS 7.x installieren und einrichten

Bild: phpMyAdmin Logo

Zur komfortablen Administration unseres MariaDB-Datenbankserver unter CentOS 7.x greifen wir auf das PHP-Projekt phpMyAdmin zurück.

Für unseren komfortablen Weg der Administration unseres MariaDB-Servers muß natürlich ein funktionstüchtiger MariaDB-Server unter CentOS 7.x und entweder ein passender Apache-Webserver oder der Webserver NGiNX zur Verfügung stehen. Es werden werden von phpldapadmin 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 bei der Grundinstallation 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.

 # systemctl reload httpd

bzw. im Falle von NGiNX:

 # systemctl reload nginx

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               
Version     : 4.3.6                    
Release     : 1.el7                    
Architecture: noarch                   
Install Date: Wed 21 Jan 2015 10:29:51 PM CET
Group       : Applications/Internet          
Size        : 21835060                       
License     : GPLv2+ and MIT                 
Signature   : RSA/SHA256, Fri 09 Jan 2015 01:41:52 AM CET, Key ID 6a2faea2352c64e5
Source RPM  : phpMyAdmin-4.3.6-1.el7.src.rpm                                      
Build Date  : Wed 07 Jan 2015 08:52:52 PM CET                                     
Build Host  : buildvm-01.phx2.fedoraproject.org                                   
Relocations : (not relocatable)                                                   
Packager    : Fedora Project                                                      
Vendor      : 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-4.3.6                                                
/usr/share/doc/phpMyAdmin-4.3.6/ChangeLog                                      
/usr/share/doc/phpMyAdmin-4.3.6/DCO                                            
/usr/share/doc/phpMyAdmin-4.3.6/README                                         
/usr/share/doc/phpMyAdmin-4.3.6/config.sample.inc.php                          
/usr/share/doc/phpMyAdmin-4.3.6/html                                           
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources                                  
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/config.txt                       
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/copyright.txt                    
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/credits.txt                      
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/developers.txt                   
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/faq.txt                          
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/glossary.txt                     
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/index.txt                        
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/intro.txt                        
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/other.txt                        
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/privileges.txt                   
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/require.txt                      
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/setup.txt                        
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/transformations.txt              
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/user.txt                         
/usr/share/doc/phpMyAdmin-4.3.6/html/_sources/vendors.txt                      
/usr/share/doc/phpMyAdmin-4.3.6/html/_static                                   
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/ajax-loader.gif                   
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/basic.css                         
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/comment-bright.png                
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/comment-close.png                 
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/comment.png                       
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/default.css                       
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/doctools.js                       
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/down-pressed.png                  
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/down.png                          
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/file.png                          
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/jquery.js                         
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/minus.png                         
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/plus.png                          
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/pygments.css                      
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/searchtools.js                    
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/sidebar.js                        
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/underscore.js                     
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/up-pressed.png                    
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/up.png                            
/usr/share/doc/phpMyAdmin-4.3.6/html/_static/websupport.js                     
/usr/share/doc/phpMyAdmin-4.3.6/html/config.html                               
/usr/share/doc/phpMyAdmin-4.3.6/html/copyright.html                            
/usr/share/doc/phpMyAdmin-4.3.6/html/credits.html                              
/usr/share/doc/phpMyAdmin-4.3.6/html/developers.html                           
/usr/share/doc/phpMyAdmin-4.3.6/html/faq.html                                  
/usr/share/doc/phpMyAdmin-4.3.6/html/genindex.html                             
/usr/share/doc/phpMyAdmin-4.3.6/html/glossary.html                             
/usr/share/doc/phpMyAdmin-4.3.6/html/index.html                                
/usr/share/doc/phpMyAdmin-4.3.6/html/intro.html                                
/usr/share/doc/phpMyAdmin-4.3.6/html/objects.inv                               
/usr/share/doc/phpMyAdmin-4.3.6/html/other.html                                
/usr/share/doc/phpMyAdmin-4.3.6/html/privileges.html                           
/usr/share/doc/phpMyAdmin-4.3.6/html/require.html                              
/usr/share/doc/phpMyAdmin-4.3.6/html/search.html                               
/usr/share/doc/phpMyAdmin-4.3.6/html/searchindex.js                            
/usr/share/doc/phpMyAdmin-4.3.6/html/setup.html                                
/usr/share/doc/phpMyAdmin-4.3.6/html/transformations.html                      
/usr/share/doc/phpMyAdmin-4.3.6/html/user.html                                 
/usr/share/doc/phpMyAdmin-4.3.6/html/vendors.html                              
/usr/share/licenses/phpMyAdmin-4.3.6                                           
/usr/share/licenses/phpMyAdmin-4.3.6/LICENSE                                   
/usr/share/licenses/phpMyAdmin-4.3.6/LICENSE-canvg                             
/usr/share/licenses/phpMyAdmin-4.3.6/LICENSE-codemirror                        
/usr/share/licenses/phpMyAdmin-4.3.6/LICENSE-jquery                            
/usr/share/phpMyAdmin                                                          
/usr/share/phpMyAdmin/browse_foreigners.php                                    
/usr/share/phpMyAdmin/changelog.php                                            
/usr/share/phpMyAdmin/chk_rel.php                                              
/usr/share/phpMyAdmin/composer.json                                            
/usr/share/phpMyAdmin/db_central_columns.php                                   
/usr/share/phpMyAdmin/db_create.php                                            
/usr/share/phpMyAdmin/db_datadict.php                                          
/usr/share/phpMyAdmin/db_designer.php                                          
/usr/share/phpMyAdmin/db_events.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_routines.php                                          
/usr/share/phpMyAdmin/db_search.php                                            
/usr/share/phpMyAdmin/db_sql.php                                               
/usr/share/phpMyAdmin/db_sql_autocomplete.php                                  
/usr/share/phpMyAdmin/db_structure.php                                         
/usr/share/phpMyAdmin/db_tracking.php                                          
/usr/share/phpMyAdmin/db_triggers.php                                          
/usr/share/phpMyAdmin/doc                                                      
/usr/share/phpMyAdmin/doc/html                                                 
/usr/share/phpMyAdmin/error_report.php                                         
/usr/share/phpMyAdmin/examples                                                 
/usr/share/phpMyAdmin/examples/config.manyhosts.inc.php                        
/usr/share/phpMyAdmin/examples/create_tables.sql                               
/usr/share/phpMyAdmin/examples/create_tables_drizzle.sql                       
/usr/share/phpMyAdmin/examples/openid.php                                      
/usr/share/phpMyAdmin/examples/signon-script.php                               
/usr/share/phpMyAdmin/examples/signon.php                                      
/usr/share/phpMyAdmin/examples/swekey.sample.conf                              
/usr/share/phpMyAdmin/examples/upgrade_column_info_4_3_0+.sql                  
/usr/share/phpMyAdmin/examples/upgrade_tables_mysql_4_1_2+.sql                 
/usr/share/phpMyAdmin/export.php                                               
/usr/share/phpMyAdmin/favicon.ico                                              
/usr/share/phpMyAdmin/file_echo.php                                            
/usr/share/phpMyAdmin/gis_data_editor.php                                      
/usr/share/phpMyAdmin/import.php                                               
/usr/share/phpMyAdmin/import_status.php                                        
/usr/share/phpMyAdmin/index.php                                                
/usr/share/phpMyAdmin/js                                                       
/usr/share/phpMyAdmin/js/OpenStreetMap.js                                      
/usr/share/phpMyAdmin/js/ajax.js                                               
/usr/share/phpMyAdmin/js/big_ints.js                                           
/usr/share/phpMyAdmin/js/canvg                                                 
/usr/share/phpMyAdmin/js/canvg/MIT-LICENSE.txt                                 
/usr/share/phpMyAdmin/js/canvg/canvg.js                                        
/usr/share/phpMyAdmin/js/chart.js                                              
/usr/share/phpMyAdmin/js/codemirror                                            
/usr/share/phpMyAdmin/js/codemirror/LICENSE                                    
/usr/share/phpMyAdmin/js/codemirror/addon                                      
/usr/share/phpMyAdmin/js/codemirror/addon/hint                                 
/usr/share/phpMyAdmin/js/codemirror/addon/hint/show-hint.js                    
/usr/share/phpMyAdmin/js/codemirror/addon/hint/sql-hint.js                     
/usr/share/phpMyAdmin/js/codemirror/addon/runmode                              
/usr/share/phpMyAdmin/js/codemirror/addon/runmode/runmode.js                   
/usr/share/phpMyAdmin/js/codemirror/lib                                        
/usr/share/phpMyAdmin/js/codemirror/lib/codemirror.js                          
/usr/share/phpMyAdmin/js/codemirror/mode                                       
/usr/share/phpMyAdmin/js/codemirror/mode/sql                                   
/usr/share/phpMyAdmin/js/codemirror/mode/sql/sql.js                            
/usr/share/phpMyAdmin/js/common.js                                             
/usr/share/phpMyAdmin/js/config.js                                             
/usr/share/phpMyAdmin/js/console.js                                            
/usr/share/phpMyAdmin/js/cross_framing_protection.js                           
/usr/share/phpMyAdmin/js/db_central_columns.js                                 
/usr/share/phpMyAdmin/js/db_operations.js                                      
/usr/share/phpMyAdmin/js/db_qbe.js                                             
/usr/share/phpMyAdmin/js/db_search.js                                          
/usr/share/phpMyAdmin/js/db_structure.js                                       
/usr/share/phpMyAdmin/js/doclinks.js                                           
/usr/share/phpMyAdmin/js/error_report.js                                       
/usr/share/phpMyAdmin/js/export.js                                             
/usr/share/phpMyAdmin/js/functions.js                                          
/usr/share/phpMyAdmin/js/get_image.js.php                                      
/usr/share/phpMyAdmin/js/get_scripts.js.php                                    
/usr/share/phpMyAdmin/js/gis_data_editor.js                                    
/usr/share/phpMyAdmin/js/import.js                                             
/usr/share/phpMyAdmin/js/indexes.js                                            
/usr/share/phpMyAdmin/js/jqplot                                                
/usr/share/phpMyAdmin/js/jqplot/excanvas.js                                    
/usr/share/phpMyAdmin/js/jqplot/jquery.jqplot.js                               
/usr/share/phpMyAdmin/js/jqplot/plugins                                        
/usr/share/phpMyAdmin/js/jqplot/plugins/jqplot.barRenderer.js                  
/usr/share/phpMyAdmin/js/jqplot/plugins/jqplot.byteFormatter.js                
/usr/share/phpMyAdmin/js/jqplot/plugins/jqplot.canvasAxisLabelRenderer.js      
/usr/share/phpMyAdmin/js/jqplot/plugins/jqplot.canvasTextRenderer.js           
/usr/share/phpMyAdmin/js/jqplot/plugins/jqplot.categoryAxisRenderer.js         
/usr/share/phpMyAdmin/js/jqplot/plugins/jqplot.cursor.js                       
/usr/share/phpMyAdmin/js/jqplot/plugins/jqplot.dateAxisRenderer.js             
/usr/share/phpMyAdmin/js/jqplot/plugins/jqplot.highlighter.js                  
/usr/share/phpMyAdmin/js/jqplot/plugins/jqplot.pieRenderer.js                  
/usr/share/phpMyAdmin/js/jqplot/plugins/jqplot.pointLabels.js                  
/usr/share/phpMyAdmin/js/jquery                                                
/usr/share/phpMyAdmin/js/jquery/MIT-LICENSE.txt                                
/usr/share/phpMyAdmin/js/jquery/jquery-1.8.3.min.js                            
/usr/share/phpMyAdmin/js/jquery/jquery-ui-1.9.2.custom.min.js                  
/usr/share/phpMyAdmin/js/jquery/jquery-ui-timepicker-addon.js                  
/usr/share/phpMyAdmin/js/jquery/jquery.ba-hashchange-1.3.js                    
/usr/share/phpMyAdmin/js/jquery/jquery.cookie.js                               
/usr/share/phpMyAdmin/js/jquery/jquery.debounce-1.0.5.js                       
/usr/share/phpMyAdmin/js/jquery/jquery.event.drag-2.2.js                       
/usr/share/phpMyAdmin/js/jquery/jquery.fullscreen.js                           
/usr/share/phpMyAdmin/js/jquery/jquery.mousewheel.js                           
/usr/share/phpMyAdmin/js/jquery/jquery.sortableTable.js                        
/usr/share/phpMyAdmin/js/jquery/jquery.svg.js                                  
/usr/share/phpMyAdmin/js/jquery/jquery.tablesorter.js                          
/usr/share/phpMyAdmin/js/jquery/jquery.uitablefilter.js                        
/usr/share/phpMyAdmin/js/keyhandler.js                                         
/usr/share/phpMyAdmin/js/line_counts.php                                       
/usr/share/phpMyAdmin/js/makegrid.js                                           
/usr/share/phpMyAdmin/js/menu-resizer.js                                       
/usr/share/phpMyAdmin/js/messages.php                                          
/usr/share/phpMyAdmin/js/multi_column_sort.js                                  
/usr/share/phpMyAdmin/js/navigation.js                                         
/usr/share/phpMyAdmin/js/normalization.js                                      
/usr/share/phpMyAdmin/js/openlayers                                            
/usr/share/phpMyAdmin/js/openlayers/OpenLayers.js                              
/usr/share/phpMyAdmin/js/openlayers/img                                        
/usr/share/phpMyAdmin/js/openlayers/img/blank.gif                              
/usr/share/phpMyAdmin/js/openlayers/img/cloud-popup-relative.png               
/usr/share/phpMyAdmin/js/openlayers/img/drag-rectangle-off.png                 
/usr/share/phpMyAdmin/js/openlayers/img/drag-rectangle-on.png                  
/usr/share/phpMyAdmin/js/openlayers/img/east-mini.png                          
/usr/share/phpMyAdmin/js/openlayers/img/layer-switcher-maximize.png            
/usr/share/phpMyAdmin/js/openlayers/img/layer-switcher-minimize.png            
/usr/share/phpMyAdmin/js/openlayers/img/marker-blue.png                        
/usr/share/phpMyAdmin/js/openlayers/img/marker-gold.png                        
/usr/share/phpMyAdmin/js/openlayers/img/marker-green.png                       
/usr/share/phpMyAdmin/js/openlayers/img/marker.png                             
/usr/share/phpMyAdmin/js/openlayers/img/measuring-stick-off.png                
/usr/share/phpMyAdmin/js/openlayers/img/measuring-stick-on.png                 
/usr/share/phpMyAdmin/js/openlayers/img/north-mini.png                         
/usr/share/phpMyAdmin/js/openlayers/img/panning-hand-off.png                   
/usr/share/phpMyAdmin/js/openlayers/img/panning-hand-on.png                    
/usr/share/phpMyAdmin/js/openlayers/img/slider.png                             
/usr/share/phpMyAdmin/js/openlayers/img/south-mini.png                         
/usr/share/phpMyAdmin/js/openlayers/img/west-mini.png                          
/usr/share/phpMyAdmin/js/openlayers/img/zoom-minus-mini.png                    
/usr/share/phpMyAdmin/js/openlayers/img/zoom-plus-mini.png                     
/usr/share/phpMyAdmin/js/openlayers/img/zoom-world-mini.png                    
/usr/share/phpMyAdmin/js/openlayers/img/zoombar.png                            
/usr/share/phpMyAdmin/js/openlayers/theme                                      
/usr/share/phpMyAdmin/js/openlayers/theme/default                              
/usr/share/phpMyAdmin/js/openlayers/theme/default/framedCloud.css              
/usr/share/phpMyAdmin/js/openlayers/theme/default/google.css                   
/usr/share/phpMyAdmin/js/openlayers/theme/default/ie6-style.css                
/usr/share/phpMyAdmin/js/openlayers/theme/default/img                          
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/add_point_off.png        
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/add_point_on.png         
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/blank.gif                
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/close.gif                
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/drag-rectangle-off.png   
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/drag-rectangle-on.png    
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/draw_line_off.png        
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/draw_line_on.png         
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/draw_point_off.png       
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/draw_point_on.png        
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/draw_polygon_off.png     
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/draw_polygon_on.png      
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/editing_tool_bar.png     
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/move_feature_off.png     
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/move_feature_on.png      
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/navigation_history.png   
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/overview_replacement.gif 
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/pan-panel-NOALPHA.png    
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/pan-panel.png            
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/pan_off.png              
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/pan_on.png               
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/panning-hand-off.png     
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/panning-hand-on.png      
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/remove_point_off.png     
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/remove_point_on.png      
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/ruler.png                
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/save_features_off.png    
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/save_features_on.png     
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/view_next_off.png        
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/view_next_on.png         
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/view_previous_off.png    
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/view_previous_on.png     
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/zoom-panel-NOALPHA.png   
/usr/share/phpMyAdmin/js/openlayers/theme/default/img/zoom-panel.png           
/usr/share/phpMyAdmin/js/openlayers/theme/default/style.css                    
/usr/share/phpMyAdmin/js/pmd                                                   
/usr/share/phpMyAdmin/js/pmd/designer_db.js                                    
/usr/share/phpMyAdmin/js/pmd/designer_objects.js                               
/usr/share/phpMyAdmin/js/pmd/designer_page.js                                  
/usr/share/phpMyAdmin/js/pmd/history.js                                        
/usr/share/phpMyAdmin/js/pmd/iecanvas.js                                       
/usr/share/phpMyAdmin/js/pmd/init.js                                           
/usr/share/phpMyAdmin/js/pmd/move.js                                           
/usr/share/phpMyAdmin/js/replication.js                                        
/usr/share/phpMyAdmin/js/rte.js                                                
/usr/share/phpMyAdmin/js/server_databases.js                                   
/usr/share/phpMyAdmin/js/server_plugins.js                                     
/usr/share/phpMyAdmin/js/server_privileges.js                                  
/usr/share/phpMyAdmin/js/server_status_advisor.js                              
/usr/share/phpMyAdmin/js/server_status_monitor.js                              
/usr/share/phpMyAdmin/js/server_status_processes.js                            
/usr/share/phpMyAdmin/js/server_status_queries.js                              
/usr/share/phpMyAdmin/js/server_status_sorter.js                               
/usr/share/phpMyAdmin/js/server_status_variables.js                            
/usr/share/phpMyAdmin/js/server_user_groups.js                                 
/usr/share/phpMyAdmin/js/server_variables.js                                   
/usr/share/phpMyAdmin/js/sprintf.js                                            
/usr/share/phpMyAdmin/js/sql.js                                                
/usr/share/phpMyAdmin/js/tbl_change.js                                         
/usr/share/phpMyAdmin/js/tbl_chart.js                                          
/usr/share/phpMyAdmin/js/tbl_find_replace.js                                   
/usr/share/phpMyAdmin/js/tbl_gis_visualization.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/tbl_zoom_plot_jqplot.js                               
/usr/share/phpMyAdmin/js/tracekit                                              
/usr/share/phpMyAdmin/js/tracekit/tracekit.js                                  
/usr/share/phpMyAdmin/js/transformations                                       
/usr/share/phpMyAdmin/js/transformations/image_upload.js                       
/usr/share/phpMyAdmin/js/whitelist.php                                         
/usr/share/phpMyAdmin/libraries                                                
/usr/share/phpMyAdmin/libraries/Advisor.class.php                              
/usr/share/phpMyAdmin/libraries/Config.class.php                               
/usr/share/phpMyAdmin/libraries/Console.class.php                              
/usr/share/phpMyAdmin/libraries/DBQbe.class.php                                
/usr/share/phpMyAdmin/libraries/DatabaseInterface.class.php                    
/usr/share/phpMyAdmin/libraries/DbSearch.class.php                             
/usr/share/phpMyAdmin/libraries/DisplayResults.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/Font.class.php                                 
/usr/share/phpMyAdmin/libraries/Footer.class.php                               
/usr/share/phpMyAdmin/libraries/Header.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/Menu.class.php                                 
/usr/share/phpMyAdmin/libraries/Message.class.php                              
/usr/share/phpMyAdmin/libraries/OutputBuffering.class.php                      
/usr/share/phpMyAdmin/libraries/PDF.class.php                                  
/usr/share/phpMyAdmin/libraries/PMA.php                                        
/usr/share/phpMyAdmin/libraries/Partition.class.php                            
/usr/share/phpMyAdmin/libraries/RecentFavoriteTable.class.php                  
/usr/share/phpMyAdmin/libraries/Response.class.php                             
/usr/share/phpMyAdmin/libraries/SavedSearches.class.php                        
/usr/share/phpMyAdmin/libraries/Scripts.class.php                              
/usr/share/phpMyAdmin/libraries/ServerStatusData.class.php                     
/usr/share/phpMyAdmin/libraries/StorageEngine.class.php                        
/usr/share/phpMyAdmin/libraries/String.class.php                               
/usr/share/phpMyAdmin/libraries/StringAbstractType.class.php                   
/usr/share/phpMyAdmin/libraries/StringByte.int.php                             
/usr/share/phpMyAdmin/libraries/StringCType.class.php                          
/usr/share/phpMyAdmin/libraries/StringNativeType.class.php                     
/usr/share/phpMyAdmin/libraries/StringType.int.php                             
/usr/share/phpMyAdmin/libraries/Table.class.php                                
/usr/share/phpMyAdmin/libraries/TableSearch.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/Types.class.php                                
/usr/share/phpMyAdmin/libraries/Util.class.php                                 
/usr/share/phpMyAdmin/libraries/advisory_rules.txt                             
/usr/share/phpMyAdmin/libraries/bfShapeFiles                                   
/usr/share/phpMyAdmin/libraries/bfShapeFiles/ShapeFile.lib.php                 
/usr/share/phpMyAdmin/libraries/bookmark.lib.php                               
/usr/share/phpMyAdmin/libraries/browse_foreigners.lib.php                      
/usr/share/phpMyAdmin/libraries/build_html_for_db.lib.php                      
/usr/share/phpMyAdmin/libraries/central_columns.lib.php                        
/usr/share/phpMyAdmin/libraries/charset_conversion.lib.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/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/ServerConfigChecks.class.php            
/usr/share/phpMyAdmin/libraries/config/Validator.class.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/core.lib.php                                   
/usr/share/phpMyAdmin/libraries/create_addfield.lib.php                        
/usr/share/phpMyAdmin/libraries/data_dictionary_relations.lib.php              
/usr/share/phpMyAdmin/libraries/database_interface.inc.php                     
/usr/share/phpMyAdmin/libraries/db_common.inc.php                              
/usr/share/phpMyAdmin/libraries/db_designer.lib.php                            
/usr/share/phpMyAdmin/libraries/db_info.inc.php                                
/usr/share/phpMyAdmin/libraries/db_printview.lib.php                           
/usr/share/phpMyAdmin/libraries/db_table_exists.lib.php                        
/usr/share/phpMyAdmin/libraries/dbi                                            
/usr/share/phpMyAdmin/libraries/dbi/DBIDrizzle.class.php                       
/usr/share/phpMyAdmin/libraries/dbi/DBIDummy.class.php                         
/usr/share/phpMyAdmin/libraries/dbi/DBIExtension.int.php                       
/usr/share/phpMyAdmin/libraries/dbi/DBIMysql.class.php                         
/usr/share/phpMyAdmin/libraries/dbi/DBIMysqli.class.php                        
/usr/share/phpMyAdmin/libraries/dbi/drizzle-wrappers.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.inc.php                         
/usr/share/phpMyAdmin/libraries/display_export.lib.php                         
/usr/share/phpMyAdmin/libraries/display_git_revision.lib.php                   
/usr/share/phpMyAdmin/libraries/display_import.inc.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_structure.inc.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/pbxt.lib.php                           
/usr/share/phpMyAdmin/libraries/engines/performance_schema.lib.php             
/usr/share/phpMyAdmin/libraries/error.inc.php                                  
/usr/share/phpMyAdmin/libraries/error_report.lib.php                           
/usr/share/phpMyAdmin/libraries/export.lib.php                                 
/usr/share/phpMyAdmin/libraries/file_listing.lib.php                           
/usr/share/phpMyAdmin/libraries/gis                                            
/usr/share/phpMyAdmin/libraries/gis/GIS_Factory.class.php                      
/usr/share/phpMyAdmin/libraries/gis/GIS_Geometry.class.php                     
/usr/share/phpMyAdmin/libraries/gis/GIS_Geometrycollection.class.php           
/usr/share/phpMyAdmin/libraries/gis/GIS_Linestring.class.php                   
/usr/share/phpMyAdmin/libraries/gis/GIS_Multilinestring.class.php              
/usr/share/phpMyAdmin/libraries/gis/GIS_Multipoint.class.php                   
/usr/share/phpMyAdmin/libraries/gis/GIS_Multipolygon.class.php                 
/usr/share/phpMyAdmin/libraries/gis/GIS_Point.class.php                        
/usr/share/phpMyAdmin/libraries/gis/GIS_Polygon.class.php                      
/usr/share/phpMyAdmin/libraries/gis/GIS_Visualization.class.php                
/usr/share/phpMyAdmin/libraries/iconv_wrapper.lib.php                          
/usr/share/phpMyAdmin/libraries/import.lib.php                                 
/usr/share/phpMyAdmin/libraries/index.lib.php                                  
/usr/share/phpMyAdmin/libraries/information_schema_relations.lib.php           
/usr/share/phpMyAdmin/libraries/insert_edit.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/mult_submits.lib.php                           
/usr/share/phpMyAdmin/libraries/mysql_charsets.inc.php                         
/usr/share/phpMyAdmin/libraries/mysql_charsets.lib.php                         
/usr/share/phpMyAdmin/libraries/navigation                                     
/usr/share/phpMyAdmin/libraries/navigation/Navigation.class.php                
/usr/share/phpMyAdmin/libraries/navigation/NavigationHeader.class.php          
/usr/share/phpMyAdmin/libraries/navigation/NavigationTree.class.php            
/usr/share/phpMyAdmin/libraries/navigation/NodeFactory.class.php               
/usr/share/phpMyAdmin/libraries/navigation/Nodes                               
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node.class.php                
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Column.class.php         
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Column_Container.class.php
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Database.class.php        
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_DatabaseChild.class.php   
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Database_Container.class.php
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Event.class.php             
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Event_Container.class.php   
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Function.class.php          
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Function_Container.class.php
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Index.class.php             
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Index_Container.class.php   
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Procedure.class.php         
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Procedure_Container.class.php
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Table.class.php              
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Table_Container.class.php    
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Trigger.class.php            
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_Trigger_Container.class.php  
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_View.class.php               
/usr/share/phpMyAdmin/libraries/navigation/Nodes/Node_View_Container.class.php     
/usr/share/phpMyAdmin/libraries/normalization.lib.php                              
/usr/share/phpMyAdmin/libraries/opendocument.lib.php                               
/usr/share/phpMyAdmin/libraries/operations.lib.php                                 
/usr/share/phpMyAdmin/libraries/parse_analyze.inc.php                              
/usr/share/phpMyAdmin/libraries/plugin_interface.lib.php                           
/usr/share/phpMyAdmin/libraries/plugins                                            
/usr/share/phpMyAdmin/libraries/plugins/AuthenticationPlugin.class.php             
/usr/share/phpMyAdmin/libraries/plugins/ExportPlugin.class.php                     
/usr/share/phpMyAdmin/libraries/plugins/IOTransformationsPlugin.class.php          
/usr/share/phpMyAdmin/libraries/plugins/ImportPlugin.class.php                     
/usr/share/phpMyAdmin/libraries/plugins/SchemaPlugin.class.php                     
/usr/share/phpMyAdmin/libraries/plugins/TransformationsInterface.int.php           
/usr/share/phpMyAdmin/libraries/plugins/TransformationsPlugin.class.php            
/usr/share/phpMyAdmin/libraries/plugins/UploadInterface.int.php                    
/usr/share/phpMyAdmin/libraries/plugins/auth                                       
/usr/share/phpMyAdmin/libraries/plugins/auth/AuthenticationConfig.class.php        
/usr/share/phpMyAdmin/libraries/plugins/auth/AuthenticationCookie.class.php        
/usr/share/phpMyAdmin/libraries/plugins/auth/AuthenticationHttp.class.php          
/usr/share/phpMyAdmin/libraries/plugins/auth/AuthenticationSignon.class.php        
/usr/share/phpMyAdmin/libraries/plugins/auth/recaptchalib.php                      
/usr/share/phpMyAdmin/libraries/plugins/auth/swekey                                
/usr/share/phpMyAdmin/libraries/plugins/auth/swekey/authentication.inc.php         
/usr/share/phpMyAdmin/libraries/plugins/auth/swekey/musbe-ca.crt                   
/usr/share/phpMyAdmin/libraries/plugins/auth/swekey/swekey.auth.lib.php            
/usr/share/phpMyAdmin/libraries/plugins/auth/swekey/swekey.php                     
/usr/share/phpMyAdmin/libraries/plugins/export                                     
/usr/share/phpMyAdmin/libraries/plugins/export/ExportCodegen.class.php             
/usr/share/phpMyAdmin/libraries/plugins/export/ExportCsv.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/export/ExportExcel.class.php               
/usr/share/phpMyAdmin/libraries/plugins/export/ExportHtmlword.class.php            
/usr/share/phpMyAdmin/libraries/plugins/export/ExportJson.class.php                
/usr/share/phpMyAdmin/libraries/plugins/export/ExportLatex.class.php               
/usr/share/phpMyAdmin/libraries/plugins/export/ExportMediawiki.class.php           
/usr/share/phpMyAdmin/libraries/plugins/export/ExportOds.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/export/ExportOdt.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/export/ExportPdf.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/export/ExportPhparray.class.php            
/usr/share/phpMyAdmin/libraries/plugins/export/ExportSql.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/export/ExportTexytext.class.php            
/usr/share/phpMyAdmin/libraries/plugins/export/ExportXml.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/export/ExportYaml.class.php                
/usr/share/phpMyAdmin/libraries/plugins/export/PMA_ExportPdf.class.php             
/usr/share/phpMyAdmin/libraries/plugins/export/README                              
/usr/share/phpMyAdmin/libraries/plugins/export/TableProperty.class.php             
/usr/share/phpMyAdmin/libraries/plugins/import                                     
/usr/share/phpMyAdmin/libraries/plugins/import/AbstractImportCsv.class.php         
/usr/share/phpMyAdmin/libraries/plugins/import/ImportCsv.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/import/ImportLdi.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/import/ImportMediawiki.class.php           
/usr/share/phpMyAdmin/libraries/plugins/import/ImportOds.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/import/ImportShp.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/import/ImportSql.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/import/ImportXml.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/import/README                              
/usr/share/phpMyAdmin/libraries/plugins/import/ShapeFile.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/import/ShapeRecord.class.php               
/usr/share/phpMyAdmin/libraries/plugins/import/upload                              
/usr/share/phpMyAdmin/libraries/plugins/import/upload/UploadApc.class.php          
/usr/share/phpMyAdmin/libraries/plugins/import/upload/UploadNoplugin.class.php     
/usr/share/phpMyAdmin/libraries/plugins/import/upload/UploadProgress.class.php     
/usr/share/phpMyAdmin/libraries/plugins/import/upload/UploadSession.class.php      
/usr/share/phpMyAdmin/libraries/plugins/schema                                     
/usr/share/phpMyAdmin/libraries/plugins/schema/Export_Relation_Schema.class.php    
/usr/share/phpMyAdmin/libraries/plugins/schema/RelationStats.class.php             
/usr/share/phpMyAdmin/libraries/plugins/schema/SchemaDia.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/schema/SchemaEps.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/schema/SchemaPdf.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/schema/SchemaSvg.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/schema/TableStats.class.php                
/usr/share/phpMyAdmin/libraries/plugins/schema/dia                                 
/usr/share/phpMyAdmin/libraries/plugins/schema/dia/Dia_Relation_Schema.class.php   
/usr/share/phpMyAdmin/libraries/plugins/schema/dia/RelationStatsDia.class.php      
/usr/share/phpMyAdmin/libraries/plugins/schema/dia/TableStatsDia.class.php         
/usr/share/phpMyAdmin/libraries/plugins/schema/eps                                 
/usr/share/phpMyAdmin/libraries/plugins/schema/eps/Eps_Relation_Schema.class.php   
/usr/share/phpMyAdmin/libraries/plugins/schema/eps/RelationStatsEps.class.php      
/usr/share/phpMyAdmin/libraries/plugins/schema/eps/TableStatsEps.class.php         
/usr/share/phpMyAdmin/libraries/plugins/schema/pdf                                 
/usr/share/phpMyAdmin/libraries/plugins/schema/pdf/Pdf_Relation_Schema.class.php   
/usr/share/phpMyAdmin/libraries/plugins/schema/pdf/RelationStatsPdf.class.php      
/usr/share/phpMyAdmin/libraries/plugins/schema/pdf/TableStatsPdf.class.php         
/usr/share/phpMyAdmin/libraries/plugins/schema/svg                                 
/usr/share/phpMyAdmin/libraries/plugins/schema/svg/RelationStatsSvg.class.php      
/usr/share/phpMyAdmin/libraries/plugins/schema/svg/Svg_Relation_Schema.class.php   
/usr/share/phpMyAdmin/libraries/plugins/schema/svg/TableStatsSvg.class.php         
/usr/share/phpMyAdmin/libraries/plugins/transformations                            
/usr/share/phpMyAdmin/libraries/plugins/transformations/README                     
/usr/share/phpMyAdmin/libraries/plugins/transformations/TEMPLATE                   
/usr/share/phpMyAdmin/libraries/plugins/transformations/TEMPLATE_ABSTRACT          
/usr/share/phpMyAdmin/libraries/plugins/transformations/Text_Plain_Link.class.php  
/usr/share/phpMyAdmin/libraries/plugins/transformations/Text_Plain_Longtoipv4.class.php
/usr/share/phpMyAdmin/libraries/plugins/transformations/Text_Plain_Preappend.class.php 
/usr/share/phpMyAdmin/libraries/plugins/transformations/Text_Plain_Substring.class.php 
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract                       
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/Bool2TextTransformationsPlugin.class.php
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/DateFormatTransformationsPlugin.class.php
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/DownloadTransformationsPlugin.class.php  
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/ExternalTransformationsPlugin.class.php  
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/FormattedTransformationsPlugin.class.php 
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/HexTransformationsPlugin.class.php       
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/ImageLinkTransformationsPlugin.class.php 
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/ImageUploadTransformationsPlugin.class.php
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/InlineTransformationsPlugin.class.php     
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/LongToIPv4TransformationsPlugin.class.php 
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/PreApPendTransformationsPlugin.class.php  
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/RegexValidationTransformationsPlugin.class.php
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/SQLTransformationsPlugin.class.php            
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/SubstringTransformationsPlugin.class.php      
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/TextFileUploadTransformationsPlugin.class.php 
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/TextImageLinkTransformationsPlugin.class.php  
/usr/share/phpMyAdmin/libraries/plugins/transformations/abstract/TextLinkTransformationsPlugin.class.php       
/usr/share/phpMyAdmin/libraries/plugins/transformations/generator_main_class.sh                                
/usr/share/phpMyAdmin/libraries/plugins/transformations/generator_plugin.sh                                    
/usr/share/phpMyAdmin/libraries/plugins/transformations/input                                                  
/usr/share/phpMyAdmin/libraries/plugins/transformations/input/Image_JPEG_Upload.class.php                      
/usr/share/phpMyAdmin/libraries/plugins/transformations/input/Text_Plain_Fileupload.class.php                  
/usr/share/phpMyAdmin/libraries/plugins/transformations/input/Text_Plain_Regexvalidation.class.php             
/usr/share/phpMyAdmin/libraries/plugins/transformations/output                                                 
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Application_Octetstream_Download.class.php      
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Application_Octetstream_Hex.class.php           
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Image_JPEG_Inline.class.php                     
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Image_JPEG_Link.class.php                       
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Image_PNG_Inline.class.php                      
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Text_Plain_Bool2text.class.php                  
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Text_Plain_Dateformat.class.php                 
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Text_Plain_External.class.php                   
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Text_Plain_Formatted.class.php                  
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Text_Plain_Imagelink.class.php                  
/usr/share/phpMyAdmin/libraries/plugins/transformations/output/Text_Plain_Sql.class.php                        
/usr/share/phpMyAdmin/libraries/pmd_common.php                                                                 
/usr/share/phpMyAdmin/libraries/properties                                                                     
/usr/share/phpMyAdmin/libraries/properties/PropertyItem.class.php                                              
/usr/share/phpMyAdmin/libraries/properties/options                                                             
/usr/share/phpMyAdmin/libraries/properties/options/OptionsPropertyGroup.class.php                              
/usr/share/phpMyAdmin/libraries/properties/options/OptionsPropertyItem.class.php                               
/usr/share/phpMyAdmin/libraries/properties/options/OptionsPropertyOneItem.class.php                            
/usr/share/phpMyAdmin/libraries/properties/options/groups                                                      
/usr/share/phpMyAdmin/libraries/properties/options/groups/OptionsPropertyMainGroup.class.php                   
/usr/share/phpMyAdmin/libraries/properties/options/groups/OptionsPropertyRootGroup.class.php                   
/usr/share/phpMyAdmin/libraries/properties/options/groups/OptionsPropertySubgroup.class.php                    
/usr/share/phpMyAdmin/libraries/properties/options/items                                                       
/usr/share/phpMyAdmin/libraries/properties/options/items/BoolPropertyItem.class.php                            
/usr/share/phpMyAdmin/libraries/properties/options/items/DocPropertyItem.class.php                             
/usr/share/phpMyAdmin/libraries/properties/options/items/HiddenPropertyItem.class.php                          
/usr/share/phpMyAdmin/libraries/properties/options/items/MessageOnlyPropertyItem.class.php                     
/usr/share/phpMyAdmin/libraries/properties/options/items/NumberPropertyItem.class.php                          
/usr/share/phpMyAdmin/libraries/properties/options/items/RadioPropertyItem.class.php                           
/usr/share/phpMyAdmin/libraries/properties/options/items/SelectPropertyItem.class.php                          
/usr/share/phpMyAdmin/libraries/properties/options/items/TextPropertyItem.class.php                            
/usr/share/phpMyAdmin/libraries/properties/plugins                                                             
/usr/share/phpMyAdmin/libraries/properties/plugins/ExportPluginProperties.class.php                            
/usr/share/phpMyAdmin/libraries/properties/plugins/ImportPluginProperties.class.php                            
/usr/share/phpMyAdmin/libraries/properties/plugins/PluginPropertyItem.class.php                                
/usr/share/phpMyAdmin/libraries/properties/plugins/SchemaPluginProperties.class.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/rte                                                                            
/usr/share/phpMyAdmin/libraries/rte/rte_events.lib.php                                                         
/usr/share/phpMyAdmin/libraries/rte/rte_export.lib.php                                                         
/usr/share/phpMyAdmin/libraries/rte/rte_footer.lib.php                                                         
/usr/share/phpMyAdmin/libraries/rte/rte_general.lib.php                                                        
/usr/share/phpMyAdmin/libraries/rte/rte_list.lib.php                                                           
/usr/share/phpMyAdmin/libraries/rte/rte_main.inc.php                                                           
/usr/share/phpMyAdmin/libraries/rte/rte_routines.lib.php                                                       
/usr/share/phpMyAdmin/libraries/rte/rte_triggers.lib.php                                                       
/usr/share/phpMyAdmin/libraries/rte/rte_words.lib.php                                                          
/usr/share/phpMyAdmin/libraries/sanitizing.lib.php                                                             
/usr/share/phpMyAdmin/libraries/select_lang.lib.php                                                            
/usr/share/phpMyAdmin/libraries/select_server.lib.php                                                          
/usr/share/phpMyAdmin/libraries/server_bin_log.lib.php                                                         
/usr/share/phpMyAdmin/libraries/server_collations.lib.php                                                      
/usr/share/phpMyAdmin/libraries/server_common.inc.php                                                          
/usr/share/phpMyAdmin/libraries/server_common.lib.php                                                          
/usr/share/phpMyAdmin/libraries/server_databases.lib.php                                                       
/usr/share/phpMyAdmin/libraries/server_engines.lib.php                                                         
/usr/share/phpMyAdmin/libraries/server_plugins.lib.php                                                         
/usr/share/phpMyAdmin/libraries/server_privileges.lib.php                                                      
/usr/share/phpMyAdmin/libraries/server_status.lib.php                                                          
/usr/share/phpMyAdmin/libraries/server_status_advisor.lib.php                                                  
/usr/share/phpMyAdmin/libraries/server_status_monitor.lib.php                                                  
/usr/share/phpMyAdmin/libraries/server_status_processes.lib.php                                                
/usr/share/phpMyAdmin/libraries/server_status_queries.lib.php                                                  
/usr/share/phpMyAdmin/libraries/server_status_variables.lib.php                                                
/usr/share/phpMyAdmin/libraries/server_user_groups.lib.php                                                     
/usr/share/phpMyAdmin/libraries/server_users.lib.php                                                           
/usr/share/phpMyAdmin/libraries/server_variables.lib.php                                                       
/usr/share/phpMyAdmin/libraries/session.inc.php                                                                
/usr/share/phpMyAdmin/libraries/special_schema_links.lib.php                                                   
/usr/share/phpMyAdmin/libraries/sql.lib.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/string.lib.php                                                                 
/usr/share/phpMyAdmin/libraries/stringMb.lib.php                                                               
/usr/share/phpMyAdmin/libraries/stringNative.lib.php                                                           
/usr/share/phpMyAdmin/libraries/structure.lib.php                                                              
/usr/share/phpMyAdmin/libraries/sysinfo.lib.php                                                                
/usr/share/phpMyAdmin/libraries/tbl_chart.lib.php                                                              
/usr/share/phpMyAdmin/libraries/tbl_columns_definition_form.inc.php                                            
/usr/share/phpMyAdmin/libraries/tbl_columns_definition_form.lib.php                                            
/usr/share/phpMyAdmin/libraries/tbl_common.inc.php                                                             
/usr/share/phpMyAdmin/libraries/tbl_gis_visualization.lib.php                                                  
/usr/share/phpMyAdmin/libraries/tbl_indexes.lib.php                                                            
/usr/share/phpMyAdmin/libraries/tbl_info.inc.php                                                               
/usr/share/phpMyAdmin/libraries/tbl_printview.lib.php                                                          
/usr/share/phpMyAdmin/libraries/tbl_relation.lib.php                                                           
/usr/share/phpMyAdmin/libraries/tbl_views.lib.php                                                              
/usr/share/phpMyAdmin/libraries/tracking.lib.php                                                               
/usr/share/phpMyAdmin/libraries/transformations.lib.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/az                                                                                
/usr/share/phpMyAdmin/locale/az/LC_MESSAGES                                                                    
/usr/share/phpMyAdmin/locale/az/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/hu                                                                                
/usr/share/phpMyAdmin/locale/hu/LC_MESSAGES                                                                    
/usr/share/phpMyAdmin/locale/hu/LC_MESSAGES/phpmyadmin.mo                                                      
/usr/share/phpMyAdmin/locale/ia                                                                                
/usr/share/phpMyAdmin/locale/ia/LC_MESSAGES                                                                    
/usr/share/phpMyAdmin/locale/ia/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/ko                                                                                
/usr/share/phpMyAdmin/locale/ko/LC_MESSAGES                                                                    
/usr/share/phpMyAdmin/locale/ko/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/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                                                                                
/usr/share/phpMyAdmin/locale/pt/LC_MESSAGES                                                                    
/usr/share/phpMyAdmin/locale/pt/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/sq                                                                                
/usr/share/phpMyAdmin/locale/sq/LC_MESSAGES                                                                    
/usr/share/phpMyAdmin/locale/sq/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/uk                                                                                
/usr/share/phpMyAdmin/locale/uk/LC_MESSAGES                                                                    
/usr/share/phpMyAdmin/locale/uk/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/navigation.php                                                                           
/usr/share/phpMyAdmin/normalization.php                                                                        
/usr/share/phpMyAdmin/phpinfo.php                                                                              
/usr/share/phpMyAdmin/phpmyadmin.css.php                                                                       
/usr/share/phpMyAdmin/phpunit.xml.hhvm                                                                         
/usr/share/phpMyAdmin/phpunit.xml.nocoverage                                                                   
/usr/share/phpMyAdmin/prefs_forms.php                                                                          
/usr/share/phpMyAdmin/prefs_manage.php                                                                         
/usr/share/phpMyAdmin/print.css                                                                                
/usr/share/phpMyAdmin/schema_export.php                                                                        
/usr/share/phpMyAdmin/scripts                                                                                  
/usr/share/phpMyAdmin/scripts/decode_bug.php                                                                   
/usr/share/phpMyAdmin/scripts/line-counts.sh                                                                   
/usr/share/phpMyAdmin/scripts/revision-info                                                                    
/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_plugins.php                                                                       
/usr/share/phpMyAdmin/server_privileges.php                                                                    
/usr/share/phpMyAdmin/server_replication.php                                                                   
/usr/share/phpMyAdmin/server_sql.php                                                                           
/usr/share/phpMyAdmin/server_status.php                                                                        
/usr/share/phpMyAdmin/server_status_advisor.php                                                                
/usr/share/phpMyAdmin/server_status_monitor.php                                                                
/usr/share/phpMyAdmin/server_status_processes.php                                                              
/usr/share/phpMyAdmin/server_status_queries.php                                                                
/usr/share/phpMyAdmin/server_status_variables.php                                                              
/usr/share/phpMyAdmin/server_user_groups.php                                                                   
/usr/share/phpMyAdmin/server_variables.php                                                                     
/usr/share/phpMyAdmin/setup                                                                                    
/usr/share/phpMyAdmin/setup/ajax.js                                                                            
/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_change.php                                                                           
/usr/share/phpMyAdmin/tbl_chart.php                                                                            
/usr/share/phpMyAdmin/tbl_create.php                                                                           
/usr/share/phpMyAdmin/tbl_export.php                                                                           
/usr/share/phpMyAdmin/tbl_find_replace.php                                                                     
/usr/share/phpMyAdmin/tbl_get_field.php                                                                        
/usr/share/phpMyAdmin/tbl_gis_visualization.php                                                                
/usr/share/phpMyAdmin/tbl_import.php                                                                           
/usr/share/phpMyAdmin/tbl_indexes.php                                                                          
/usr/share/phpMyAdmin/tbl_operations.php                                                                       
/usr/share/phpMyAdmin/tbl_printview.php                                                                        
/usr/share/phpMyAdmin/tbl_recent_favorite.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/tbl_triggers.php                                                                         
/usr/share/phpMyAdmin/tbl_zoom_select.php                                                                      
/usr/share/phpMyAdmin/themes                                                                                   
/usr/share/phpMyAdmin/themes.php                                                                               
/usr/share/phpMyAdmin/themes/dot.gif                                                                           
/usr/share/phpMyAdmin/themes/original                                                                          
/usr/share/phpMyAdmin/themes/original/css                                                                      
/usr/share/phpMyAdmin/themes/original/css/common.css.php                                                       
/usr/share/phpMyAdmin/themes/original/css/navigation.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_column_add.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_event_add.png                                                      
/usr/share/phpMyAdmin/themes/original/img/b_events.png                                                         
/usr/share/phpMyAdmin/themes/original/img/b_export.png                                                         
/usr/share/phpMyAdmin/themes/original/img/b_favorite.png                                                       
/usr/share/phpMyAdmin/themes/original/img/b_find_replace.png                                                   
/usr/share/phpMyAdmin/themes/original/img/b_ftext.png                                                          
/usr/share/phpMyAdmin/themes/original/img/b_globe.gif                                                          
/usr/share/phpMyAdmin/themes/original/img/b_group.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_index_add.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_move.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_nextpage.png                                                       
/usr/share/phpMyAdmin/themes/original/img/b_no_favorite.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_routine_add.png                                                    
/usr/share/phpMyAdmin/themes/original/img/b_routines.png                                                       
/usr/share/phpMyAdmin/themes/original/img/b_save.png                                                           
/usr/share/phpMyAdmin/themes/original/img/b_saveimage.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_spatial.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_table_add.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_trigger_add.png                                                    
/usr/share/phpMyAdmin/themes/original/img/b_triggers.png                                                       
/usr/share/phpMyAdmin/themes/original/img/b_undo.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_view_add.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_edit.png                                                          
/usr/share/phpMyAdmin/themes/original/img/bd_empty.png                                                         
/usr/share/phpMyAdmin/themes/original/img/bd_export.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_nextpage.png                                                      
/usr/share/phpMyAdmin/themes/original/img/bd_primary.png                                                       
/usr/share/phpMyAdmin/themes/original/img/bd_routine_add.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_spatial.png                                                       
/usr/share/phpMyAdmin/themes/original/img/bd_unique.png                                                        
/usr/share/phpMyAdmin/themes/original/img/centralColumns.png                                                   
/usr/share/phpMyAdmin/themes/original/img/centralColumns_add.png                                               
/usr/share/phpMyAdmin/themes/original/img/centralColumns_delete.png                                            
/usr/share/phpMyAdmin/themes/original/img/cleardot.gif                                                         
/usr/share/phpMyAdmin/themes/original/img/col_drop.png                                                         
/usr/share/phpMyAdmin/themes/original/img/col_pointer.png                                                      
/usr/share/phpMyAdmin/themes/original/img/col_pointer_ver.png                                                  
/usr/share/phpMyAdmin/themes/original/img/console.png                                                          
/usr/share/phpMyAdmin/themes/original/img/east-mini.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/lightbulb.png                                                        
/usr/share/phpMyAdmin/themes/original/img/lightbulb_off.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.png                                                         
/usr/share/phpMyAdmin/themes/original/img/new_data_hovered.png                                                 
/usr/share/phpMyAdmin/themes/original/img/new_data_selected.png                                                
/usr/share/phpMyAdmin/themes/original/img/new_data_selected_hovered.png                                        
/usr/share/phpMyAdmin/themes/original/img/new_struct.png                                                       
/usr/share/phpMyAdmin/themes/original/img/new_struct_hovered.png                                               
/usr/share/phpMyAdmin/themes/original/img/new_struct_selected.png                                              
/usr/share/phpMyAdmin/themes/original/img/new_struct_selected_hovered.png                                      
/usr/share/phpMyAdmin/themes/original/img/normalize.png                                                        
/usr/share/phpMyAdmin/themes/original/img/north-mini.png                                                       
/usr/share/phpMyAdmin/themes/original/img/pause.png                                                            
/usr/share/phpMyAdmin/themes/original/img/play.png                                                             
/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_attention.png                                                      
/usr/share/phpMyAdmin/themes/original/img/s_cancel.png                                                         
/usr/share/phpMyAdmin/themes/original/img/s_cog.png                                                            
/usr/share/phpMyAdmin/themes/original/img/s_collapseall.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_info.png                                                           
/usr/share/phpMyAdmin/themes/original/img/s_lang.png                                                           
/usr/share/phpMyAdmin/themes/original/img/s_link.png                                                           
/usr/share/phpMyAdmin/themes/original/img/s_lock.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_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_sortable.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_top.png                                                            
/usr/share/phpMyAdmin/themes/original/img/s_unlink.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/south-mini.png                                                       
/usr/share/phpMyAdmin/themes/original/img/spacer.png                                                           
/usr/share/phpMyAdmin/themes/original/img/sprites.png                                                          
/usr/share/phpMyAdmin/themes/original/img/toggle-ltr.png                                                       
/usr/share/phpMyAdmin/themes/original/img/toggle-rtl.png                                                       
/usr/share/phpMyAdmin/themes/original/img/vertical_line.png                                                    
/usr/share/phpMyAdmin/themes/original/img/west-mini.png                                                        
/usr/share/phpMyAdmin/themes/original/img/window-new.png                                                       
/usr/share/phpMyAdmin/themes/original/img/zoom-minus-mini.png                                                  
/usr/share/phpMyAdmin/themes/original/img/zoom-plus-mini.png                                                   
/usr/share/phpMyAdmin/themes/original/img/zoom-world-mini.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.9.2.custom.css                                        
/usr/share/phpMyAdmin/themes/original/layout.inc.php                                                           
/usr/share/phpMyAdmin/themes/original/screen.png                                                               
/usr/share/phpMyAdmin/themes/original/sprites.lib.php                                                          
/usr/share/phpMyAdmin/themes/pmahomme                                                                          
/usr/share/phpMyAdmin/themes/pmahomme/css                                                                      
/usr/share/phpMyAdmin/themes/pmahomme/css/codemirror.css.php                                                   
/usr/share/phpMyAdmin/themes/pmahomme/css/common.css.php                                                       
/usr/share/phpMyAdmin/themes/pmahomme/css/enum_editor.css.php                                                  
/usr/share/phpMyAdmin/themes/pmahomme/css/gis.css.php                                                          
/usr/share/phpMyAdmin/themes/pmahomme/css/jqplot.css.php                                                       
/usr/share/phpMyAdmin/themes/pmahomme/css/navigation.css.php                                                   
/usr/share/phpMyAdmin/themes/pmahomme/css/pmd.css.php                                                          
/usr/share/phpMyAdmin/themes/pmahomme/css/resizable-menu.css.php                                               
/usr/share/phpMyAdmin/themes/pmahomme/css/rte.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_column_add.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_event_add.png                                                      
/usr/share/phpMyAdmin/themes/pmahomme/img/b_events.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/b_export.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/b_favorite.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/b_find_replace.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_globe.gif                                                          
/usr/share/phpMyAdmin/themes/pmahomme/img/b_group.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_index_add.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_move.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_no_favorite.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_routine_add.png                                                    
/usr/share/phpMyAdmin/themes/pmahomme/img/b_routines.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/b_save.png                                                           
/usr/share/phpMyAdmin/themes/pmahomme/img/b_saveimage.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_spatial.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_table_add.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_trigger_add.png                                                    
/usr/share/phpMyAdmin/themes/pmahomme/img/b_triggers.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/b_undo.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_view_add.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_edit.png                                                          
/usr/share/phpMyAdmin/themes/pmahomme/img/bd_empty.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/bd_export.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_routine_add.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_spatial.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/bd_unique.png                                                        
/usr/share/phpMyAdmin/themes/pmahomme/img/centralColumns.png                                                   
/usr/share/phpMyAdmin/themes/pmahomme/img/centralColumns_add.png                                               
/usr/share/phpMyAdmin/themes/pmahomme/img/centralColumns_delete.png                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/col_drop.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/col_pointer.png                                                      
/usr/share/phpMyAdmin/themes/pmahomme/img/col_pointer_ver.png                                                  
/usr/share/phpMyAdmin/themes/pmahomme/img/console.png                                                          
/usr/share/phpMyAdmin/themes/pmahomme/img/database.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/east-mini.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/item.png                                                             
/usr/share/phpMyAdmin/themes/pmahomme/img/left_nav_bg.png                                                      
/usr/share/phpMyAdmin/themes/pmahomme/img/lightbulb.png                                                        
/usr/share/phpMyAdmin/themes/pmahomme/img/lightbulb_off.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/more.png                                                             
/usr/share/phpMyAdmin/themes/pmahomme/img/new_data.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/new_data_hovered.png                                                 
/usr/share/phpMyAdmin/themes/pmahomme/img/new_data_selected.png                                                
/usr/share/phpMyAdmin/themes/pmahomme/img/new_data_selected_hovered.png                                        
/usr/share/phpMyAdmin/themes/pmahomme/img/new_struct.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/new_struct_hovered.png                                               
/usr/share/phpMyAdmin/themes/pmahomme/img/new_struct_selected.png                                              
/usr/share/phpMyAdmin/themes/pmahomme/img/new_struct_selected_hovered.png                                      
/usr/share/phpMyAdmin/themes/pmahomme/img/normalize.png                                                        
/usr/share/phpMyAdmin/themes/pmahomme/img/north-mini.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/pause.png                                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/php_sym.png                                                          
/usr/share/phpMyAdmin/themes/pmahomme/img/play.png                                                             
/usr/share/phpMyAdmin/themes/pmahomme/img/pma_logo2.png                                                        
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd                                                                  
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/1.png                                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/2.png                                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/2leftarrow.png                                                   
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/2leftarrow_m.png                                                 
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/2rightarrow.png                                                  
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/2rightarrow_m.png                                                
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/3.png                                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/4.png                                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/5.png                                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/6.png                                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/7.png                                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/8.png                                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/FieldKey_small.png                                               
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/Field_small.png                                                  
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/Field_small_char.png                                             
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/Field_small_date.png                                             
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/Field_small_int.png                                              
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/Header.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/Header_Linked.png                                                
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/and_icon.png                                                     
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/ang_direct.png                                                   
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/bord.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/bottom.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/def.png                                                          
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/display_field.png                                                
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/downarrow1.png                                                   
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/downarrow2.png                                                   
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/downarrow2_m.png                                                 
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/exec.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/exec_small.png                                                   
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/exitFullscreen.png                                               
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/export.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/favicon.ico                                                      
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/grid.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/help.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/help_relation.png                                                
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/left_panel_butt.png                                              
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/left_panel_tab.png                                               
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/minus.png                                                        
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/or_icon.png                                                      
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/page_add.png                                                     
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/page_delete.png                                                  
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/page_edit.png                                                    
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/pdf.png                                                          
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/plus.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/query_builder.png                                                
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/relation.png                                                     
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/reload.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/resize.png                                                       
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/rightarrow1.png                                                  
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/rightarrow2.png                                                  
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/save.png                                                         
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/save_as.png                                                      
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/small_tab.png                                                    
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/table.png                                                        
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/toggle_lines.png                                                 
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/top_panel.png                                                    
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/uparrow2_m.png                                                   
/usr/share/phpMyAdmin/themes/pmahomme/img/pmd/viewInFullscreen.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_cog.png                                                            
/usr/share/phpMyAdmin/themes/pmahomme/img/s_collapseall.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_link.png                                                           
/usr/share/phpMyAdmin/themes/pmahomme/img/s_lock.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_sortable.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_top.png
/usr/share/phpMyAdmin/themes/pmahomme/img/s_unlink.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/south-mini.png
/usr/share/phpMyAdmin/themes/pmahomme/img/spacer.png
/usr/share/phpMyAdmin/themes/pmahomme/img/sprites.png
/usr/share/phpMyAdmin/themes/pmahomme/img/toggle-ltr.png
/usr/share/phpMyAdmin/themes/pmahomme/img/toggle-rtl.png
/usr/share/phpMyAdmin/themes/pmahomme/img/vertical_line.png
/usr/share/phpMyAdmin/themes/pmahomme/img/west-mini.png
/usr/share/phpMyAdmin/themes/pmahomme/img/window-new.png
/usr/share/phpMyAdmin/themes/pmahomme/img/zoom-minus-mini.png
/usr/share/phpMyAdmin/themes/pmahomme/img/zoom-plus-mini.png
/usr/share/phpMyAdmin/themes/pmahomme/img/zoom-world-mini.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.9.2.custom.css
/usr/share/phpMyAdmin/themes/pmahomme/layout.inc.php
/usr/share/phpMyAdmin/themes/pmahomme/screen.png
/usr/share/phpMyAdmin/themes/pmahomme/sprites.lib.php
/usr/share/phpMyAdmin/themes/sprites.css.php
/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/version_check.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

Im ersten Konfigurationsbeispiel richten wir uns einen vHOST für unseren Apache-Webserver ein. Hier wurde bei der Installation bereits eine passende Konfigurationsdatei in den Apache-Konfigurationspfad eingestellt. Diese Konfigurationsdatei passen wir unseren Gegebenheiten entsprechend an.

 # vim /etc/httpd/conf.d/phpMyAdmin.conf
/etc/httpd/conf.d/phpMyAdmin.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
                Require all granted
        </Directory>
        <Directory "/usr/share/phpMyAdmin/setup">
                Options -Indexes FollowSymLinks
                AllowOverride None
                Require ip 10.0.0.20
                Require ip 127.0.0.1
                Require ip ::1
        </Directory>
        <Directory "/usr/share/phpMyAdmin/libraries">
                Require all denied
        </Directory>
        <Directory "/usr/share/phpMyAdmin/setup/lib">
                Require all denied
        </Directory>
        <Directory "/usr/share/phpMyAdmin/setup/frames">
                Require all denied
        </Directory>
        DirectoryIndex index.php
        ErrorLog logs/phpmyadmin_error.log
        CustomLog logs/phpmyadmin_access.log combined
</VirtualHost>

Haben wir die Konfigurationsdatei vervollständigt, prüfen wir diese noch auf syntaktische Fehler.

 # apachectl -t
 Syntax OK

Ein reload unseres Apache Webserver reicht nun aus, um den neuen vHOST verfügbar zu haben.

 # systemctl reload httpd

Haben wir als Webserver einen NGiNX unter der Motorhaube ist die Konfiguration unseres vHOST auch kein großes Hexenwerk.

/etc/nginx/conf.d/phpmyadmin.conf
server {
        listen          80;
        server_name     phpmyadmin.nausch.org www.phpmyadmin.nausch.org;
        access_log      /var/log/nginx/phpmyadmin_access.log;
        error_log       /var/log/nginx/phpmyadmin_errors.log;
        root /usr/share/phpMyAdmin;
 
        location / {
                index  index.php;
        }
 
        ## Images and static content is treated different
        location ~* ^.+.(jpg|jpeg|gif|css|png|js|ico|xml)$ {
               access_log        off;
               expires           360d;
        }
 
        location ~ /\.ht {
               deny all;
        }
 
        location ~ /(libraries|setup/frames|setup/libs) {
               deny all;
               return 404;
        }
 
        location ~ \.php$ {
                fastcgi_split_path_info ^(.+\.php)(/.+)$;
                fastcgi_index index.php;
                fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
                include fastcgi_params;
        }
}

Den Parameter fastcgi_pass setzen wir im übrigen auf den Wert aus der Konfigurationsdatei /etc/php-fpm.d/www.conf des PHP FastCGI Process Manager-Daemon php-fpm.

Haben wir die Konfigurationsdatei vervollständigt, prüfen wir diese noch auf syntaktische Fehler.

 # nginx -t
 nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
 nginx: configuration file /etc/nginx/nginx.conf test is successful

Somit können wir unsere Konfiguration nun noch aktivieren.

 # systemctl reload nginx

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 MariaDB-Servers 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:

  1. Anmelden auf dem Datenbankserver
  2. Neuen Benutzer anlegen
  3. Benutzerprivilegien setzen und zuweisen
  4. Rechte des Nutzers in der Datenbank neu laden
  5. Beenden der Verbindung zum Datenbankserver
  1. Anmelden auf dem Datenbankserver
    Wir melden uns also als berechtigter Datenbankuser an der MariaDB an.
     # mysql -h localhost -u root -p
    Enter password: 
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 42
    Server version: 5.5.40-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB>
  2. neuen Benutzer anlegen
    Mit folgendem Befehl legen wir uns einen neuen Nutzer an:
    MariaDB> CREATE USER 'databaseuser'@'vml000097.dmz.nausch.org' IDENTIFIED BY 'databasepassword';
    Query OK, 0 rows affected (0.00 sec)

    sowie

    MariaDB> CREATE USER 'databaseuser'@'10.0.0.97' IDENTIFIED BY 'databasepassword';
    Query OK, 0 rows affected (0.00 sec)
  3. Benutzerprivilegien setzen und zuweisen
    Anschließend setzen wir die Benutzerrechte unseres gerade angelegten Datenbanknutzers.
    MariaDB> GRANT ALL PRIVILEGES ON * . * TO 'databaseuser'@'vml000097.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.00 sec)

    und

    MariaDB> 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.00 sec)
  4. Rechte des Nutzers in der Datenbank neu laden
    Im letzten Schritt laden wir nun die Rechte unseres neuen Datenbankusers.
    MariaDB> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.00 sec)
  5. Datenbankverbindung beenden
    Unsere Konfiguration unseres neuen Datenbanknutzers ist hiermit beendet und wir können die Verbindung zur Datenbank wieder schließen.
    MariaDB> exit
    Bye

Zugriff testen

Zum Schluß überprüfen wir, ob der zuvor angelegt User/Zugang auch vom Webserver aus funktioniert.

 # mysql -h mysql.dmz.nausch.org -u databaseuser -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 1269396
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
 MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cacti              |
| dmarc              |
| fhem               |
| horde              |
| horde5             |
| mail               |
| mysql              |
| opendmarc          |
| phpmyadmin         |
| postfix            |
| roundcubemail      |
| webstats           |
| wviewDB            |
+--------------------+
15 rows in set (0.00 sec)

MariaDB [(none)]>

Da der Test positiv ausgefallen ist, können wie uns wieder von unserem Datenbankserver abmelden.

 MariaDB [(none)]> quit
 Bye

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
  • column contents transformation - Umwandlung/Konvertierung von Inhalten einzelner Spalten

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
  • Datenbank(tabellen) erstellen
  • phpMyAdmin konfigurieren

Datenbanknutzer anlegen

Im ersten Schritt legen wir uns unseren controluser an:

  1. Anmelden auf dem Datenbankserver
  2. Neuen Benutzer anlegen
  3. Beenden der Verbindung zum Datenbankserver
  1. Anmelden auf dem Datenbankserver
    Wir melden uns also als berechtigter Datenbankuser an der MariaDB an.
     # mysql -h localhost -u root -p
    Enter password: 
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 42
    Server version: 5.5.40-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB>
  2. neuen Benutzer anlegen
    Mit folgendem Befehl legen wir uns einen neuen Nutzer an:
    MariaDB> CREATE USER 'controluser'@'vml000097.dmz.nausch.org' IDENTIFIED BY 'controlpassword';
    Query OK, 0 rows affected (0.00 sec)

    sowie

    MariaDB> CREATE USER 'controluser'@'10.0.0.97' IDENTIFIED BY 'controlpassword';
    Query OK, 0 rows affected (0.00 sec)
  3. Datenbankverbindung beenden
    Unsere Konfiguration unseres neuen Datenbanknutzers ist hiermit beendet und wir können die Verbindung zur Datenbank wieder schließen.
    MariaDB> exit
    Bye

Datenbank(tabellen) erstellen

Zum Erstellen der benötigten Tabelle greifen wir auf die Datei /usr/share/phpMyAdmin/examples/create_tables.sql zurück. Diese Musterdatei kopieren wir uns zunächst in das Verzeichnis /root/.

 # cp /usr/share/phpMyAdmin/sql/create_tables.sql /root/create_pmadb_tables.sql


Vor dem Start des Scriptes, muss dieses unbedingt noch den lokalen Gegebenheiten nach angepasst werden!

Anschließend passen wir den Inhalt unseren lokalen Gegebenheiten an.

 # vim /root/create_pmadb_tables.sql

Hier fügen wir beim Abschnitt – Privileges folgende Zeilen ein:

- --------------------------------------------------------
 
--
-- Privileges
--
-- (activate this statement if necessary)
-- GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON `phpmyadmin`.* TO
--    'pma'@localhost;
 
-- Grant privileges to phpMyAdmin controluser.
GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON `phpmyadmin`.* TO 'controluser'@'10.0.0.97';
GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON `phpmyadmin`.* TO 'controluser'@'vml000097.dmz.nausch.org';
 
-- Reload privileges.
FLUSH PRIVILEGES;
 
-- --------------------------------------------------------

Somit ergibt sich folgende komplette Datei.

/root/create_pmadb_tables.sql
-- --------------------------------------------------------             
-- SQL Commands to set up the pmadb as described in the documentation.  
--                                                                      
-- This file is meant for use with MySQL 5 and above!                   
--                                                                      
-- This script expects the user pma to already be existing. If we would put a
-- line here to create him too many users might just use this script and end 
-- up with having the same password for the controluser.                     
--                                                                           
-- This user "pma" must be defined in config.inc.php (controluser/controlpass)
--                                                                            
-- Please don't forget to set up the tablenames in config.inc.php             
--                                                                            
 
-- --------------------------------------------------------
 
--
-- Database : `phpmyadmin`
--                        
CREATE DATABASE IF NOT EXISTS `phpmyadmin`
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE phpmyadmin;                               
 
-- --------------------------------------------------------
 
--
-- Privileges
--           
-- (activate this statement if necessary)
-- GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON `phpmyadmin`.* TO
--    'pma'@localhost;                                             
 
-- Grant privileges to phpMyAdmin controluser.
GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON `phpmyadmin`.* TO 'controluser'@'10.0.0.97';
GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON `phpmyadmin`.* TO 'controluser'@'vml000097.dmz.nausch.org';
 
-- Reload privileges.
FLUSH PRIVILEGES;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__bookmark`
--                                          
 
CREATE TABLE IF NOT EXISTS `pma__bookmark` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,     
  `dbase` VARCHAR(255) NOT NULL DEFAULT '', 
  `user` VARCHAR(255) NOT NULL DEFAULT '',  
  `label` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `query` text NOT NULL,                                           
  PRIMARY KEY  (`id`)                                              
)                                                                  
  COMMENT='Bookmarks'                                              
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;                     
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__column_info`
--                                             
 
CREATE TABLE IF NOT EXISTS `pma__column_info` (
  `id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `db_name` VARCHAR(64) NOT NULL DEFAULT '',   
  `table_name` VARCHAR(64) NOT NULL DEFAULT '',
  `column_name` VARCHAR(64) NOT NULL DEFAULT '',
  `comment` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `mimetype` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `transformation` VARCHAR(255) NOT NULL DEFAULT '',                  
  `transformation_options` VARCHAR(255) NOT NULL DEFAULT '',          
  `input_transformation` VARCHAR(255) NOT NULL DEFAULT '',            
  `input_transformation_options` VARCHAR(255) NOT NULL DEFAULT '',    
  PRIMARY KEY  (`id`),                                                
  UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)         
)                                                                     
  COMMENT='Column information for phpMyAdmin'                         
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;                        
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__history`
--                                         
 
CREATE TABLE IF NOT EXISTS `pma__history` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(64) NOT NULL DEFAULT '',      
  `db` VARCHAR(64) NOT NULL DEFAULT '',            
  `table` VARCHAR(64) NOT NULL DEFAULT '',         
  `timevalue` TIMESTAMP NOT NULL,                  
  `sqlquery` text NOT NULL,                        
  PRIMARY KEY  (`id`),                             
  KEY `username` (`username`,`db`,`table`,`timevalue`)
)                                                     
  COMMENT='SQL history for phpMyAdmin'                
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;        
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__pdf_pages`
--                                           
 
CREATE TABLE IF NOT EXISTS `pma__pdf_pages` (
  `db_name` VARCHAR(64) NOT NULL DEFAULT '', 
  `page_nr` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `page_descr` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY  (`page_nr`),                                            
  KEY `db_name` (`db_name`)                                            
)                                                                      
  COMMENT='PDF relation pages for phpMyAdmin'                          
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;                         
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__recent`
--                                        
 
CREATE TABLE IF NOT EXISTS `pma__recent` (
  `username` VARCHAR(64) NOT NULL,        
  `tables` text NOT NULL,                 
  PRIMARY KEY (`username`)                
)                                         
  COMMENT='Recently accessed tables'      
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__favorite`
--                                          
 
CREATE TABLE IF NOT EXISTS `pma__favorite` (
  `username` VARCHAR(64) NOT NULL,          
  `tables` text NOT NULL,                   
  PRIMARY KEY (`username`)                  
)                                           
  COMMENT='Favorite tables'                 
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__table_uiprefs`
--                                               
 
CREATE TABLE IF NOT EXISTS `pma__table_uiprefs` (
  `username` VARCHAR(64) NOT NULL,               
  `db_name` VARCHAR(64) NOT NULL,                
  `table_name` VARCHAR(64) NOT NULL,             
  `prefs` text NOT NULL,                         
  `last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`username`,`db_name`,`table_name`)                                        
)                                                                                        
  COMMENT='Tables'' UI preferences'                                                      
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;                                           
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__relation`
--                                          
 
CREATE TABLE IF NOT EXISTS `pma__relation` (
  `master_db` VARCHAR(64) NOT NULL DEFAULT '',
  `master_table` VARCHAR(64) NOT NULL DEFAULT '',
  `master_field` VARCHAR(64) NOT NULL DEFAULT '',
  `foreign_db` VARCHAR(64) NOT NULL DEFAULT '',  
  `foreign_table` VARCHAR(64) NOT NULL DEFAULT '',
  `foreign_field` VARCHAR(64) NOT NULL DEFAULT '',
  PRIMARY KEY  (`master_db`,`master_table`,`master_field`),
  KEY `foreign_field` (`foreign_db`,`foreign_table`)       
)                                                          
  COMMENT='Relation table'                                 
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;             
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__table_coords`
--                                              
 
CREATE TABLE IF NOT EXISTS `pma__table_coords` (
  `db_name` VARCHAR(64) NOT NULL DEFAULT '',    
  `table_name` VARCHAR(64) NOT NULL DEFAULT '', 
  `pdf_page_number` INT(11) NOT NULL DEFAULT '0',
  `x` FLOAT UNSIGNED NOT NULL DEFAULT '0',       
  `y` FLOAT UNSIGNED NOT NULL DEFAULT '0',       
  PRIMARY KEY  (`db_name`,`table_name`,`pdf_page_number`)
)                                                        
  COMMENT='Table coordinates for phpMyAdmin PDF output'  
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;           
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__table_info`
--                                            
 
CREATE TABLE IF NOT EXISTS `pma__table_info` (
  `db_name` VARCHAR(64) NOT NULL DEFAULT '',  
  `table_name` VARCHAR(64) NOT NULL DEFAULT '',
  `display_field` VARCHAR(64) NOT NULL DEFAULT '',
  PRIMARY KEY  (`db_name`,`table_name`)           
)                                                 
  COMMENT='Table information for phpMyAdmin'      
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;    
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__tracking`
--                                          
 
CREATE TABLE IF NOT EXISTS `pma__tracking` (
  `db_name` VARCHAR(64) NOT NULL,           
  `table_name` VARCHAR(64) NOT NULL,        
  `version` INT(10) UNSIGNED NOT NULL,      
  `date_created` datetime NOT NULL,         
  `date_updated` datetime NOT NULL,         
  `schema_snapshot` text NOT NULL,          
  `schema_sql` text,                        
  `data_sql` longtext,                      
  `tracking` SET('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') DEFAULT NULL,                                                            
  `tracking_active` INT(1) UNSIGNED NOT NULL DEFAULT '1',                                                                                                    
  PRIMARY KEY  (`db_name`,`table_name`,`version`)                                                                                                            
)                                                                                                                                                            
  COMMENT='Database changes tracking for phpMyAdmin'                                                                                                         
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;                                                                                                               
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__userconfig`
--                                            
 
CREATE TABLE IF NOT EXISTS `pma__userconfig` (
  `username` VARCHAR(64) NOT NULL,            
  `timevalue` TIMESTAMP NOT NULL,             
  `config_data` text NOT NULL,                
  PRIMARY KEY  (`username`)                   
)                                             
  COMMENT='User preferences storage for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;     
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__users`
--                                       
 
CREATE TABLE IF NOT EXISTS `pma__users` (
  `username` VARCHAR(64) NOT NULL,       
  `usergroup` VARCHAR(64) NOT NULL,      
  PRIMARY KEY (`username`,`usergroup`)   
)                                        
  COMMENT='Users and their assignments to user groups'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;        
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__usergroups`
--                                            
 
CREATE TABLE IF NOT EXISTS `pma__usergroups` (
  `usergroup` VARCHAR(64) NOT NULL,           
  `tab` VARCHAR(64) NOT NULL,                 
  `allowed` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`usergroup`,`tab`,`allowed`)    
)                                              
  COMMENT='User groups with configured menu items'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;    
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__navigationhiding`
--                                                  
 
CREATE TABLE IF NOT EXISTS `pma__navigationhiding` (
  `username` VARCHAR(64) NOT NULL,                  
  `item_name` VARCHAR(64) NOT NULL,                 
  `item_type` VARCHAR(64) NOT NULL,                 
  `db_name` VARCHAR(64) NOT NULL,                   
  `table_name` VARCHAR(64) NOT NULL,                
  PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`)
)                                                                        
  COMMENT='Hidden items of navigation tree'                              
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;                           
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__savedsearches`
--                                               
 
CREATE TABLE IF NOT EXISTS `pma__savedsearches` (
  `id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT,  
  `username` VARCHAR(64) NOT NULL DEFAULT '',    
  `db_name` VARCHAR(64) NOT NULL DEFAULT '',     
  `search_name` VARCHAR(64) NOT NULL DEFAULT '', 
  `search_data` text NOT NULL,                   
  PRIMARY KEY  (`id`),                           
  UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`)
)                                                                                  
  COMMENT='Saved searches'                                                         
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;                                     
 
-- --------------------------------------------------------
 
--
-- Table structure for table `pma__central_columns`
--                                                 
 
CREATE TABLE IF NOT EXISTS `pma__central_columns` (
  `db_name` VARCHAR(64) NOT NULL,                  
  `col_name` VARCHAR(64) NOT NULL,                 
  `col_type` VARCHAR(64) NOT NULL,                 
  `col_length` text,                               
  `col_collation` VARCHAR(64) NOT NULL,            
  `col_isNull` BOOLEAN NOT NULL,                   
  `col_extra` VARCHAR(255) DEFAULT '',             
  `col_default` text,                              
  PRIMARY KEY (`db_name`,`col_name`)               
)                                                  
  COMMENT='Central list of columns'                
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

Unser angepasstes Script laden wir dann auf unserem Datenbankhost mit nachfolgendem Befehl.

 # mysql -h 127.0.0.1 -u root -p < /root/create_pmadb_tables.sql
 Enter password:

Zugriff testen

Zum Schluß überprüfen wir, ob der zuvor angelegt User/Zugang auch vom Webserver aus funktioniert.

 # mysql -h mysql.dmz.nausch.org -D phpmyadmin -u controluser -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 14121972
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
 MariaDB [(none)]> show tables;
+-----------------------+
| Tables_in_phpmyadmin  |
+-----------------------+
| pma__bookmark         |
| pma__central_columns  |
| pma__column_info      |
| pma__favorite         |
| pma__history          |
| pma__navigationhiding |
| pma__pdf_pages        |
| pma__recent           |
| pma__relation         |
| pma__savedsearches    |
| pma__table_coords     |
| pma__table_info       |
| pma__table_uiprefs    |
| pma__tracking         |
| pma__userconfig       |
| pma__usergroups       |
| pma__users            |
+-----------------------+
17 rows in set (0.00 sec)

MariaDB [(none)]>

Da der Test positiv ausgefallen ist, können wie uns wieder von unserem Datenbankserver abmelden.

 MariaDB [(none)]> quit
 Bye

Möchte man die PHP-Anwendung per Hand editieren benutzt man seinen Editor der Wahl. Hilfreiche Informationen zu den möglichen Konfigurationsoptionen findet man dazu in der Onlinedokumentation im Verzeichnis doc/html/, also erreichbar über http://phpmyadmin.nausch.org/doc/html/index.html

 $ firefox http://phpmyadmin.nausch.org/doc/html/index.html

Zum Bearbeiten der Konfigurationsdatei nutzen wir 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'] = '19670814514121972'; /* 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']     = 'cookie';    // 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
                                                    //     DEFAULT: 'pma_table_info'
$cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position
                                                    //   - leave blank for no PDF schema sup
                                                    //     DEFAULT: 'pma_table_coords'
$cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpd
                                                    //   - leave blank if you don't want to
                                                    //     DEFAULT: 'pma_pdf_pages'
$cfg['Servers'][$i]['column_info']   = '';          // table to store column information
                                                    //   - leave blank for no column comment
                                                    //     DEFAULT: 'pma_column_info'
$cfg['Servers'][$i]['history']       = '';          // table to store SQL history
                                                    //   - leave blank for no SQL query hist
                                                    //     DEFAULT: 'pma_history'
$cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pm
                                                    // are up to date. This prevents compati
                                                    // checks and thereby increases performa
$cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login
$cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blan
                                     = '';
$cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blan
                                     = array();
$cfg['Servers'][$i]['AllowNoPassword']              // Allow logins without a password. Do n
                                     = FALSE;       // default unless you're running a passw
$cfg['Servers'][$i]['designer_coords']              // Leave blank (default) for no Designer
                                     = '';          // set to suggested 'pma_designer_coords
$cfg['Servers'][$i]['bs_garbage_threshold']         // Blobstreaming: Recommented default va
                                     = 50;          //   DEFAULT: '50'
$cfg['Servers'][$i]['bs_repository_threshold']      // Blobstreaming: Recommented default va
                                     = '32M';       //   DEFAULT: '32M'
$cfg['Servers'][$i]['bs_temp_blob_timeout']         // Blobstreaming: Recommented default va
                                     = 600;         //   DEFAULT: '600'
$cfg['Servers'][$i]['bs_temp_log_threshold']        // Blobstreaming: Recommented default va
                                     = '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;
?>

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/

 $ firefox http://phpmyadmin.nausch.org/setup/

Bild: Bildschirmhardcopy phpMyAdmin Setup

Als erstes definieren wir unseren Datenbank-Server. Hierzu klicken wir auf die Schaltfläche [ Neuer Server ].

Bild: Bildschirmhardcopy phpMyAdmin Setup

Haben wir die entsprechenden Daten eingegeben, klicken wir auf die grün markierte Schaltfläche [ Übernehmen ].

Bild: Bildschirmhardcopy phpMyAdmin Setup

Beim Reiter Serverkonfiguration können wir festlegen, wie wir auf den Server zugreifen und welche Datenbank(tabellen) angezeigt werden sollen. Den Haken beim Punkt Erlaube root login entfernen wir!

Bild: Bildschirmhardcopy phpMyAdmin Setup

Die Einstellungen zum Konfigurationsspeicher PMADB legen wir auf dem Reiter Konfigurationsspeicher fest. Dort tragen wir folgende (entsprechende individuelle) Werte ein.

Datenbankname                                                                 phpmyadmin
pmadb Host                                                                    [             ]
Kontroll-Port                                                                 [             ]
pmadb Benutzer                                                                controluser
pmadb Benutzer Passwort                                                       controlpassword
Lesezeichen Tabelle                                                           pma__bookmark
Relation Tabelle                                                              pma__relation
Tabelle für Benutzereinstellungen                                             pma__userconfig
Benutzer-Tabelle                                                              pma__users
Benutzergruppen-Tabelle                                                       pma__usergroups
Tabelle für ausgeblendete Navigations-Elemente                                pma__navigationhiding
Tabelle für Anzeigespalten                                                    pma__table_info
Spalten Informationen Tabelle                                                 pma__column_info
SQL Abfragehistorien Tabelle                                                  pma__history
Kürzlich verwendete Tabellen                                                  pma__recent
Tabelle für Oberflächeneinstellungen                                          pma__table_uiprefs
Tabelle mit Verfolgung der SQL-Abfragen                                       pma__tracking
Designer- und PDF Schema: Tabellenkoordinaten                                 pma__table_coords
PDF-Schema: Seiten-Tabelle                                                    pma__pdf_pages
Beispielabfragentabelle                                                       pma__savedsearches
Central columns tabele                                                        pma__central_columns
Maximale Anzahl der zu speichernden Tabelleneinstellungen                     100

Bild: Bildschirmhardcopy phpMyAdmin Setup

Auf dem Reiter Grundeinstellungen setzen wir den Haken beim Punkt Benutze SSL.

Bild: Bildschirmhardcopy phpMyAdmin Setup

Wie haben den Konfigurationspunkte Übersicht erfolgreich fertiggestellt. Nun Wählen wir den nächsten Konfigurationskapitel Funktionen am linken Bildschirmrand an. Auf dem Reiter Import/Export legen wir die beiden Verzeichnisse zum Upload Verzeichnis und Speicher Verzeichnis fest.

Bild: Bildschirmhardcopy phpMyAdmin Setup

Upload Verzeichnis                                                            /var/lib/phpMyAdmin/upload
Speicher Verzeichnis                                                          /var/lib/phpMyAdmin/save

Auf den Reiter Sicherheit setzen wir den Haken beim Punkt SSL-Verbindung erzwingen.

Bild: Bildschirmhardcopy phpMyAdmin Setup

Beim Konfigurationskapitel SQL-Abfragen setzen wir den beim Punkt Abfragelog speichern.

Bild: Bildschirmhardcopy phpMyAdmin Setup

Auf den Reitern des Konfigurationskapitel Navigationspanel übernehmen wir die Defaultwerte.

Reiter Navigationspanel:

Bild: Bildschirmhardcopy phpMyAdmin Setup

Reiter Server:

Bild: Bildschirmhardcopy phpMyAdmin Setup

Reiter Datenbanken:

Bild: Bildschirmhardcopy phpMyAdmin Setup

Reiter Tabellen:

Bild: Bildschirmhardcopy phpMyAdmin Setup

Wie auch schon beim Kapitel Navigationspanel übernehmen wir beim Kapitel Hauptpanel die Defaultwerte.

Bild: Bildschirmhardcopy phpMyAdmin Setup

Zum Speichern der Konfigurationswerte klicken wir im Konfigurationskapitel Übersicht auf die schaltfläche [ Speichern ] am unteren linke ende des Fensters.

Bild: Bildschirmhardcopy phpMyAdmin Setup

Wollen wir die Konfigurationsdatei gesondert sichern, klicken wir auf die Schaltfläche [ Download ]. Bei Bedarf können wir uns die erstellte und gespeicherte Konfigurationsdaten auch anzeigen lassen; hierzu klicken wir auf die Schaltfläche [ Anzeigen ].

Bild: Bildschirmhardcopy phpMyAdmin Setup

Die mit der Web-GUI erstellte Konfigurationsdatei finden wir im Verzeichnis /var/lib/phpMyAdmin/config/.

 # less /var/lib/phpMyAdmin/config/config.inc.php
/var/lib/phpMyAdmin/config/config.inc.php
<?php
/*
 * Generated configuration file
 * Generated by: phpMyAdmin 4.3.6 setup script
 * Date: Thu, 29 Jan 2015 15:50:25 +0100
 */
 
/* Servers configuration */
$i = 0;
 
/* Server: db.dmz.nausch.org [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'db.dmz.nausch.org';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowRoot'] = false;
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['controluser'] = 'controluser';
$cfg['Servers'][$i]['controlpass'] = 'controlpassword';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$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]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$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]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['tracking_version_auto_create'] = true;
$cfg['Servers'][$i]['ssl'] = true;
 
/* End of servers configuration */
 
$cfg['blowfish_secret'] = '54ca09fae9b875.19509b16';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
$cfg['ForceSSL'] = true;
$cfg['DefaultLang'] = 'de';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '/var/lib/phpMyAdmin/upload';
$cfg['SaveDir'] = '/var/lib/phpMyAdmin/save';
$cfg['RecodingEngine'] = 'auto';
?>

Die erstelle Konfigurationsdatei verschieben wir nun in das Konfigurationsverzeichnis /etc/phpMyAdmin von phpMyAdmin.

 # mv /var/lib/phpMyAdmin/config/config.inc.php /etc/phpMyAdmin -f

Anschließend löschen wir den Inhalt des Verzeichnis der Konfigurations-WEB-GUI.

 # rm /usr/share/phpMyAdmin/setup/* -rf

Zu guter letzt entfernen wir noch das setup-Verzeichnis.

 # rmdir /usr/share/phpMyAdmin/setup/

Für die Import / Export Funktion benötigen wir noch die RPM-Pakete recode und php-recode; diese installieren wir nun unter zuhilfenahme von yum.

 # yum install recode php-recode -y

Haben wir eine mySQL-Datenbank, wie sie z.B. unter CentOS 6 noch verwendet wurde, kann es beim Aufruf der Webseite http://phpmyadmin.nausch.org zu folgender Fehlermeldung kommen.

Bild: Bildschirmhardcopy phpMyAdmin Setup

Hinweis: Fehlermeldung phpMyAdmin - Fehler Sie sollten auf MySQL 5.5.0 oder neuer aktualisieren.

Damit wir unsere alte Datenbank mit phpMyAdmin administrieren können, ändern wir wie nachfolgend aufgezeigt, die Datei common.inc.php.

 # vim /usr/share/phpMyAdmin/libraries/common.inc.php
 998         // Django : 2015-01-29
 999         // default: if (PMA_MYSQL_INT_VERSION < 50500) {
1000         if (PMA_MYSQL_INT_VERSION < 50100) {
1001             PMA_fatalError(
1002                 __('You should upgrade to %s %s or later.'),
1003                 array('MySQL', '5.5.0')
1004             );
1005         }

Nun können wir die Applikation phpMyAdmin mit dem Browser unserer Wahl starten.

 $ firefox http://phpmyadmin.nausch.org/setup/

Bild: Bildschirmhardcopy phpMyAdmin Login Seite

Nach erfolgter Anmeldung befinden wir uns im Hauptadministrationsfenster von phpMyAdmin.

Bild: Bildschirmhardcopy phpMyAdmin Seite

Links


1)
PHPMyAdminDataBase
Diese Website verwendet Cookies. Durch die Nutzung der Website stimmen Sie dem Speichern von Cookies auf Ihrem Computer zu. Außerdem bestätigen Sie, dass Sie unsere Datenschutzbestimmungen gelesen und verstanden haben. Wenn Sie nicht einverstanden sind, verlassen Sie die Website.Weitere Information
  • centos/web_c7/phpmyadmin.txt
  • Zuletzt geändert: 22.07.2019 14:43.
  • von django