phpMyAdmin 3.4.0-beta3-dev Documentation

Requirements

• PHP
  • You need PHP 5.2.0 or newer, with session support (see FAQ 1.31) and the Standard PHP Library (SPL) extension.
  • To support uploading of ZIP files, you need the PHP zip extension.
  • For proper support of multibyte strings (eg. UTF-8, which is currently the default), you should install the mbstring and ctype extensions.
  • You need GD2 support in PHP to display inline thumbnails of JPEGs ("image/jpeg: inline") with their original aspect ratio
  • When using the "cookie" authentication method, the mcrypt extension is strongly suggested for most users and is required for 64–bit machines. Not using mcrypt will cause phpMyAdmin to load pages significantly slower.
  • To support upload progress bars, see FAQ 2.9.
  • To support BLOB streaming, see PHP and MySQL requirements in FAQ 6.25.
• MySQL 5.0 or newer (details);
• Web browser with cookies enabled.

Introduction

phpMyAdmin can manage a whole MySQL server (needs a super-user) as well as a single database. To accomplish the latter you'll need a properly set up MySQL user who can read/write only the desired database. It's up to you to look up the appropriate part in the MySQL manual.

Currently phpMyAdmin can:

• browse and drop databases, tables, views, columns and indexes
• create, copy, drop, rename and alter databases, tables, columns and indexes
• maintenance 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, Word, Excel and L^AT_EX formats
• import data and MySQL structures from Microsoft Excel and 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 (see FAQ 3.6)
• support mysqli, the improved MySQL extension (see FAQ 1.17)
• communicate in 62 different languages
• synchronize two databases residing on the same as well as remote servers (see FAQ 9.1)

See Detail.............

Posted in: All