D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
opt
/
lampp
/
phpmyadmin
/
doc
/
html
/
Filename :
intro.html
back
Copy
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Introduction — phpMyAdmin 4.7.4 documentation</title> <link rel="stylesheet" href="_static/classic.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: './', VERSION: '4.7.4', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true }; </script> <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> <link rel="index" title="Index" href="genindex.html" /> <link rel="search" title="Search" href="search.html" /> <link rel="copyright" title="Copyright" href="copyright.html" /> <link rel="top" title="phpMyAdmin 4.7.4 documentation" href="index.html" /> <link rel="next" title="Requirements" href="require.html" /> <link rel="prev" title="Welcome to phpMyAdmin’s documentation!" href="index.html" /> </head> <body role="document"> <div class="related" role="navigation" aria-label="related navigation"> <h3>Navigation</h3> <ul> <li class="right" style="margin-right: 10px"> <a href="genindex.html" title="General Index" accesskey="I">index</a></li> <li class="right" > <a href="require.html" title="Requirements" accesskey="N">next</a> |</li> <li class="right" > <a href="index.html" title="Welcome to phpMyAdmin’s documentation!" accesskey="P">previous</a> |</li> <li class="nav-item nav-item-0"><a href="index.html">phpMyAdmin 4.7.4 documentation</a> »</li> </ul> </div> <div class="document"> <div class="documentwrapper"> <div class="bodywrapper"> <div class="body" role="main"> <div class="section" id="introduction"> <span id="intro"></span><h1>Introduction<a class="headerlink" href="#introduction" title="Permalink to this headline">¶</a></h1> <p>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.</p> <div class="section" id="supported-features"> <h2>Supported features<a class="headerlink" href="#supported-features" title="Permalink to this headline">¶</a></h2> <p>Currently phpMyAdmin can:</p> <ul class="simple"> <li>browse and drop databases, tables, views, columns and indexes</li> <li>display multiple results sets through stored procedures or queries</li> <li>create, copy, drop, rename and alter databases, tables, columns and indexes</li> <li>maintenance server, databases and tables, with proposals on server configuration</li> <li>execute, edit and bookmark any <a class="reference internal" href="glossary.html#term-sql"><span class="xref std std-term">SQL</span></a>-statement, even batch-queries</li> <li>load text files into tables</li> <li>create <a class="footnote-reference" href="#f1" id="id1">[1]</a> and read dumps of tables</li> <li>export <a class="footnote-reference" href="#f1" id="id2">[1]</a> data to various formats: <a class="reference internal" href="glossary.html#term-csv"><span class="xref std std-term">CSV</span></a>, <a class="reference internal" href="glossary.html#term-xml"><span class="xref std std-term">XML</span></a>, <a class="reference internal" href="glossary.html#term-pdf"><span class="xref std std-term">PDF</span></a>, <a class="reference internal" href="glossary.html#term-iso"><span class="xref std std-term">ISO</span></a>/<a class="reference internal" href="glossary.html#term-iec"><span class="xref std std-term">IEC</span></a> 26300 - <a class="reference internal" href="glossary.html#term-opendocument"><span class="xref std std-term">OpenDocument</span></a> Text and Spreadsheet, Microsoft Word 2000, and LATEX formats</li> <li>import data and <a class="reference internal" href="glossary.html#term-48"><span class="xref std std-term">MySQL</span></a> structures from <a class="reference internal" href="glossary.html#term-opendocument"><span class="xref std std-term">OpenDocument</span></a> spreadsheets, as well as <a class="reference internal" href="glossary.html#term-xml"><span class="xref std std-term">XML</span></a>, <a class="reference internal" href="glossary.html#term-csv"><span class="xref std std-term">CSV</span></a>, and <a class="reference internal" href="glossary.html#term-sql"><span class="xref std std-term">SQL</span></a> files</li> <li>administer multiple servers</li> <li>manage MySQL users and privileges</li> <li>check referential integrity in MyISAM tables</li> <li>using Query-by-example (QBE), create complex queries automatically connecting required tables</li> <li>create <a class="reference internal" href="glossary.html#term-pdf"><span class="xref std std-term">PDF</span></a> graphics of your database layout</li> <li>search globally in a database or a subset of it</li> <li>transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link</li> <li>track changes on databases, tables and views</li> <li>support InnoDB tables and foreign keys</li> <li>support mysqli, the improved MySQL extension see <a class="reference internal" href="faq.html#faq1-17"><span class="std std-ref">1.17 Which Database versions does phpMyAdmin support?</span></a></li> <li>create, edit, call, export and drop stored procedures and functions</li> <li>create, edit, export and drop events and triggers</li> <li>communicate in <a class="reference external" href="https://www.phpmyadmin.net/translations/">80 different languages</a></li> </ul> </div> <div class="section" id="shortcut-keys"> <h2>Shortcut keys<a class="headerlink" href="#shortcut-keys" title="Permalink to this headline">¶</a></h2> <p>Currently phpMyAdmin supports following shortcuts:</p> <ul class="simple"> <li>k - Toggle console</li> <li>h - Go to home page</li> <li>s - Open settings</li> <li>d + s - Go to database structure (Provided you are in database related page)</li> <li>d + f - Search database (Provided you are in database related page)</li> <li>t + s - Go to table structure (Provided you are in table related page)</li> <li>t + f - Search table (Provided you are in table related page)</li> <li>backspace - Takes you to older page.</li> </ul> </div> <div class="section" id="a-word-about-users"> <h2>A word about users<a class="headerlink" href="#a-word-about-users" title="Permalink to this headline">¶</a></h2> <p>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.</p> <p class="rubric">Footnotes</p> <table class="docutils footnote" frame="void" id="f1" rules="none"> <colgroup><col class="label" /><col /></colgroup> <tbody valign="top"> <tr><td class="label">[1]</td><td><em>(<a class="fn-backref" href="#id1">1</a>, <a class="fn-backref" href="#id2">2</a>)</em> phpMyAdmin can compress (<a class="reference internal" href="glossary.html#term-zip"><span class="xref std std-term">Zip</span></a>, <a class="reference internal" href="glossary.html#term-gzip"><span class="xref std std-term">GZip</span></a> or <a class="reference internal" href="glossary.html#term-rfc-1952"><span class="xref std std-term">RFC 1952</span></a> formats) dumps and <a class="reference internal" href="glossary.html#term-csv"><span class="xref std std-term">CSV</span></a> exports if you use PHP with <a class="reference internal" href="glossary.html#term-zlib"><span class="xref std std-term">Zlib</span></a> support (<code class="docutils literal"><span class="pre">--with-zlib</span></code>). Proper support may also need changes in <code class="file docutils literal"><span class="pre">php.ini</span></code>.</td></tr> </tbody> </table> </div> </div> </div> </div> </div> <div class="sphinxsidebar" role="navigation" aria-label="main navigation"> <div class="sphinxsidebarwrapper"> <h3><a href="index.html">Table Of Contents</a></h3> <ul> <li><a class="reference internal" href="#">Introduction</a><ul> <li><a class="reference internal" href="#supported-features">Supported features</a></li> <li><a class="reference internal" href="#shortcut-keys">Shortcut keys</a></li> <li><a class="reference internal" href="#a-word-about-users">A word about users</a></li> </ul> </li> </ul> <h4>Previous topic</h4> <p class="topless"><a href="index.html" title="previous chapter">Welcome to phpMyAdmin’s documentation!</a></p> <h4>Next topic</h4> <p class="topless"><a href="require.html" title="next chapter">Requirements</a></p> <div role="note" aria-label="source link"> <h3>This Page</h3> <ul class="this-page-menu"> <li><a href="_sources/intro.txt" rel="nofollow">Show Source</a></li> </ul> </div> <div id="searchbox" style="display: none" role="search"> <h3>Quick search</h3> <form class="search" action="search.html" method="get"> <div><input type="text" name="q" /></div> <div><input type="submit" value="Go" /></div> <input type="hidden" name="check_keywords" value="yes" /> <input type="hidden" name="area" value="default" /> </form> </div> <script type="text/javascript">$('#searchbox').show(0);</script> </div> </div> <div class="clearer"></div> </div> <div class="related" role="navigation" aria-label="related navigation"> <h3>Navigation</h3> <ul> <li class="right" style="margin-right: 10px"> <a href="genindex.html" title="General Index" >index</a></li> <li class="right" > <a href="require.html" title="Requirements" >next</a> |</li> <li class="right" > <a href="index.html" title="Welcome to phpMyAdmin’s documentation!" >previous</a> |</li> <li class="nav-item nav-item-0"><a href="index.html">phpMyAdmin 4.7.4 documentation</a> »</li> </ul> </div> <div class="footer" role="contentinfo"> © <a href="copyright.html">Copyright</a> 2012 - 2017, The phpMyAdmin devel team. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.4.9. </div> </body> </html>