📄 documentation.html
字号:
<!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" xml:lang="en-US" lang="en-US"><!-- $Id: Documentation.html,v 2.205.2.21.2.2 2006/08/02 16:48:53 lem9 Exp $ --><!-- vim: expandtab ts=4 sw=4 sts=4 tw=78--><head> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>phpMyAdmin 2.8.2.1 - Documentation</title> <link rel="stylesheet" type="text/css" href="docs.css" /></head><body><a name="top"></a><br /><div class="header"><hr noshade="noshade" width="100%" /> <a href="#top">Top</a> - <a href="#require">Requirements</a> - <a href="#intro">Introduction</a> - <a href="#setup">Installation</a> - <a href="#setup_script">Setup script</a> - <a href="#config">Configuration</a> <br /> <a href="#transformations">Transformations</a> - <a href="#faq">FAQ</a> - <a href="#developers">Developers</a> - <a href="#credits">Credits</a> - <a href="translators.html">Translators</a><hr noshade="noshade" width="100%" /></div><h1>phpMyAdmin 2.8.2.1 Documentation</h1><!-- TOP MENU --><ul> <li> <a href="http://www.phpmyadmin.net/"> SourceForge phpMyAdmin project page [ http://www.phpmyadmin.net/ ] </a> </li> <li> Local documents: <ul> <li>Version history: <a href="changelog.php">ChangeLog</a></li> <li>General notes: <a href="readme.php">README</a></li> <li>License: <a href="license.php">LICENSE</a></li> </ul> </li> <li> Documentation version: <i>$Id: Documentation.html,v 2.205.2.21.2.2 2006/08/02 16:48:53 lem9 Exp $</i> </li></ul><!-- REQUIREMENTS --><a name="require"></a><br /><h2>Requirements</h2><ul> <li> <b>PHP</b> <ul> <li>You need PHP 4.1.0 or newer, with <tt>session</tt> support (<a href="#faq1_31">*</a>)</li> <li>You need GD2 support in PHP to display inline thumbnails of JPEGs ("image/jpeg: inline") with their original aspect ratio</li> <li>You need PHP 4.3.0 or newer to use the "text/plain: external" MIME-based transformation</li> </ul> </li> <li> <b>MySQL</b> 3.23.32 or newer (<a href="#faqmysqlversions">details</a>); </li> <li> Not really a requirement but a <b>strong suggestion</b>: if you are using the "cookie" authentication method, having the <tt>mcrypt</tt> PHP extension on your web server accelerates not only the login phase but every other action that you do in phpMyAdmin. </li> <li> <b>Web browser</b> with cookies enabled. </li></ul><!-- INTRODUCTION --><a name="intro"></a><br /><h2>Introduction</h2><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.<br /> Currently phpMyAdmin can:</p><ul> <li>easily browse through databases and tables</li> <li>create, copy, rename, alter and drop databases</li> <li>create, copy, rename, alter and drop tables</li> <li>do table maintenance</li> <li>add, edit and drop fields</li> <li>execute any SQL-statement, even multiple queries</li> <li>create, alter and drop indexes</li> <li>load text files into tables</li> <li>create (*) and read dumps of tables or databases</li> <li>export (*) data to SQL, CSV, XML, Word, Excel, PDF and Latex formats</li> <li>administer multiple servers</li> <li>manage MySQL users and privileges</li> <li>check server settings and runtime information with configuration hints</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 PDF 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>support InnoDB tables and foreign keys <a href="#faq3_6">(see FAQ 3.6)</a></li> <li>support mysqli, the improved MySQL extension <a href="#faqmysqlversions">(see FAQ 1.17)</a></li> <li> communicate in <a href="./translators.html">50 different languages</a> </li></ul><h4>A word about users:</h4><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="footnote" id="footnote_1"> <sup>1)</sup> phpMyAdmin can compress (Zip, GZip -RFC 1952- or Bzip2 formats) dumps and <abbr title="comma seperated values">CSV</abbr> exports if you use PHP with Zlib support (<tt>--with-zlib</tt>) and/or Bzip2 support (<tt>--with-bz2</tt>). Proper support may also need changes in <tt>php.ini</tt>.</p><!-- INSTALLATION --><a name="setup"></a><br /><h2>Installation</h2><p> <span class="important">NOTE: phpMyAdmin does not apply any special security methods to the MySQL database server. It is still the system administrator's job to grant permissions on the MySQL databases properly. </span>phpMyAdmin's "Privileges" page can be used for this.</p><p> <span class="important">Warning for Mac users:</span>if you are on a MacOS version before OS X, StuffIt unstuffs with Mac formats.<br /> So you'll have to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before uploading them to your server, as PHP seems not to like Mac-style end of lines character ("<tt>\r</tt>").</p><h3>Quick Install</h3><ol> <li> Untar or unzip the distribution (be sure to unzip the subdirectories): <tt>tar -xzvf phpMyAdmin_x.x.x.tar.gz</tt> in your webserver's document root. If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 3, transfer the directory on your web server using, for example, ftp.</li> <li> Ensure that all the scripts have the appropriate owner (if PHP is running in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem). See <a href="#faq4_2">FAQ 4.2</a> and <a href="#faq1_26">FAQ 1.26</a> for suggestions.</li> <li>Now you must configure your installation. There are two methods that can be used. Traditionally, users have hand-edited a copy of config.inc.php, but now a wizard-style setup script is provided for those who prefer a graphical installation. Creating a config.inc.php is still a quick way to get started and needed for some advanced features. <ul><li>To manually create the file, simply use your text editor to create the file <tt>config.inc.php</tt> in the main (top-level) phpMyAdmin directory (the one that contains <tt>index.php</tt>). phpMyAdmin first loads <tt>libraries/config.default.php</tt> and then overrides those values with anything found in <tt>config.inc.php</tt>. If the default value is okay for a particular setting, there is no need to include it in <tt>config.inc.php</tt>. You'll need a few directives to get going, a simple configuration may look like this:<pre><?php$cfg['blowfish_secret'] = 'ba17c1ec07d65003'; // use here a value of your choice$i=0;$i++;$cfg['Servers'][$i]['auth_type'] = 'cookie';?></pre> Or, if you prefer to not be prompted every time you log in:<pre><?php$i=0;$i++;$cfg['Servers'][$i]['user'] = 'root';$cfg['Servers'][$i]['password'] = 'cbb74bc'; // use here your password?></pre> For a full explanation of possible configuration values, see the <a href="#config">Configuration Section</a> of this document.</li> <li id="setup_script">Instead of manually editing <tt>config.inc.php</tt>, you can use the <a href="scripts/setup.php">Setup Script</a>. First you must manually create a folder <tt>config</tt> in the phpMyAdmin directory. This is a security measure. On a Linux/Unix system you can use the following commands:<pre>cd phpMyAdminmkdir config # create directory for savingchmod o+rw config # give it world writable permissions</pre> And to edit an existing configuration, copy it over first:<pre>cp config.inc.php config/ # copy current configuration for editingchmod o+w config/config.inc.php # give it world writable permissions</pre> On other platforms, simply create the folder and ensure that your web server has read and write access to it. <a href="#faq1_26">FAQ 1.26</a> can help with this.<br /><br /> Next, open <tt><a href="scripts/setup.php">scripts/setup.php</a> </tt>in your browser. Note that <strong>changes are not saved to disk until explicitly choose <tt>Save</tt></strong> from the <i>Configuration</i> area of the screen. Normally the script saves the new config.inc.php to the <tt>config/</tt> directory, but if the webserver does not have the proper permissions you may see the error "Cannot load or save configuration." Ensure that the <tt> config/</tt> directory exists and has the proper permissions - or use the <tt>Download</tt> link to save the config file locally and upload (via FTP or some similar means) to the proper location.<br /><br /> Once the file has been saved, it must be moved out of the <tt> config/</tt> directory and the permissions must be reset, again as a security measure:<pre>mv config/config.inc.php . # move file to current directorychmod o-rw config.inc.php # remove world read and write permissions</pre> Now the file is ready to be used. You can choose to review or edit the file with your favorite editor, if you prefer to set some advanced options which the setup script does not provide.</li></ul></li> <li> If you are using the <tt>auth_type</tt> configuration directive, it is suggested that you protect the phpMyAdmin installation directory, for example with HTTP–AUTH in a <i>.htaccess</i> file. See the <a href="#faqmultiuser"> multi–user sub–section</a> of this FAQ for additional information, especially <a href="#faq4_4">FAQ 4.4</a>.</li> <li>Open the <a href="index.php">main phpMyAdmin directory</a> in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using <abbr title="HyperText Transfer Protocol">HTTP</abbr> or cookie authentication mode.</li> <li> You should deny access to the <tt>libraries</tt> subfolder in your webserver configuration. For Apache you can use supplied .htaccess file in that folder, for other webservers, you should configure this yourself. Such configuration prevents from possible path exposure and cross side scripting vulnerabilities that might happen to be found in that code.</li></ol><a name="linked-tables"></a><h3>Linked-tables infrastructure</h3> <p> For a whole set of new features (bookmarks, comments, SQL-history, PDF-generation, field contents transformation, etc.) you need to create a set of special tables. Those tables can be located in your own database, or in a central database for a multi-user installation (this database would then be accessed by the controluser,⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -