phpmyadmin/doc/html/intro.html

   1
   2
   3 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   4   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   5
   6
   7 <html xmlns="http://www.w3.org/1999/xhtml">
   8   <head>
   9     <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  10
  11     <title>Introduction &mdash; phpMyAdmin 4.0.4 documentation</title>
  12
  13     <link rel="stylesheet" href="_static/default.css" type="text/css" />
  14     <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
  15
  16     <script type="text/javascript">
  17       var DOCUMENTATION_OPTIONS = {
  18         URL_ROOT:    '',
  19         VERSION:     '4.0.4',
  20         COLLAPSE_INDEX: false,
  21         FILE_SUFFIX: '.html',
  22         HAS_SOURCE:  true
  23       };
  24     </script>
  25     <script type="text/javascript" src="_static/jquery.js"></script>
  26     <script type="text/javascript" src="_static/underscore.js"></script>
  27     <script type="text/javascript" src="_static/doctools.js"></script>
  28     <link rel="copyright" title="Copyright" href="copyright.html" />
  29     <link rel="top" title="phpMyAdmin 4.0.4 documentation" href="index.html" />
  30     <link rel="next" title="Requirements" href="require.html" />
  31     <link rel="prev" title="Welcome to phpMyAdmin’s documentation!" href="index.html" />
  32   </head>
  33   <body>
  34     <div class="related">
  35       <h3>Navigation</h3>
  36       <ul>
  37         <li class="right" style="margin-right: 10px">
  38           <a href="genindex.html" title="General Index"
  39              accesskey="I">index</a></li>
  40         <li class="right" >
  41           <a href="require.html" title="Requirements"
  42              accesskey="N">next</a> |</li>
  43         <li class="right" >
  44           <a href="index.html" title="Welcome to phpMyAdmin’s documentation!"
  45              accesskey="P">previous</a> |</li>
  46         <li><a href="index.html">phpMyAdmin 4.0.4 documentation</a> &raquo;</li>
  47       </ul>
  48     </div>
  49
  50     <div class="document">
  51       <div class="documentwrapper">
  52         <div class="bodywrapper">
  53           <div class="body">
  54
  55   <div class="section" id="introduction">
  56 <span id="intro"></span><h1>Introduction<a class="headerlink" href="#introduction" title="Permalink to this headline">¶</a></h1>
  57 <p>phpMyAdmin can manage a whole MySQL server (needs a super-user) as
  58 well as a single database. To accomplish the latter you&#8217;ll need a
  59 properly set up MySQL user who can read/write only the desired
  60 database. It&#8217;s up to you to look up the appropriate part in the MySQL
  61 manual.</p>
  62 <div class="section" id="supported-features">
  63 <h2>Supported features<a class="headerlink" href="#supported-features" title="Permalink to this headline">¶</a></h2>
  64 <p>Currently phpMyAdmin can:</p>
  65 <ul class="simple">
  66 <li>browse and drop databases, tables, views, columns and indexes</li>
  67 <li>display multiple results sets through stored procedures or queries</li>
  68 <li>create, copy, drop, rename and alter databases, tables, columns and
  69 indexes</li>
  70 <li>maintenance server, databases and tables, with proposals on server
  71 configuration</li>
  72 <li>execute, edit and bookmark any <a class="reference internal" href="glossary.html#term-sql"><em class="xref std std-term">SQL</em></a>-statement, even batch-queries</li>
  73 <li>load text files into tables</li>
  74 <li>create <a class="footnote-reference" href="#f1" id="id1">[1]</a> and read dumps of tables</li>
  75 <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"><em class="xref std std-term">CSV</em></a>, <a class="reference internal" href="glossary.html#term-xml"><em class="xref std std-term">XML</em></a>, <a class="reference internal" href="glossary.html#term-pdf"><em class="xref std std-term">PDF</em></a>,
  76 <a class="reference internal" href="glossary.html#term-iso"><em class="xref std std-term">ISO</em></a>/<a class="reference internal" href="glossary.html#term-iec"><em class="xref std std-term">IEC</em></a> 26300 - <a class="reference internal" href="glossary.html#term-opendocument"><em class="xref std std-term">OpenDocument</em></a> Text and Spreadsheet, Microsoft
  77 Word 2000, and LATEX formats</li>
  78 <li>import data and <a class="reference internal" href="glossary.html#term-47"><em class="xref std std-term">MySQL</em></a> structures from <a class="reference internal" href="glossary.html#term-opendocument"><em class="xref std std-term">OpenDocument</em></a> spreadsheets, as
  79 well as <a class="reference internal" href="glossary.html#term-xml"><em class="xref std std-term">XML</em></a>, <a class="reference internal" href="glossary.html#term-csv"><em class="xref std std-term">CSV</em></a>, and <a class="reference internal" href="glossary.html#term-sql"><em class="xref std std-term">SQL</em></a> files</li>
  80 <li>administer multiple servers</li>
  81 <li>manage MySQL users and privileges</li>
  82 <li>check referential integrity in MyISAM tables</li>
  83 <li>using Query-by-example (QBE), create complex queries automatically
  84 connecting required tables</li>
  85 <li>create <a class="reference internal" href="glossary.html#term-pdf"><em class="xref std std-term">PDF</em></a> graphics of your
  86 database layout</li>
  87 <li>search globally in a database or a subset of it</li>
  88 <li>transform stored data into any format using a set of predefined
  89 functions, like displaying BLOB-data as image or download-link</li>
  90 <li>track changes on databases, tables and views</li>
  91 <li>support InnoDB tables and foreign keys see <a class="reference internal" href="faq.html#faq3-6"><em>3.6 What is currently not supported in phpMyAdmin about InnoDB?</em></a></li>
  92 <li>support mysqli, the improved MySQL extension see <a class="reference internal" href="faq.html#faq1-17"><em>1.17 Which MySQL versions does phpMyAdmin support?</em></a></li>
  93 <li>create, edit, call, export and drop stored procedures and functions</li>
  94 <li>create, edit, export and drop events and triggers</li>
  95 <li>communicate in <a class="reference external" href="http://www.phpmyadmin.net/home_page/translations.php">62 different languages</a></li>
  96 </ul>
  97 </div>
  98 <div class="section" id="a-word-about-users">
  99 <h2>A word about users<a class="headerlink" href="#a-word-about-users" title="Permalink to this headline">¶</a></h2>
 100 <p>Many people have difficulty understanding the concept of user
 101 management with regards to phpMyAdmin. When a user logs in to
 102 phpMyAdmin, that username and password are passed directly to MySQL.
 103 phpMyAdmin does no account management on its own (other than allowing
 104 one to manipulate the MySQL user account information); all users must
 105 be valid MySQL users.</p>
 106 <p class="rubric">Footnotes</p>
 107 <table class="docutils footnote" frame="void" id="f1" rules="none">
 108 <colgroup><col class="label" /><col /></colgroup>
 109 <tbody valign="top">
 110 <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"><em class="xref std std-term">Zip</em></a>, <a class="reference internal" href="glossary.html#term-gzip"><em class="xref std std-term">GZip</em></a> <a class="reference internal" href="glossary.html#term-rfc-1952"><em class="xref std std-term">RFC 1952</em></a> or
 111 <a class="reference internal" href="glossary.html#term-bzip2"><em class="xref std std-term">Bzip2</em></a> formats) dumps and <a class="reference internal" href="glossary.html#term-csv"><em class="xref std std-term">CSV</em></a> exports if you use PHP with
 112 <a class="reference internal" href="glossary.html#term-zlib"><em class="xref std std-term">Zlib</em></a> support (<tt class="docutils literal"><span class="pre">--with-zlib</span></tt>) and/or <a class="reference internal" href="glossary.html#term-bzip2"><em class="xref std std-term">Bzip2</em></a> support
 113 (<tt class="docutils literal"><span class="pre">--with-bz2</span></tt>).  Proper support may also need changes in <tt class="file docutils literal"><span class="pre">php.ini</span></tt>.</td></tr>
 114 </tbody>
 115 </table>
 116 </div>
 117 </div>
 118
 119
 120           </div>
 121         </div>
 122       </div>
 123       <div class="sphinxsidebar">
 124         <div class="sphinxsidebarwrapper">
 125   <h3><a href="index.html">Table Of Contents</a></h3>
 126   <ul>
 127 <li><a class="reference internal" href="#">Introduction</a><ul>
 128 <li><a class="reference internal" href="#supported-features">Supported features</a></li>
 129 <li><a class="reference internal" href="#a-word-about-users">A word about users</a></li>
 130 </ul>
 131 </li>
 132 </ul>
 133
 134   <h4>Previous topic</h4>
 135   <p class="topless"><a href="index.html"
 136                         title="previous chapter">Welcome to phpMyAdmin&#8217;s documentation!</a></p>
 137   <h4>Next topic</h4>
 138   <p class="topless"><a href="require.html"
 139                         title="next chapter">Requirements</a></p>
 140   <h3>This Page</h3>
 141   <ul class="this-page-menu">
 142     <li><a href="_sources/intro.txt"
 143            rel="nofollow">Show Source</a></li>
 144   </ul>
 145 <div id="searchbox" style="display: none">
 146   <h3>Quick search</h3>
 147     <form class="search" action="search.html" method="get">
 148       <input type="text" name="q" />
 149       <input type="submit" value="Go" />
 150       <input type="hidden" name="check_keywords" value="yes" />
 151       <input type="hidden" name="area" value="default" />
 152     </form>
 153     <p class="searchtip" style="font-size: 90%">
 154     Enter search terms or a module, class or function name.
 155     </p>
 156 </div>
 157 <script type="text/javascript">$('#searchbox').show(0);</script>
 158         </div>
 159       </div>
 160       <div class="clearer"></div>
 161     </div>
 162     <div class="related">
 163       <h3>Navigation</h3>
 164       <ul>
 165         <li class="right" style="margin-right: 10px">
 166           <a href="genindex.html" title="General Index"
 167              >index</a></li>
 168         <li class="right" >
 169           <a href="require.html" title="Requirements"
 170              >next</a> |</li>
 171         <li class="right" >
 172           <a href="index.html" title="Welcome to phpMyAdmin’s documentation!"
 173              >previous</a> |</li>
 174         <li><a href="index.html">phpMyAdmin 4.0.4 documentation</a> &raquo;</li>
 175       </ul>
 176     </div>
 177     <div class="footer">
 178         &copy; <a href="copyright.html">Copyright</a> 2012 - 2013, The phpMyAdmin devel team.
 179       Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 1.1.3.
 180     </div>
 181   </body>
 182 </html>