BSD Ports

databases/phpmyadmin 4.9.11_1 DragonFly

Set of PHP-scripts to manage MySQL over the web

System
DragonFly
Repository
DPorts
Maintainer
[email protected] (as in FreeBSD)
License
GPLv2
Categories
databases, www
Package size
6099.4 KiB, 32922.9 KiB installed

Description

Currently phpMyAdmin can:

\* browse and drop databases, tables, views, columns and indexes
\* display multiple results sets through stored procedures or queries
\* create, copy, drop, rename and alter databases, tables, columns
  and indexes
\* maintain server, databases and tables, with proposals on server
  configuration
\* execute, edit and bookmark any SQL-statement, even batch-queries
\* load text files into tables
\* create and read dumps of tables
\* export data to various formats: CSV, XML, PDF, ISO/IEC 26300 -
  OpenDocument Text and Spreadsheet, Microsoft Word 2000, and
  LATEX formats
\* import data and MySQL structures from OpenDocument spreadsheets,
  as well as XML, CSV, and SQL files
\* administer multiple servers
\* manage MySQL users and privileges
\* check referential integrity in MyISAM tables
\* using Query-by-example (QBE), create complex queries
  automatically connecting required tables
\* create PDF graphics of your database layout
\* search globally in a database or a subset of it
\* transform stored data into any format using a set of predefined
  functions, like displaying BLOB-data as image or download-link
\* track changes on databases, tables and views
\* support InnoDB tables and foreign keys
\* support mysqli, the improved MySQL extension
\* create, edit, call, export and drop stored procedures and
  functions
\* create, edit, export and drop events and triggers
\* communicate in 62 different languages

In the other systems

SystemPortVersion
DragonFlydatabases/phpmyadmin4.9.11_1
FreeBSDdatabases/phpmyadmin4.9.11_1
NetBSDdatabases/phpmyadmin4.9.10nb1
MidnightBSDdatabases/phpmyadmin4.9.11_3
HardenedBSDdatabases/phpmyadmin4.9.11_1
GhostBSDdatabases/phpmyadmin4.9.11_1

Install

Binary package:

pkg install phpMyAdmin-php81

From DPorts:

cd /usr/dports/databases/phpmyadmin && make install clean

Dependencies

Run dependencies 12

No port depends on this one.

Configuration

No options to configure.

Service scripts
none
Flavors
phpMyAdmin-php82-4.9.11_1, phpMyAdmin-php83-4.9.11_1, phpMyAdmin-php84-4.9.11_1

Message after installing

phpMyAdmin-php81-4.9.11_1 has been installed into:

    /usr/local/www/phpMyAdmin

Please edit config.inc.php to suit your needs.

To make phpMyAdmin available through your web site, I suggest
that you add something like the following to httpd.conf:

Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"

<Directory "/usr/local/www/phpMyAdmin/">
	Options None
	AllowOverride Limit

	Require local
    	Require host .example.com
</Directory>

SECURITY NOTE: phpMyAdmin is an administrative tool that has had several
remote vulnerabilities discovered in the past, some allowing remote
attackers to execute arbitrary code with the web server's user credential.
All known problems have been fixed, but the FreeBSD Security Team strongly
advises that any instance be protected with an additional protection layer,
e.g. a different access control mechanism implemented by the web server
as shown in the example.  Do consider enabling phpMyAdmin only when it
is in use.