FM / _sources

/usr/share/doc/phpmyadmin/html/_sources/

/usr/share/doc/phpmyadmin/html/_sources

Name	Size	Mode	Actions
bookmarks.rst.txt	2463	0644	edit dl rm
charts.rst.txt	4743	0644	edit dl rm
config.rst.txt	120510	0644	edit dl rm
copyright.rst.txt	1621	0644	edit dl rm
credits.rst.txt	28021	0644	edit dl rm
developers.rst.txt	380	0644	edit dl rm
faq.rst.txt	94809	0644	edit dl rm
glossary.rst.txt	15155	0644	edit dl rm
import_export.rst.txt	10213	0644	edit dl rm
index.rst.txt	573	0644	edit dl rm
intro.rst.txt	3155	0644	edit dl rm
other.rst.txt	916	0644	edit dl rm
privileges.rst.txt	3264	0644	edit dl rm
relations.rst.txt	3342	0644	edit dl rm
require.rst.txt	1683	0644	edit dl rm
security.rst.txt	4607	0644	edit dl rm
settings.rst.txt	1015	0644	edit dl rm
setup.rst.txt	43403	0644	edit dl rm
themes.rst.txt	2938	0644	edit dl rm
transformations.rst.txt	7949	0644	edit dl rm
two_factor.rst.txt	2873	0644	edit dl rm
user.rst.txt	195	0644	edit dl rm
vendors.rst.txt	1969	0644	edit dl rm

Edit: /usr/share/doc/phpmyadmin/html/_sources/intro.rst.txt (3155B)

.. _intro:

Introduction
============

phpMyAdmin is a free software tool written in PHP that is intended to handle the
administration of a MySQL or MariaDB database server. You can use phpMyAdmin to
perform most administration tasks, including creating a database, running queries,
and adding user accounts.

Supported features
------------------

Currently phpMyAdmin can:

* create, browse, edit, 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
* maintenance server, databases and tables, with proposals on server
  configuration
* execute, edit and bookmark any :term:`SQL`-statement, even batch-queries
* load text files into tables
* create [#f1]_ and read dumps of tables
* export [#f1]_ data to various formats: :term:`CSV`, :term:`XML`, :term:`PDF`,
  :term:`ISO`/:term:`IEC` 26300 - :term:`OpenDocument` Text and Spreadsheet, Microsoft
  Word 2000, and LATEX formats
* import data and :term:`MySQL` structures from :term:`OpenDocument` spreadsheets, as
  well as :term:`XML`, :term:`CSV`, and :term:`SQL` files
* administer multiple servers
* add, edit, and remove MySQL user accounts and privileges
* check referential integrity in MyISAM tables
* using Query-by-example (QBE), create complex queries automatically
  connecting required tables
* create :term:`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 see :ref:`faq1_17`
* create, edit, call, export and drop stored procedures and functions
* create, edit, export and drop events and triggers
* communicate in `80 different languages
  <https://www.phpmyadmin.net/translations/>`_

Shortcut keys
-------------

Currently phpMyAdmin supports following shortcuts:

* k - Toggle console
* h - Go to home page
* s - Open settings
* d + s - Go to database structure (Provided you are in database related page)
* d + f - Search database (Provided you are in database related page)
* t + s - Go to table structure (Provided you are in table related page)
* t + f - Search table (Provided you are in table related page)
* backspace - Takes you to older page.

A word about users
------------------

Many people have difficulty understanding the concept of user
management with regards to phpMyAdmin. When a user logs in to
phpMyAdmin, that username and password are passed directly to MySQL.
phpMyAdmin does no account management on its own (other than allowing
one to manipulate the MySQL user account information); all users must
be valid MySQL users.

.. rubric:: Footnotes

.. [#f1]

phpMyAdmin can compress (:term:`ZIP`, :term:`GZip` or :term:`RFC 1952`
    formats) dumps and :term:`CSV` exports if you use PHP with
    :term:`Zlib` support (``--with-zlib``).
    Proper support may also need changes in :file:`php.ini`.

.. _intro: Introduction ============ phpMyAdmin is a free software tool written in PHP that is intended to handle the administration of a MySQL or MariaDB database server. You can use phpMyAdmin to perform most administration tasks, including creating a database, running queries, and adding user accounts. Supported features ------------------ Currently phpMyAdmin can: * create, browse, edit, 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 * maintenance server, databases and tables, with proposals on server configuration * execute, edit and bookmark any :term:`SQL`-statement, even batch-queries * load text files into tables * create [#f1]_ and read dumps of tables * export [#f1]_ data to various formats: :term:`CSV`, :term:`XML`, :term:`PDF`, :term:`ISO`/:term:`IEC` 26300 - :term:`OpenDocument` Text and Spreadsheet, Microsoft Word 2000, and LATEX formats * import data and :term:`MySQL` structures from :term:`OpenDocument` spreadsheets, as well as :term:`XML`, :term:`CSV`, and :term:`SQL` files * administer multiple servers * add, edit, and remove MySQL user accounts and privileges * check referential integrity in MyISAM tables * using Query-by-example (QBE), create complex queries automatically connecting required tables * create :term:`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 see :ref:`faq1_17` * create, edit, call, export and drop stored procedures and functions * create, edit, export and drop events and triggers * communicate in `80 different languages `_ Shortcut keys ------------- Currently phpMyAdmin supports following shortcuts: * k - Toggle console * h - Go to home page * s - Open settings * d + s - Go to database structure (Provided you are in database related page) * d + f - Search database (Provided you are in database related page) * t + s - Go to table structure (Provided you are in table related page) * t + f - Search table (Provided you are in table related page) * backspace - Takes you to older page. A word about users ------------------ Many people have difficulty understanding the concept of user management with regards to phpMyAdmin. When a user logs in to phpMyAdmin, that username and password are passed directly to MySQL. phpMyAdmin does no account management on its own (other than allowing one to manipulate the MySQL user account information); all users must be valid MySQL users. .. rubric:: Footnotes .. [#f1] phpMyAdmin can compress (:term:`ZIP`, :term:`GZip` or :term:`RFC 1952` formats) dumps and :term:`CSV` exports if you use PHP with :term:`Zlib` support (``--with-zlib``). Proper support may also need changes in :file:`php.ini`.