This documentation is not using the current rendering mechanism and will be deleted by December 31st, 2020. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.
|Author:||Jigal van Hemert|
|Changed by:||Jigal van Hemert|
|Description:||The keywords help with categorizing and tagging of the manuals. You can combine two or more keywords and add additional keywords yourself. Please use at least one keyword from both lists. If your manual is NOT in english, see next tab “language” —- forEditors (use this for editors / german “Redakteure”) forAdmins (use this for Administrators) forDevelopers (use this for Developers) forBeginners (manuals covering TYPO3 basics) forIntermediates (manuals going into more depth) forAdvanced (covering the most advanced TYPO3 topics) see more: http://wiki.typo3.org/doc_template#tags —-|
|Keywords:||forEditors, forAdmins, forBeginners|
|Author:||Jigal van Hemert|
Extension Key: t3adminer
Keywords: forEditors, forAdmins, forBeginners
Copyright 2011-2014, Jigal van Hemert, <email@example.com>
This document is published under the Open Content License
available from http://www.opencontent.org/opl.shtml
The content of this document is related to TYPO3
- a GNU/GPL CMS/Framework available from www.typo3.org
Table of Contents¶
`EXT: Adminer 1 <#__RefHeading__5708_1738894311>`_
`Introduction 3 <#__RefHeading__5710_1738894311>`_
`User manual 5 <#__RefHeading__5718_1738894311>`_
`Administration 6 <#__RefHeading__10361_1167042523>`_
`Configuration 7 <#__RefHeading__10365_1167042523>`_
`Known problems 8 <#__RefHeading__10367_1167042523>`_
`To-Do list 9 <#__RefHeading__10369_1167042523>`_
`Translations 10 <#__RefHeading__10371_1167042523>`_
`Changelog 11 <#__RefHeading__10373_1167042523>`_
What does it do?¶
Adminer ( http://www.adminer.org/ ) is a lightweight alternative for the well known tool phpMyAdmin. Adminer provides most of the functionality you need when dealing with a database.
On the Adminer website is a full comparison with phpMyAdmin, but some of the highlights are:
- support for other database systems
- flexible interface for creating, altering tables
- full support for views, triggers, routines, events, foreign keys
- inline editing of field values (multiple records in one operation)
- faster and a lot smaller than phpMyAdmin
It starts with a list of all available tables and views.
Inline editing of content.
Easy interface for modifying table structure.
Free support for the extension part is provided through various TYPO3 lists (e.g. typo3.dev, typo3.english, typo3.ug.dutch).
For issues and support of Adminer itself, see the Adminer website.
Adminer is only available for administrators.
Download the extension and install it in the Extension Manager.
In the Extension manager there are two settings to restrict access to the Adminer module:
- Access from IPs [IPaccess] : a comma separated list of IP addresses can be specified here which have access to this module
- Apply devIpMask [applyDevIpMask] : if set only the IP adresses from the devIpMask setting in the Install Tool have access to the module. This setting has priority over the previous one.
A third setting is for the export function:
Export directory [exportDirectory] : path to the directory where the export files are stored if the option “Server” is selected. This can both be a path relative to the webroot or an absolute path on the server (starts with a “/”). If the setting is empty the directory for the fileadmin as set in the Install Tool will be used.
It has zero configuration (apart from the optional settings in the Extension Manager), so it should work out of the box. The extension automatically sends the TYPO3 database credentials to Adminer.
The extension detects the DBMS configured in TYPO3 (all DBAL supported systems are also supported by Adminer) and makes Adminer use this DBMS.
non so far
option to restrict usage to the TYPO3 database
Translations are included inside Adminer. The extension merely sets the language according to the TYPO3 backend language (as far as Adminer supports this language).
see the file “Changelog”